public int UpdateStatus(StatusMasterModel objStatusMasterModel) { SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("@StatusName", SqlDbType.VarChar); param[0].Value = objStatusMasterModel.StatusName; param[1] = new SqlParameter("@IsActive", SqlDbType.Int); param[1].Value = objStatusMasterModel.IsActive; param[2] = new SqlParameter("@StatusId", SqlDbType.BigInt); param[2].Value = objStatusMasterModel.StatusId; try { int rowsffected = SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, "UpdateStatus", param); return(rowsffected); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "SBUMasterDAL.cs", "UpdateStatus", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
/// <summary> /// Method is Used to Get statusMaster Details /// </summary> /// <returns></returns> private IEnumerable <StatusMasterModel> GetStatusMasterDetails() { try { StatusMasterModel objStatusMaster = new StatusMasterModel(); objStatusMaster.Company_Code = _objcurrentInfo.GetCompanyCode(); BLMaster objMaster = new BLMaster(); return(objMaster.GetStatusmasterDetails(objStatusMaster)); } catch (Exception ex) { Dictionary <string, string> dicObj = new Dictionary <string, string>(); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicObj); return(null); } }
public int UpdateStatus(StatusMasterModel objStatusMasterModel) { try { return(objStatusMasterDAL.UpdateStatus(objStatusMasterModel)); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "SBUMasterBOL", "UpdateStatus", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
/// <summary> /// Insert and Update for StatusMaster /// </summary> /// <param name="statusName"></param> /// <param name="statusCodeval"></param> /// <param name="status"></param> /// <param name="Mode"></param> /// <returns></returns> public int InsertandUpdateforStatusMaster(string statusName, string statusCodeval, string status, string Mode, string DisplayName) { try { BLMaster Master = new BLMaster(); StatusMasterModel objstatusamasterModel = new StatusMasterModel(); List <StatusMasterModel> lststatusmaster = new List <StatusMasterModel>(); if (Mode.ToUpper() == "I") // Insert Data { objstatusamasterModel.Company_Code = _objcurrentInfo.GetCompanyCode(); objstatusamasterModel.Status_Name = statusName; objstatusamasterModel.Display_Name = DisplayName; objstatusamasterModel.Record_Status = "1"; objstatusamasterModel.Created_By = _objcurrentInfo.GetUserName(); objstatusamasterModel.Created_Date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff"); lststatusmaster.Add(objstatusamasterModel); int result = Master.InsertforStatusMaster(lststatusmaster); return(result); } else { objstatusamasterModel.Company_Code = _objcurrentInfo.GetCompanyCode(); objstatusamasterModel.Status_Code = statusCodeval; objstatusamasterModel.Status_Name = statusName; objstatusamasterModel.Display_Name = DisplayName; objstatusamasterModel.Updated_By = _objcurrentInfo.GetUserName(); objstatusamasterModel.Updated_Date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff"); lststatusmaster.Add(objstatusamasterModel); int result = Master.UpdateforstatusMaster(lststatusmaster); return(result); } } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("Filter:statusName", statusName); dicContext.Add("Filter:statusCodeval", statusCodeval); dicContext.Add("Filter:status", status); dicContext.Add("Filter:Mode", Mode); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return(1); } }
/// <summary> /// To Get the Status , Cycle And User Type Binding Details /// </summary> /// <returns></returns> public JsonResult GetStatusCycleMasterDetails() { try { string companyCode = _objcurrentInfo.GetCompanyCode(); BLUser objBLUser = new BLUser(); BLMaster objBLMaster = new BLMaster(); StatusMasterModel objStatusMasterModel = new StatusMasterModel(); objStatusMasterModel.Company_Code = companyCode; CycleMasterModel objCycleMasterModel = new CycleMasterModel(); objCycleMasterModel.Company_Code = companyCode; objCycleMasterModel.Region_Code = string.Empty; List <MVCModels.HiDoctor_Master.UserTypeModel> lstUserType = objBLUser.GetUserTypes(companyCode); IEnumerable <StatusMasterModel> objStatModel = objBLMaster.GetStatusmasterDetails(objStatusMasterModel); List <StatusMasterModel> lstStatusModel = objStatModel.AsEnumerable().Where(a => a.Record_Status.ToUpper() == "ENABLED").ToList(); IEnumerable <CycleMasterModel> objCycleModel = objBLMaster.GetCycleMasterDetails(objCycleMasterModel); List <CycleMasterModel> lstCycleModel = objCycleModel.AsEnumerable().Where(a => a.Record_Status.ToUpper() == "APPROVED").ToList(); List <JsonResult> lstJSON = new List <JsonResult> { Json(lstUserType, JsonRequestBehavior.AllowGet), Json(lstStatusModel, JsonRequestBehavior.AllowGet), Json(lstCycleModel, JsonRequestBehavior.AllowGet) }; return(Json(lstJSON)); } catch (Exception ex) { Dictionary <string, string> dicObj = new Dictionary <string, string>(); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicObj); return(null); } }
public void DeleteSBU(StatusMasterModel objStatusMasterModel) { //SqlParameter[] param = new SqlParameter[1]; //param[0] = new SqlParameter("@SBUId", SqlDbType.BigInt); //param[0].Value = objStatusMasterModel.StatusId; //try //{ // SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, "DeleteSBUMaster", param); //} //catch (V2Exceptions ex) //{ // throw; //} //catch (System.Exception ex) //{ // FileLog objFileLog = FileLog.GetLogger(); // objFileLog.WriteLine(LogType.Error, ex.Message, "SBUMasterDAL.cs", "DeleteSBU", ex.StackTrace); // throw new V2Exceptions(ex.ToString(),ex); //} }