public ActionResult DeleteProcessByUser(string ID, ProcessByUser_Model objModel, int page = 1, int pageSize = 10)
{
ProcessByUserManager context = new ProcessByUserManager(new DataContext());
if (!string.IsNullOrEmpty(ID))
{
int uId = Convert.ToInt32(ID);
List <ProcessByUser> lst = context.GetAll(c => c.UserID == uId).ToList();
context.DeleteProcessByUser(lst);
VW_ProcessByUserManager context2 = new VW_ProcessByUserManager(new DataContext());
int UserID = Convert.ToInt32(Session["UserID"]);
VW_ProcessByUser objVW_ProcessByUser = context2.GetProcessByUserById(UserID);
if (objVW_ProcessByUser != null)
{
Session["UserProcess"] = objVW_ProcessByUser.ProcessName != null ? objVW_ProcessByUser.ProcessName : "";
}
}
if (objModel.StaticPageSize != 0)
{
pageSize = objModel.StaticPageSize;
}
objModel.StaticPageSize = pageSize;
BindProcessByUserGrid(objModel, page, pageSize);
return(PartialView("ProcessByUserList", objModel));
}
public ActionResult ProcessByUserGrid()
{
ProcessByUser_Model objModel = new ProcessByUser_Model();
objModel.page = 1;
objModel.StaticPageSize = 10;
BindProcessByUserGrid(objModel, Convert.ToInt32(objModel.page), objModel.StaticPageSize);
return(View(objModel));
}
public void BindProcessByUserGrid(ProcessByUser_Model objModel, int page, int pageSize)
{
StringBuilder query = new StringBuilder();
var colName = common.GetColumns(CommonFunction.module.ProcessByUser.ToString());
query = common.GetSqlTableQuery(CommonFunction.module.ProcessByUser.ToString());
if (objModel != null)
{
objModel.StaticPageSize = pageSize;
}
VW_ProcessByUserManager context = new VW_ProcessByUserManager(new DataContext());
context.setModel(query, objModel, colName, "UserID", page, pageSize);
}
public ActionResult SaveProcessByUser(ProcessByUser_Model objModel, int page = 1, int pageSize = 10)
{
if (!ModelState.IsValid)
{
var message = string.Join("|", ModelState.Values.SelectMany(e => e.Errors).Select(em => em.ErrorMessage));
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, message));
}
//Save
ProcessByUserManager context = new ProcessByUserManager(new DataContext());
VW_ProcessByUserManager context2 = new VW_ProcessByUserManager(new DataContext());
List <ProcessByUser> lst = context.GetAll(c => c.UserID == objModel.UserId).ToList();
context.DeleteProcessByUser(lst);
foreach (string pId in objModel.ProcessId)
{
ProcessByUserManager context1 = new ProcessByUserManager(new DataContext());
ProcessByUser obj = new ProcessByUser();
obj.ProcessID = Convert.ToInt32(pId);
obj.UserID = objModel.UserId;
var msg = context1.SaveProcessByUser(obj);
}
int UserID = Convert.ToInt32(Session["UserID"]);
VW_ProcessByUser objVW_ProcessByUser = context2.GetProcessByUserById(UserID);
if (objVW_ProcessByUser != null)
{
Session["UserProcess"] = objVW_ProcessByUser.ProcessName != null ? objVW_ProcessByUser.ProcessName : "";
}
if (objModel.StaticPageSize != 0)
{
pageSize = objModel.StaticPageSize;
}
objModel.StaticPageSize = pageSize;
BindProcessByUserGrid(objModel, page, pageSize);
return(PartialView("ProcessByUserList", objModel));
}
public ActionResult AddEditProcessByUser(int ID = 0)
{
ProcessListManager objProcessListManager = new ProcessListManager(new DataContext());
UserMasterListManager objUserMasterListManager = new UserMasterListManager(new DataContext());
//ProcessByUserManager context = new ProcessByUserManager(new DataContext());
VW_ProcessByUserManager context = new VW_ProcessByUserManager(new DataContext());
ProcessByUser_Model objModel = new ProcessByUser_Model();
if (ID != 0)
{
objModel.Table = context.GetProcessByUserById(ID);
objModel.UserId = objModel.Table.UserID;
objModel.ProcessId = !string.IsNullOrEmpty(objModel.Table.ProcessID)? objModel.Table.ProcessID.Split(',') : null;
objModel.UserList = Extens.ToSelectList(objUserMasterListManager.GetDtUserListForProcess(objModel.Table.UserID), "UserID", "UserName");
}
else
{
objModel.Table = new VW_ProcessByUser();
objModel.UserList = Extens.ToSelectList(objUserMasterListManager.GetDtUserListForProcess(), "UserID", "UserName");
}
objModel.ProcessList = Extens.ToSelectList(objProcessListManager.GetDtProcess(), "ProcID", "Processname");
return(PartialView("ProcessByUserCRUD", objModel));
}
public ActionResult ProcessByUserFilterSearch(ProcessByUser_Model objModel, int page = 1, int pageSize = 10)
{
BindProcessByUserGrid(objModel, page, pageSize);
return(PartialView("ProcessByUserList", objModel));
}
