How to insert Update Delete In MVC Using jQuery
$("#fileupload").hide();
$("#ddlAEemprole").on('change', function () {
debugger
$("#fileupload").show();
});
function Savedata() {
$("#tblmdltitle").text("Employee : Add");
debugger
var nmode = 0;
if ($("#hdnAEEmployee").val() == "") {
nmode = 1;
}
else {
nmode = 4;
}
var Empid = 0;
if ($("#hdnAEEmployee").val() != "") {
var Empid = $("#hdnAEEmployee").val();
}
var file = document.getElementById("inputfile").files[0];
var data = new FormData();
data.append("studImg", file);
data.append("mode", nmode);
data.append("Empids", Empid);
data.append("Fname", $("#txtAEFirstName").val());
data.append("Lname", $("#txtAELasttName").val());
data.append("DOB", $("#txtAEdob").val());
data.append("Address", $("#txtAEaddress").val());
data.append("Userrole", $("#ddlAEemprole").val());
data.append("Mobile", $("#txtAEmobile").val());
data.append("CurrentLocation", $("#txtAECurrentLocation").val());
data.append("PinCode", $("#txtAEpincode").val());
$.ajax({
url: $("#frmAEemployee").attr('data-saveurl'),
type: 'POST',
cache: false,
contentType: false,
processData: false,
data: data,
dataType: 'json',
beforeSend: function () {
$("#contributionSpinner").show();
},
success: function (data) {
debugger
if (data == "Save" || data == "Update") {
swal({
title: "Employee",
text: "<p class='lead text-muted'>" + " Record " + data + " successfully" + " </p>",
type: "success",
showCancelButton: false,
html: true,
confirmButtonClass: 'btn-success',
confirmButtonText: 'OK'
}, function () {
swal.close();
ClearSubmit();
});
}
else {
swal({
title: "Employee",
text: "<p class='lead text-muted'>" + data + " </p>",
type: "error",
showCancelButton: false,
html: true,
confirmButtonClass: 'btn-success',
confirmButtonText: 'OK'
});
}
},
complete: function () {
$("#contributionSpinner").hide();
$("#btnsaveEmployee").removeAttr("disabled");
},
error: function (jqXHR, exception) {
$("#contributionSpinner").hide();
$("#btnsaveEmployee").removeAttr("disabled");
swal("Employee", getErrorMessage(jqXHR, exception), "error");
},
});
}
C# code:-
public ActionResult SaveEmployee(FormCollection fc, HttpPostedFileBase studImg)
{
var Empid = Convert.ToInt16(fc["Empids"]);
var nmode = Convert.ToInt16(fc["mode"]);
var Fname = fc["Fname"].ToString();
var Lname = fc["Lname"].ToString();
var DOB = fc["DOB"].ToString();
var Address = fc["Address"].ToString();
var Userrole = fc["Userrole"].ToString();
//var File = fc["files"].ToString();
var Mobile = fc["Mobile"].ToString();
var CurrentLocation = fc["CurrentLocation"].ToString();
var PinCode = fc["PinCode"].ToString();
dynamic dd;
try
{
string Filename = "";
var allowedExtensions = new[] { ".Jpg", ".png", ".jpg", "jpeg" };
string FN = "";
FN = Path.GetFileName(studImg.FileName);
var ext = Path.GetExtension(studImg.FileName);
if (allowedExtensions.Contains(ext))
{
string name = Path.GetFileNameWithoutExtension(FN);
var datetime = DateTime.Now.Millisecond;
Filename = name + "_" + datetime + ext;
var path = Path.Combine(Server.MapPath("~/FileUpload"), Filename);
studImg.SaveAs(path);
}
EmployeeLogicLayer emplogic = new EmployeeLogicLayer();
dd = emplogic.SaveData(Empid, Fname, Lname, DOB, Address, Userrole, Mobile, CurrentLocation, PinCode, nmode, Filename, Convert.ToString(Session["UserName"]));
return Json(dd);
}
catch (Exception ex)
{
return Json(new { result = ex.Message.ToString() });
}
}
Step1:- Datatabse Code:-
create database Test_mvc
use Test_mvc
Create Table Emploeyee
(
Empid int primary key identity(1,1),
Name Varchar(50),
Age int,
Address Varchar(50),
Salary float,
FkCid int,
)
create table Country
(
Cid int primary Key identity(1,1),
Cname varchar(50)
)
select * from Emploeyee
select * from Country
insert into Country values('India')
insert into Country values('USA')
insert into Country values('Japan')
insert into Country values('Canada')
CREATE proc [dbo].[PrMST_User]
@UsersId int='',
@nMode int,
@UserFirstName nvarchar(100)='',
@UserLastName nvarchar(100)='',
@EmailId nvarchar(100)='',
@Phone nvarchar(20)='',
@Password nvarchar(100)='',
@Role int='',
@Alias nvarchar (50)='',
@Remark varchar(100)='',
@SortBy int='',
@Status int='',
@CreatedBy varchar(50)='',
@Clients_ID varchar(50)=''
as
begin
BEGIN TRY
BEGIN TRAN
DECLARE @ERR VARCHAR(1000)='',@cCMD VARCHAR(MAX),@ERRNO INT
IF @nMode=1--SAVE Data
BEGIN
INSERT tbl_AddUsers(UserFirstName,UserLastName,EmailId,Phone,Password,Role,Alias,Remark,SortBy,Status,CreatedBy,Create_Date,ModifiedBy,Modified)
SELECT @UserFirstName,@UserLastName,@EmailId,@Phone ,@Password,@Role,@Alias,@Remark,@SortBy,@Status,@CreatedBy,GETDATE(),'',NULL
END
IF @nMode=2--bind Daata
BEGIN
select tbl_AddUsers.*,role.UserRoleId, role.UserRoleName from tbl_AddUsers inner join tbl_AddUserRole as role on tbl_AddUsers.Role=role.UserRoleId
END
IF @nMode=3--bind Dropdown List
BEGIN
select UserRoleId,UserRoleName from tbl_AddUserRole
END
IF @nMode=4--Edit
BEGIN
select tbl_AddUsers.*,role.UserRoleId, role.UserRoleName from tbl_AddUsers inner join tbl_AddUserRole as role on tbl_AddUsers.Role=role.UserRoleId where UsersId=@UsersId
END
IF @nMode=5--Deltete
BEGIN
delete from tbl_AddUsers where UsersId = @UsersId
END
IF @nMode=6--Edit_Grid
BEGIN
--update Employee set name=@name,Gender=@Gender,country=@country,age=@age,address=@address where empid=@empid
update tbl_AddUsers set UserFirstName= @UserFirstName,UserLastName=@UserLastName,EmailId=@EmailId,Phone=@Phone ,Password=@Password,Role=@Role,Alias=@Alias,Remark=@Remark,
SortBy=@SortBy,Status=@Status,ModifiedBy=@CreatedBy,Modified=GETDATE() where UsersId=@UsersId
END
IF @nMode=7--bind Dropdown List Users
BEGIN
select UsersId,UserFirstName from tbl_AddUsers where CreatedBy = @Clients_ID
END
IF @nMode=8--bind Dropdown List Users
BEGIN
select ClientId ,UserFirstName from Registration where Clients_ID = @Clients_ID
END
END TRY
BEGIN CATCH
SELECT @ERRNO=@@ERROR ,@ERR=ERROR_MESSAGE()
PRINT @ERRNO
PRINT @ERR
--IF @ERR LIKE '%UsersId%'--@ERRNO=2627--PK
-- EXEC PrMST_ErrorHandler @nMode,@ERRNO,@ERR,'Alias',@Alias,@ERR OUTPUT
END CATCH
IF ISNULL(@ERR,'')=''
COMMIT
ELSE
ROLLBACK
SELECT @ERR ERR_MSG,CASE ISNULL(@ERR,'') WHEN '' THEN 'SUCCESS'
ELSE 'FAILED' END [STATUS]
EXT:
SET NOCOUNT OFF
END--Procedure PrMST_User Ends
GO
//------------------------------------------------------END-------------------------------------------//
Step 2:- Controller Code.
//--------------------------------------------------CONTROLLER CODE STATR--------------------------//
#region AddUser
[HttpPost]
public ActionResult SaveUsers(int UserId, string FirstName, string LastName, string EmailId, string Phone, string Password, string Role, string Alias, string Remark, int SortBy, int Status, int nmode)
{
try
{
dynamic Obj_data;
MiscellaneousLogicLayer.AddUsers _Objmis = new MiscellaneousLogicLayer.AddUsers();
Obj_data = _Objmis.SaveUserData(UserId, FirstName, LastName, EmailId, Phone, Password, Role, Alias, Remark, SortBy, Status, nmode, Convert.ToString(Session["ClientId"]));
return Json(new { result = Obj_data });
//return Json(new { result = Newtonsoft.Json.JsonConvert.SerializeObject(Obj_data) }, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
return Json(new { result = ex.Message.ToString() });
}
}
[HttpGet]
public ActionResult BindUsers(int nmode)
{
DataTable dt = new DataTable();
try
{
MiscellaneousLogicLayer.AddUsers _Objmis = new MiscellaneousLogicLayer.AddUsers();
dt = _Objmis.BindData(nmode);
if (dt != null)
{
return Json(new { result = Newtonsoft.Json.JsonConvert.SerializeObject(dt) }, JsonRequestBehavior.AllowGet);
}
}
catch (Exception)
{
throw;
}
return View();
}
[HttpGet]
public ActionResult UserRoleBind(int nmode)
{
DataTable dt = new DataTable();
try
{
MiscellaneousLogicLayer.AddUsers _Objmis = new MiscellaneousLogicLayer.AddUsers();
dt = _Objmis.UserRoleBind(nmode);
if (dt != null)
{
return Json(new { result = Newtonsoft.Json.JsonConvert.SerializeObject(dt) }, JsonRequestBehavior.AllowGet);
}
}
catch (Exception)
{
throw;
}
return View();
}
[HttpGet]
public ActionResult GetAddUsersData(int nmode, int UsersId)
{
DataTable dt = new DataTable();
try
{
MiscellaneousLogicLayer.AddUsers _Objmis = new MiscellaneousLogicLayer.AddUsers();
dt = _Objmis.GetAddUsersData(nmode, UsersId);
if (dt != null)
{
return Json(new { result = Newtonsoft.Json.JsonConvert.SerializeObject(dt) }, JsonRequestBehavior.AllowGet);
}
}
catch (Exception)
{
throw;
}
return View();
}
[HttpGet]
public ActionResult DeleteAddUsersData(int nmode, int UsersId)
{
try
{
dynamic obj;
MiscellaneousLogicLayer.AddUsers _Objmis = new MiscellaneousLogicLayer.AddUsers();
obj = _Objmis.DeleteAddUsersData(nmode, UsersId);
if (obj != null)
{
return Json(new { result = Newtonsoft.Json.JsonConvert.SerializeObject(obj) }, JsonRequestBehavior.AllowGet);
}
}
catch (Exception)
{
throw;
}
return View();
}
#endregion AddUser
Step 3: Logic layer Code:-
//--------------------------------------START LOGIC LAYER CODE--------------------------------------//
public class AddUsers
{
private SchoolManagementSystemdbcontext _db = new SchoolManagementSystemdbcontext();
private IDbConnection _dd = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolManagementSystemdbcontext"].ConnectionString);
public dynamic SaveUserData(int UserId, string FirstName, string LastName, string EmailId, string Phone, string Password, string Role, string Alias, string Remark, int SortBy, int Status, int nmode, string UserName)
{
string strResult = "FOUND SERVER ERROR FROM SQL SERVER";
dynamic result;
try
{
var pp = new DynamicParameters();
pp.Add("@UsersId", UserId);
pp.Add("@nMode", nmode);
pp.Add("@UserFirstName", FirstName);
pp.Add("@UserLastName", LastName);
pp.Add("@EmailId", EmailId);
pp.Add("@Phone", Phone);
pp.Add("@Password", Password);
pp.Add("@Role", Role);
pp.Add("@Alias", Alias);
pp.Add("@Remark", Remark);
pp.Add("@SortBy", SortBy);
pp.Add("@Status", Status);
pp.Add("@CreatedBy", UserName);
result = this._dd.Query<dynamic>("PrMST_User", pp, commandType: CommandType.StoredProcedure);
if (result.Count > 0)
{
foreach (var item in result)
{
if (item.ERR_MSG == "")
{
//strResult = !string.IsNullOrWhiteSpace(Convert.ToString(UserId)) ? "updated" : "saved";
strResult = !string.IsNullOrEmpty(Convert.ToString(UserId)) ? "saved" : "updated";
}
else
{
strResult = item.ERR_MSG;
}
}
}
}
catch (Exception ex)
{
return ex.Message + "ERROR: " + strResult;
throw;
}
return strResult;
}
public DataTable BindData(int nmode)
{
try
{
commanmstcs obj_dt = new commanmstcs();
DataTable dt = new DataTable();
string strQuery = "EXEC PrMST_User @nmode='" + nmode + "'";
dt = obj_dt.fnReturnDatatable(strQuery);
return dt;
}
catch (Exception ex)
{
HttpContext.Current.Response.Write(ex.Message);
return null;
}
}
public DataTable UserRoleBind(int nmode)
{
try
{
commanmstcs obj_dt = new commanmstcs();
DataTable dt = new DataTable();
string strQuery = "EXEC PrMST_User @nmode='" + nmode + "'";
dt = obj_dt.fnReturnDatatable(strQuery);
return dt;
}
catch (Exception ex)
{
HttpContext.Current.Response.Write(ex.Message);
return null;
}
}
public DataTable GetAddUsersData(int nmode, int UsersId)
{
try
{
commanmstcs obj_dt = new commanmstcs();
DataTable dt = new DataTable();
string strQuery = "EXEC PrMST_User @nmode='" + nmode + "', @UsersId='" + UsersId + "'";
dt = obj_dt.fnReturnDatatable(strQuery);
return dt;
}
catch (Exception ex)
{
HttpContext.Current.Response.Write(ex.Message);
return null;
}
}
public dynamic DeleteAddUsersData(int nmode, int UsersId)
{
string strResult = "FOUND SERVER ERROR FROM SQL SERVER";
dynamic result;
try
{
var pp = new DynamicParameters();
pp.Add("@UsersId", UsersId);
pp.Add("@nMode", nmode);
result = this._dd.Query<dynamic>("PrMST_User", pp, commandType: CommandType.StoredProcedure);
if (result.Count > 0)
{
foreach (var item in result)
{
if (!string.IsNullOrWhiteSpace(item.ERR_MSG))
{
strResult = item.ERR_MSG;
}
}
}
}
catch (Exception ex)
{
dynamic except = ex.Message + "ERROR:" + strResult;
return except;
}
return result;
}
}
//-----------------------------------END LOGIC LAYER CODE---------------------------------//
Step 4: View Code--
//---------------------------------------------START VIEW CODE ------------------------------------------//
<div class="modal-dialog modal-custom modal-md" role="document">
<form method="" class="form-horizontal" data-saveurl="@Url.Action("SaveUsers", "Miscellaneous")" id="frmAEAddUser">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title">
<span id="lblMdlTitle"> </span><small class="mandatory-title">* Indicates Mandatory Fields</small>
</h5>
<button type="button" class="close frmAEClose" aria-hidden="true">×</button>
</div>
<div class="modal-body modal-body-custom">
<div class="row">
<div class="col-xs-12 col-sm-12 col-md-12 col-sm-12">
<div class="row">
<div class="col-xs-12 col-sm-12 col-md-12">
<div class="form-group row">
<label class="col-lg-4 col-form-label col-form-label-sm">First Name<sup class="text-danger">*</sup></label>
<div class="col-lg-8">
<input type="text" class="form-control form-control-sm checkSpcialChar" name="txtAEFirstName" id="txtAEFirstName" autocomplete="off">
</div>
</div>
</div>
<div class="col-xs-12 col-sm-12 col-md-12">
<div class="form-group row">
<label class="col-lg-4 col-form-label col-form-label-sm">Last Name<sup class="text-danger">*</sup></label>
<div class="col-lg-8">
<input type="text" class="form-control form-control-sm checkSpcialChar" name="txtAELastName" id="txtAELastName" autocomplete="off">
</div>
</div>
</div>
<div class="col-xs-12 col-sm-12 col-md-12">
<div class="form-group row">
<label class="col-lg-4 col-form-label col-form-label-sm">Email<sup class="text-danger">*</sup></label>
<div class="col-lg-8">
<input type="text" class="form-control form-control-sm checkSpcialChar" name="txtAEEmail" id="txtAEEmail" autocomplete="off">
</div>
</div>
</div>
<div class="col-xs-12 col-sm-12 col-md-12">
<div class="form-group row">
<label class="col-lg-4 col-form-label col-form-label-sm">Phone<sup class="text-danger">*</sup></label>
<div class="col-lg-8">
<input type="text" class="form-control form-control-sm inputNumber" name="txtAEPhone" id="txtAEPhone" autocomplete="off" maxlength="10">
</div>
</div>
</div>
<div class="col-xs-12 col-sm-12 col-md-12">
<div class="form-group row">
<label class="col-lg-4 col-form-label col-form-label-sm">Password<sup class="text-danger">*</sup></label>
<div class="col-lg-8">
<input type="text" class="form-control form-control-sm" name="txtAEPassword" id="txtAEPassword" autocomplete="off">
</div>
</div>
</div>
<div class="col-xs-12 col-sm-12 col-md-12">
<div class="form-group row">
<label class="col-lg-4 col-form-label col-form-label-sm">Confirm Password<sup class="text-danger">*</sup></label>
<div class="col-lg-8">
<input type="text" class="form-control form-control-sm" name="txtAECPassword" id="txtAECPassword" autocomplete="off" >
</div>
</div>
</div>
@*<div class="col-xs-12 col-sm-12 col-md-12">
<div class="form-group row">
<label class="col-lg-4 col-form-label col-form-label-sm">User Role<sup class="text-danger">*</sup></label>
<div class="col-lg-8">
<input type="text" class="form-control form-control-sm" name="txtAEUserRole" id="txtAEUserRole" autocomplete="off">
</div>
</div>
</div>*@
<div class="col-xs-12 col-sm-12 col-md-12">
<div class="form-group row">
<label class="col-md-4 col-form-label col-form-label-sm">User Role<sup class="text-danger">*</sup></label>
<div class="col-md-8">
<select class="form-control form-control-sm" data-saveurl="@Url.Action("UserRoleBind", "Miscellaneous")" id="ddlAEUserRole" name="ddlAEUserRole" title="Nothing selected" data-actions-box="true" data-live-search="true" data-size="5"></select>
</div>
</div>
</div>
<div class="col-xs-12 col-sm-12 col-md-12">
<div class="form-group row">
<label class="col-lg-4 col-form-label col-form-label-sm">Alias<sup class="text-danger">*</sup></label>
<div class="col-lg-8">
<input type="text" class="form-control form-control-sm" name="txtAEAlias" id="txtAEAlias" autocomplete="off">
</div>
</div>
</div>
<div class="col-xs-12 col-sm-12 col-md-12">
<div class="form-group row">
<label class="col-lg-4 col-form-label col-form-label-sm">Remark<sup class="text-danger">*</sup></label>
<div class="col-lg-8">
<input type="text" class="form-control form-control-sm" name="txtAERemark" id="txtAERemark" autocomplete="off" maxlength="100">
</div>
</div>
</div>
<div class="col-xs-12 col-sm-12 col-md-12">
<div class="form-group row">
<label class="col-lg-4 col-form-label col-form-label-sm">SortBy<sup class="text-danger">*</sup></label>
<div class="col-lg-8">
<input type="text" class="form-control form-control-sm checkSpcialChar inputNumber" name="txtAESortBy" id="txtAESortBy" autocomplete="off" maxlength="3">
</div>
</div>
</div>
<div class="col-xs-12 col-sm-12 col-md-12">
<div class="form-group row">
<label class="col-lg-4 col-form-label col-form-label-sm">Status<sup class="text-danger">*</sup></label>
<div class="col-lg-8">
<input type="checkbox" name="chkbtnAEStatus" id="chkbtnAEStatus" value="remember-me">
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="modal-footer">
<input type="hidden" id="hdnAEUserId" />
<input type="hidden" id="hdnAEAddUsersEdit" data-saveurl="@Url.Action("GetAddUsersData", "Miscellaneous")" />
<input type="hidden" id="hdndeletedataAddUsers" data-saveurl="@Url.Action("DeleteAddUsersData", "Miscellaneous")" />
<input type="hidden" id="hdnbindUserdata" data-saveurl="@Url.Action("BindUsers", "Miscellaneous")" />
<button type="submit" class="btn btn-radius lightGray btn-info" id="btnsaveUser"><i class="fas fa-save"></i> Save changes</button>
<button type="button" id="btnAEResetUser" class="btn btn-radius btn-danger"><i class="fas fa-sync-alt"></i> Reset</button>
<button type="button" class="btn btn-radius btn-danger frmAEClose" id="btnClose"><i class="fas fa-times"></i> Close</button>
</div>
</div>
</form>
</div>
//--------------------------------------------END VIEW CODE----------------------------------------------//
Step 5:- Jquery Code-
//--------------------------------------------------START jQuery CODE-------------------------------//
$(document).ready(function () {
$("#txtAEFirstName").focus();
$('#frmAEAddUser').bootstrapValidator({
fields: {
txtAEFirstName: { validators: { notEmpty: {} } },
txtAEEmail: {
validators: {
notEmpty: {
message: 'The email address is required'
},
regexp: {
regexp: '^[^@\\s]+@([^@\\s]+\\.)+[^@\\s]+$',
}
}
},
txtAEPhone: { validators: { notEmpty: {} } },
txtAEPassword: { validators: { notEmpty: {} } },
txtAECPassword: { validators: { notEmpty: {} } },
txtAEUserRole: { validators: { notEmpty: {} } },
}
}).on('success.form.bv', function (e) {
e.preventDefault();
SaveDataUsers();
});
$(".inputNumber").keypress(function (e) {
if (e.which != 8 && e.which != 0 && (e.which < 48 || e.which > 57)) {
return false;
}
});
$("#contributionSpinner").hide();
//Binddata();
$(".frmAEClose").on("click", function () {
swal({
title: "Are you sure?",
text: "Do you sure to close this model !",
type: "warning",
showCancelButton: true,
confirmButtonClass: 'btn-primary',
confirmButtonText: 'Yes, I am sure!',
cancelButtonText: "No, cancel it!",
closeOnConfirm: false,
closeOnCancel: false
}, function (isConfirm) {
if (isConfirm) {
$('#hdnAEUserId').val('');
swal.close();
Clear_submit();
$("#dvmdlusers").modal('hide');
}
else {
swal.close();
$("#txtAEFirstName").focus();
$("#dvmdlusers").modal('show');
}
});
});
$("#hrefadduser").on("click", function () {
$("#txtAEFirstName").focus();
$("#lblMdlTitle").text("Student : ADD");
$("#btnClose").hide();
$("#btnAEResetUser").show();
Clear_submit();
});
$("#btnAEResetUser").on("click", function () {
swal({
title: "Are you sure?",
text: "Do you sure to Reset this record !",
type: "warning",
showCancelButton: true,
confirmButtonClass: 'btn-primary',
confirmButtonText: 'Yes, I am sure!',
cancelButtonText: "No, cancel it!",
closeOnConfirm: false,
closeOnCancel: false
}, function (isConfirm) {
if (isConfirm) {
Clear_submit();
swal.close();
$("#txtAEFirstName").focus();
}
else {
swal.close();
$("#txtAEFirstName").focus();
}
})
});
function keypressHandler(e) {
if (e.which == 13) {
e.preventDefault(); //stops default action: submitting form
$(this).blur();
$('#btnsaveUser').focus().click();//give your submit an ID
}
}
$('#dvmdlusers').keypress(keypressHandler);
$(".inputNumber").keypress(function (e) {
if (e.which != 8 && e.which != 0 && (e.which < 48 || e.which > 57)) {
return false;
}
});
Bindata();
BindddlUserRole();
$(".frmAEClose").on("click", function () {
$("#hdnAEUserId").val("");
});
});
function SaveDataUsers() {
debugger
var WindowPrevent = window.onkeydown;
var sFirstName = $("#txtAEFirstName").val();
var sLastName = $("#txtAELastName").val();
var sEmail = $("#txtAEEmail").val();
var sPhone = $("#txtAEPhone").val();
var sPassword = $("#txtAEPassword").val();
var sCPassword = $("#txtAECPassword").val();
var mode = 0;
if ($("#hdnAEUserId").val() == "") {
mode = 1;
}
else {
mode = 6;
}
if (sPassword != sCPassword) {
swal({
title: "User PassWord",
text: "<p class='lead text-muted'>" + "Don't Match Password & Confirm Password " + " </p>",
type: "error",
showCancelButton: false,
html: true,
confirmButtonClass: 'btn-success',
confirmButtonText: 'OK'
});
return
}
if (sPassword.length <= 5) {
swal({
title: "User Password",
text: "<p class='lead text-muted'>" + "Password Should be enter 6 character minimum " + " </p>",
type: "error",
showCancelButton: false,
html: true,
confirmButtonClass: 'btn-success',
confirmButtonText: 'OK'
});
return
}
var sUserRole = $("#ddlAEUserRole").val();
var sAlias = $("#txtAEAlias").val();
var sRemark = $("#txtAERemark").val();
var sSortBy = $("#txtAESortBy").val();
var chkstatus = 0;
if ($("#chkbtnAEStatus").is(':checked')) {
chkstatus = 1;
}
var tt = 0;
if ($("#hdnAEUserId").val() != "") {
var tt = $("#hdnAEUserId").val();
}
swal({
title: "Are you sure?",
text: "Do you sure to Save this record !",
type: "warning",
showCancelButton: true,
allowEnterKey: true,
confirmButtonColor: '#DD6B55',
cancelButtonColor: '#d33',
confirmButtonText: 'Yes, I am sure!',
cancelButtonText: "No, cancel it!",
closeOnConfirm: false,
closeOnCancel: false
}, function (isConfirm) {
if (isConfirm) {
window.onkeydown = WindowPrevent;
$.ajax({
url: $("#frmAEAddUser").attr('data-saveurl'),
type: 'POST',
cache: false,
data: { "UserId": tt, "FirstName": sFirstName, "LastName": sLastName, "EmailId": sEmail, "Phone": sPhone, "Password": sPassword, "Role": sUserRole, "Alias": sAlias, "Remark": sRemark, "SortBy": sSortBy, "Status": chkstatus, "nmode": mode },
dataType: 'json',
beforeSend: function () {
$("#contributionSpinner").show();
},
success: function (data) {
debugger
if (data.result.toString() == "saved" || data.result.toString() == "updated") {
swal({
title: "Add Users",
text: "<p class='lead text-muted'>" + " Record " + data.result.toString() + " successfully" + " </p>",
type: "success",
showCancelButton: false,
html: true,
confirmButtonClass: 'btn-success',
confirmButtonText: 'OK'
}, function () {
swal.close();
Clear_submit();
Bindata();
});
} else {
swal({
title: "Add Users",
text: "<p class='lead text-muted'>" + data.result.toString() + " </p>",
type: "error",
showCancelButton: false,
html: true,
confirmButtonClass: 'btn-success',
confirmButtonText: 'OK'
});
}
},
complete: function () {
$("#contributionSpinner").hide();
$("#btnsaveUser").removeAttr("disabled");
},
error: function (jqXHR, exception) {
$("#contributionSpinner").hide();
$("#btnsaveUser").removeAttr("disabled");
swal("Add User", getErrorMessage(jqXHR, exception), "error");
}
});
}
else {
$("#btnsaveUser").removeAttr("disabled");
swal({
title: "Add User Role",
text: "This Record Not Saved",
type: "error",
showCancelButton: false,
html: true,
confirmButtonClass: 'btn-danger',
confirmButtonText: 'OK'
});
}
});
}
function Bindata() {
if ($.fn.DataTable.isDataTable("#tblbindUsers")) {
$("#tblbindUsers").DataTable().clear().destroy();
}
$.ajax({
url: $("#hdnbindUserdata").attr('data-saveurl'),
type: 'GET',
data: { "nmode": 2 },
dataType: 'json',
beforeSend: function () {
$("#contributionSpinner").show();
},
success: function (data) {
debugger
var Objdata = $.parseJSON(data.result);
if (Objdata != null) {
if (Objdata.length > 0) {
var tr = "";
var id = "";
$.each(Objdata, function (key, value) {
var id = "" + value.UsersId + "";
tr += '<tr role="row" class="trinput' + key + '">';
tr += "<td>";
tr += "<a id='" + value.UsersId + "'data-toggle='modal' href='#dvmdlusers' onclick='UsersGetData(" + id + ")' class= 'btn btn-xs tbl-btn lightGray' title='Edit'><i class='fas fa-edit'></i></a> <a onclick='DeleteData(" + id + ")' title='Delete' class= 'btn btn-xs tbl-btn btn-danger'><i class='fas fa-times'></i></a></td>";
tr += "<td>" + value.UserFirstName + "</td>";
tr += "<td>" + value.UserLastName + "</td>";
tr += "<td>" + value.EmailId + "</td>";
tr += "<td>" + value.Phone + "</td>";
tr += "<td>" + value.UserRoleName + "</td>";
tr += "<td>" + value.Alias + "</td>";
tr += "<td>" + value.SortBy + "</td>";
tr += "</tr>";
});
}
}
$('#tblbindUsers').append(tr);
},
complete: function () {
$("#contributionSpinner").hide();
$('#tblbindUsers').DataTable('refersh');
$('#tblbindUsers').DataTable({
language: { "emptyTable": "No data available in table" },
scrollX: true,
paging: true,
"iDisplayLength": 15,
"bFilter": true,
"bLengthChange": false,
destroy: true,
searching: false
});
},
error: function (jqXHR, exception) {
debugger
$("#contributionSpinner").hide();
swal("User Add", getErrorMessage(jqXHR, exception), "error");
}
});
}
function BindddlUserRole() {
$("#ddlAEUserRole option").remove();
$("#ddlAEUserRole").append($("<option></option>").val("").html("Nothing selected"))
$.ajax({
url: $("#ddlAEUserRole").attr('data-saveurl'),
type: 'GET',
data: { "nmode": 3 },
dataType: 'json',
beforeSend: function () {
$("#contributionSpinner").show();
},
beforeSend: function () {
$("#contributionSpinner").show();
},
success: function (data) {
$("#ddlAEUserRole option").empty().append($("<option></option>").val("").html("Nothing selected"));
var getuserrole = $.parseJSON(data.result);
$.each(getuserrole, function (key, value) {
$("#ddlAEUserRole").append($("<option></option>").val(value.UserRoleId).html(value.UserRoleName));
//$("#ddlAEState").append("<option value=" + value.Sid + ">" + value.Sname + "</option>");
});
},
complete: function () {
$("#contributionSpinner").hide();
},
error: function () {
swal("Do not bind User Role ", getErrorMessage(jqXHR, exception), "error");
}
});
}
function UsersGetData(id) {
}
function UsersGetData(UsersId) {
debugger
$("#lblMdlTitle").text("Add Users : Edit");
$("#btnAEResetUser").hide();
if (UsersId == "") {
return
}
$("#btnClose").show();
$.ajax({
url: $("#hdnAEAddUsersEdit").attr('data-saveurl'),
type: 'GET',
data: { "nmode": 4, "UsersId": UsersId },
dataType: 'JSON',
beforeSend: function () {
$("#contributionSpinner").show();
},
success: function (tt) {
var data = $.parseJSON(tt.result);
if (data != null) {
$.each(data, function (key, value) {
$("#hdnAEUserId").val(value.UsersId);
$("#txtAEFirstName").val(value.UserFirstName);
$("#txtAELastName").val(value.UserLastName);
$("#txtAEEmail").val(value.EmailId);
$("#txtAEPhone").val(value.Phone);
$("#txtAEPassword").val(value.Password);
$("#txtAECPassword").val(value.Password);
BindddlUserRole();
//$("#ddlAEUserRole").val(value.Role);
$("#txtAEAlias").val(value.Alias);
$("#txtAERemark").val(value.Remark);
$("#txtAESortBy").val(value.SortBy);
$("#chkbtnAEStatus").prop("checked", true);
if (value.Status == "0") {
$("#chkbtnAEStatus").prop("checked", false);
}
});
}
},
complete: function () {
$("#contributionSpinner").hide();
},
error: function (jqXHR, exception) {
$("#contributionSpinner").hide();
swal("Add Users", getErrorMessage(jqXHR, exception), "error");
}
});
}
function DeleteData(UsersId) {
debugger
if (UsersId == "") {
return
}
swal({
title: "Are you sure ?",
text: "Do you sure to delete selected record !",
type: "warning",
showCancelButton: true,
confirmButtonClass: 'btn-primary',
confirmButtonText: 'Yes, I am sure!',
cancelButtonText: "No, cancel it!",
closeOnConfirm: false,
closeOnCancel: false
}, function (isConfirm) {
if (isConfirm) {
$.ajax({
url: $("#hdndeletedataAddUsers").attr('data-saveurl'),
data: { "nmode": 5, "UsersId": UsersId },
cache: false,
type: 'GET',
dataType: 'json',
beforeSend: function () {
$("#contributionSpinner").show();
},
success: function (data) {
debugger
var objresult = $.parseJSON(data.result);
$.each(objresult, function (key, value) {
if (value.ERR_MSG == "") {
swal({
title: "Add Users",
text: "<p class='lead text-muted'>" + " Selected Record Delete SuccessFully" + " </p>",
type: "success",
showCancelButton: false,
html: true,
confirmButtonClass: 'btn-success',
confirmButtonText: 'OK'
}, function () {
swal.close();
Bindata();
});
}
else {
swal({
title: "Cancelled",
text: "<p class='lead text-muted'>" + "value.ERR_MSG" + " </p>",
type: "error",
showCancelButton: false,
html: true,
confirmButtonClass: 'btn-danger',
confirmButtonText: 'OK'
});
return
}
});
},
complete: function () {
$("#contributionSpinner").hide();
},
error: function (jqXHR, exception) {
$("#contributionSpinner").hide();
swal("User Role", getErrorMessage(jqXHR, exception), "error");
}
});
}
else {
swal({
title: "User Role",
text: "Your deleting record is cancelled",
type: "error",
showCancelButton: false,
html: true,
confirmButtonClass: 'btn-danger',
confirmButtonText: 'OK'
});
}
});
}
function Clear_submit() {
$("#frmAEAddUser").bootstrapValidator("resetForm", true);
$("#frmAEAddUser")[0].reset();
$("#txtAEFirstName").val("");
$("#txtAEPhone").val("");
$("#txtAEPassword").val("");
$("#txtAEUserRole").val("");
$("#btnsaveUser").attr("disabled", false);
}
//--------------------------------------------------END Jquery Code-------------------------------------//
No comments:
Post a Comment