public List <OrganizationMasterBO> selectOrganisationList() { DataSet objDataSet = null; OrganizationMasterBO objOrganizationMasterBO = null; List <OrganizationMasterBO> objListOrganizationMasterBO = new List <OrganizationMasterBO>(); List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>(); try { objDataSet = objDBAccess.execuitDataSet(ProcselectOrganizationList, ref objProcParameterBOList); if (objDataSet != null && objDataSet.Tables.Count > 0) { for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++) { objOrganizationMasterBO = new OrganizationMasterBO(); objOrganizationMasterBO.OrganisationId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString()); objOrganizationMasterBO.OrganisationName = objDataSet.Tables[0].Rows[i][1].ToString(); objOrganizationMasterBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[0][3].ToString()); objListOrganizationMasterBO.Add(objOrganizationMasterBO); } } } catch (Exception ex) { ExceptionError.Error_Log(ex, "selectOrganisationList"); throw ex; } return(objListOrganizationMasterBO); }
public OrganizationMasterBO EditOrganization(int iOrganisationId) { DataSet objDataSet = null; OrganizationMasterBO objOrganizationMasterBO = null; List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>(); try { ProcParameterBO objDbParameter = new ProcParameterBO(); objDbParameter.Direction = ParameterDirection.Input; objDbParameter.ParameterName = "@iOrganisationId"; objDbParameter.dbType = DbType.Int32; objDbParameter.ParameterValue = iOrganisationId; objProcParameterBOList.Add(objDbParameter); objDataSet = objDBAccess.execuitDataSet(ProcEditOrganization, ref objProcParameterBOList); if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0) { objOrganizationMasterBO = new OrganizationMasterBO(); objOrganizationMasterBO.OrganisationId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString()); objOrganizationMasterBO.OrganisationName = objDataSet.Tables[0].Rows[0][1].ToString(); objOrganizationMasterBO.Details = objDataSet.Tables[0].Rows[0][2].ToString(); objOrganizationMasterBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[0][3].ToString()); } } catch (Exception ex) { ExceptionError.Error_Log(ex, "EditOrganization"); throw ex; } return(objOrganizationMasterBO); }
public ActionResult EditOrganization(int iOrganisationId) { OrganizationMasterBAL objOrganizationMasterBAL = new OrganizationMasterBAL(); OrganizationMasterBO objOrganizationMasterBO = objOrganizationMasterBAL.EditOrganization(iOrganisationId); return(PartialView("AddOrganization", objOrganizationMasterBO)); }
public JsonResult SaveOrganization(OrganizationMasterBO Data) { OrganizationMasterBAL objOrganizationMasterBAL = new OrganizationMasterBAL(); Data.IsActive = true; string strResult = objOrganizationMasterBAL.SaveorUpdateOrganizationMaster(Data, Convert.ToInt32(ViewData["LoginUserId"])); return(Json(strResult, JsonRequestBehavior.AllowGet)); }
// GET: BranchMaster public ActionResult Index() { ViewBag.MainTitle = "OrganizationMaster"; ViewBag.Title = "Security"; ViewBag.Icon = "fa fa-user"; OrganizationMasterBO objOrganizationMasterBO = new OrganizationMasterBO(); return(View(objOrganizationMasterBO)); }
public string SaveorUpdateOrganizationMaster(OrganizationMasterBO objOrganizationMasterBO, int iUserId) { return(objOrganizationMasterDAL.SaveorUpdateOrganizationMaster(objOrganizationMasterBO, iUserId)); }
public string SaveorUpdateOrganizationMaster(OrganizationMasterBO objOrganizationMasterBO, int iUserId) { List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>(); ProcParameterBO objDBparameter = null; string strResult = ""; try { objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iOrganisationId"; objDBparameter.dbType = DbType.Int32; objDBparameter.ParameterValue = objOrganizationMasterBO.OrganisationId; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strOrganisationName"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objOrganizationMasterBO.OrganisationName; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strDetails"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objOrganizationMasterBO.Details; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@bIsActive"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objOrganizationMasterBO.IsActive; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iUserId"; objDBparameter.dbType = DbType.String; 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(ProcsaveOrganizationMaster, 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, "SaveorUpdateOrganizationMaster"); strResult = "FAILED"; throw ex; } return(strResult); }
public ActionResult AddOrganization() { OrganizationMasterBO objOrganizationMasterBO = new OrganizationMasterBO(); return(PartialView("AddOrganization", objOrganizationMasterBO)); }