public ActionResult EditLocationMaster(int A_iLocationId) { LocationMasterBAL objLocationMasterBAL = new LocationMasterBAL(); LocationMasterBO objLocationMasterBO = objLocationMasterBAL.EditLocationMaster(A_iLocationId); return(PartialView("AddLocationMaster", objLocationMasterBO)); }
public List <LocationMasterBO> GetLocationMasterList() { DataSet objDataSet = null; LocationMasterBO objLocationMasterBO = null; List <LocationMasterBO> objLocationMasterBOList = new List <LocationMasterBO>(); List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>(); try { objDataSet = objDBAccess.execuitDataSet(ProcGetLocationMasterListDetails, ref objProcParameterBOList); if (objDataSet != null && objDataSet.Tables.Count > 0) { for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++) { objLocationMasterBO = new LocationMasterBO(); objLocationMasterBO.LocationId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString()); objLocationMasterBO.Location = objDataSet.Tables[0].Rows[i][1].ToString(); objLocationMasterBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[i][2].ToString()); objLocationMasterBOList.Add(objLocationMasterBO); } } } catch (Exception ex) { ExceptionError.Error_Log(ex, "GetLocationMasterList"); throw ex; } return(objLocationMasterBOList); }
public JsonResult SaveorUpdateLocationMaster(LocationMasterBO Data) { LocationMasterBAL objLocationMasterBAL = new LocationMasterBAL(); string strResult = objLocationMasterBAL.SaveorUpdateLocationMaster(Data, Convert.ToInt32(ViewData["LoginUserId"])); return(Json(strResult, JsonRequestBehavior.AllowGet)); }
public LocationMasterBO EditLocationMaster(int iLocationId) { DataSet objDataSet = null; LocationMasterBO objLocationMasterBO = null; List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>(); try { ProcParameterBO objDbParameter = new ProcParameterBO(); objDbParameter.Direction = ParameterDirection.Input; objDbParameter.ParameterName = "@iLocationId"; objDbParameter.dbType = DbType.Int32; objDbParameter.ParameterValue = iLocationId; objProcParameterBOList.Add(objDbParameter); objDataSet = objDBAccess.execuitDataSet(ProcEditLocationMaster, ref objProcParameterBOList); if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0) { objLocationMasterBO = new LocationMasterBO(); objLocationMasterBO.LocationId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString()); objLocationMasterBO.Location = objDataSet.Tables[0].Rows[0][1].ToString(); objLocationMasterBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[0][2].ToString()); } } catch (Exception ex) { ExceptionError.Error_Log(ex, "EditLocationMaster"); throw ex; } return(objLocationMasterBO); }
// GET: LocationMaster public ActionResult Index() { ViewBag.MainTitle = "Security"; ViewBag.Title = "Location Master"; ViewBag.Icon = "fa fa-user"; LocationMasterBO objLocationMasterBO = new LocationMasterBO(); return(View()); }
public ActionResult AddLocationMaster() { LocationMasterBO objLocationMasterBO = new LocationMasterBO(); return(PartialView("AddLocationMaster", objLocationMasterBO)); }
public string SaveorUpdateLocationMaster(LocationMasterBO objLocationMasterBO, int iUserId) { return(objLocationMasterDAL.SaveorUpdateLocationMaster(objLocationMasterBO, iUserId)); }
public string SaveorUpdateLocationMaster(LocationMasterBO objLocationMasterBO, int iUserId) { List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>(); ProcParameterBO objDBparameter = null; string strResult = ""; try { objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iLocationId"; objDBparameter.dbType = DbType.Int32; objDBparameter.ParameterValue = objLocationMasterBO.LocationId; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strLocation"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objLocationMasterBO.Location; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@bIsActive"; objDBparameter.dbType = DbType.Boolean; objDBparameter.ParameterValue = objLocationMasterBO.IsActive; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iUserId"; objDBparameter.dbType = DbType.Int32; objDBparameter.ParameterValue = iUserId; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Output; objDBparameter.ParameterName = "@strResult"; objDBparameter.dbType = DbType.String; objDBparameter.Size = 100; objProcParameterBOList.Add(objDBparameter); objDBAccess.executeNonQuery(ProcSaveorUpdateLocationMaster, ref objProcParameterBOList); for (int i = 0; i < objProcParameterBOList.Count; i++) { if (objProcParameterBOList[i].Direction == ParameterDirection.Output) { strResult = objProcParameterBOList[i].ParameterValue.ToString(); } } } catch (Exception ex) { ExceptionError.Error_Log(ex, "SaveorUpdateLocationMaster"); strResult = "FAILED"; throw ex; } return(strResult); }