public ActionResult SaveUserAuthorization(int index, int UserID, int formid, int parentformid, int branchid, string backdatedvoucher, bool visible, bool edit, bool save, bool delete_id, bool view)
{
UserAuthorizationForms rm = new UserAuthorizationForms();
rm.index = index;
rm.FormID = formid;
rm.UserID = UserID;
rm.ParentID = parentformid;
rm.BranchID = branchid;
rm.BackDatedVoucher = backdatedvoucher;
rm.isVisible = visible;
rm.isDelete = delete_id;
rm.isEdit = edit;
rm.isSave = save;
rm.isView = view;
rm.CreatedBy = Convert.ToInt32(Session["UserLoginId"]);
formid = _userAuthorizationService.InsertUserAuthorization_DetailsUserWise(rm);
var jsonResult = Json(formid, JsonRequestBehavior.AllowGet);
return(jsonResult);
}
public int InsertUserAuthorization_DetailsUserWise(UserAuthorizationForms uaf)
{
return(_userAuthorizationRepository.InsertUserAuthorization_DetailsUserWise(uaf));
}
/// <summary>
///
/// </summary>
/// <param name="InsertUserAuthorization_DetailsUserWise"></param>
/// <returns></returns>
public int InsertUserAuthorization_DetailsUserWise(UserAuthorizationForms city)
{
try
{
if (city.isVisible == false)
{
city.isEdit = false;
city.isSave = false;
city.isDelete = false;
city.isSearch = false;
}
//var state = _context.Database.SqlQuery<UserAuthorizationForms>("T_Update_UserAuthorization_DetailsUserWise @index,@UserID,@ParentID,@FormID,@isVisible,@isEdit,@isView,isSave,@isDelete",
//new SqlParameter("index", city.index),
//new SqlParameter("UserID", city.UserID),
//new SqlParameter("ParentID", city.ParentID),
//new SqlParameter("FormID", city.FormID),
//new SqlParameter("isVisible", city.isVisible),
//new SqlParameter("isEdit", city.isEdit),
//new SqlParameter("isView", city.isView),
//new SqlParameter("isSave", city.isSave),
//new SqlParameter("isDelete", city.isDelete)).FirstOrDefault();
UserAuthorization tblUserAuthorization = new UserAuthorization();
tblUserAuthorization = _context.UserAuthorizations.Where(x => x.UserID == city.UserID && x.FormID == city.FormID && x.BranchId == city.BranchID && x.isActive == "Y").FirstOrDefault();
if (tblUserAuthorization == null)
{
tblUserAuthorization = new UserAuthorization();
tblUserAuthorization.FormID = city.FormID;
tblUserAuthorization.UserID = city.UserID;
tblUserAuthorization.ParentID = city.ParentID;
tblUserAuthorization.BranchId = city.BranchID;
tblUserAuthorization.BackDatedVoucher = Convert.ToInt32(city.BackDatedVoucher);
tblUserAuthorization.isVisible = city.isVisible;
tblUserAuthorization.isEdit = city.isEdit;
tblUserAuthorization.isSave = city.isSave;
tblUserAuthorization.isDelete = city.isDelete;
tblUserAuthorization.isView = city.isView;
tblUserAuthorization.isDefault = false;
tblUserAuthorization.CreatedBy = city.CreatedBy;
tblUserAuthorization.CreatedDate = DateTime.Now;
tblUserAuthorization.isActive = "Y";
_context.UserAuthorizations.Add(tblUserAuthorization);
_context.SaveChanges();
}
else
{
tblUserAuthorization.FormID = city.FormID;
tblUserAuthorization.UserID = city.UserID;
tblUserAuthorization.ParentID = city.ParentID;
tblUserAuthorization.BranchId = city.BranchID;
tblUserAuthorization.BackDatedVoucher = Convert.ToInt32(city.BackDatedVoucher);
tblUserAuthorization.isVisible = city.isVisible;
tblUserAuthorization.isEdit = city.isEdit;
tblUserAuthorization.isSave = city.isSave;
tblUserAuthorization.isDelete = city.isDelete;
tblUserAuthorization.isView = city.isView;
tblUserAuthorization.isDefault = false;
tblUserAuthorization.CreatedBy = city.CreatedBy;
tblUserAuthorization.CreatedDate = DateTime.Now;
tblUserAuthorization.isActive = "Y";
_context.SaveChanges();
}
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
