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);
//}
}
