public static MediclaimApplication GetMediclaimApplicationByID(int mediclaimApplicationID) { DataRow TheMediclaimApplicationRow = MediclaimApplicationDataAccess.GetInstance.GetMediclaimApplicationByID(mediclaimApplicationID); MediclaimApplication TheMediclaimApplication = DataRowToObject(TheMediclaimApplicationRow); return(TheMediclaimApplication); }
public static List <MediclaimApplication> GetMediclaimApplicationsListByApprovalStatus(string approvalStatus, bool allOffices = false) { List <MediclaimApplication> MediclaimApplicationsList = new List <MediclaimApplication>(); DataTable MediclaimApplicationTable = MediclaimApplicationDataAccess.GetInstance.GetMediclaimApplicationsListByApprovalStatus(approvalStatus, allOffices); foreach (DataRow dr in MediclaimApplicationTable.Rows) { MediclaimApplication TheMediclaimApplication = DataRowToObject(dr); MediclaimApplicationsList.Add(TheMediclaimApplication); } return(MediclaimApplicationsList); }
public static List <MediclaimApplication> GetMediclaimApplicationsListByCustomerID(int customerID) { List <MediclaimApplication> MediclaimApplicationsList = new List <MediclaimApplication>(); DataTable MediclaimApplicationTable = MediclaimApplicationDataAccess.GetInstance.GetMediclaimApplicationsListByCustomerID(customerID); foreach (DataRow dr in MediclaimApplicationTable.Rows) { MediclaimApplication TheMediclaimApplication = DataRowToObject(dr); MediclaimApplicationsList.Add(TheMediclaimApplication); } return(MediclaimApplicationsList); }
public static List <MediclaimApplication> GetMediclaimApplicationsList(bool allOffices = false, bool showDeleted = false) { List <MediclaimApplication> MediclaimApplicationsList = new List <MediclaimApplication>(); DataTable MediclaimApplicationTable = MediclaimApplicationDataAccess.GetInstance.GetMediclaimApplicationsList(allOffices, showDeleted); foreach (DataRow dr in MediclaimApplicationTable.Rows) { MediclaimApplication TheMediclaimApplication = DataRowToObject(dr); MediclaimApplicationsList.Add(TheMediclaimApplication); } return(MediclaimApplicationsList); }
public static MediclaimApplication DataRowToObject(DataRow dr) { MediclaimApplication TheMediclaimApplication = new MediclaimApplication(); TheMediclaimApplication.MediclaimApplicationID = int.Parse(dr["MediclaimApplicationID"].ToString()); TheMediclaimApplication.CustomerID = int.Parse(dr["CustomerID"].ToString()); TheMediclaimApplication.CustomerCode = dr["CustomerCode"].ToString(); TheMediclaimApplication.CustomerName = dr["CustomerName"].ToString(); TheMediclaimApplication.MediclaimApplicationNumber = dr["MediclaimApplicationNumber"].ToString(); TheMediclaimApplication.MediclaimApplicationDate = DateTime.Parse(dr["MediclaimApplicationDate"].ToString()).ToString(MicroConstants.DateFormat); TheMediclaimApplication.ReasonForClaim = dr["ReasonForClaim"].ToString(); TheMediclaimApplication.ApprovalStatus = dr["ApprovalStatus"].ToString(); TheMediclaimApplication.OfficeName = dr["OfficeName"].ToString(); TheMediclaimApplication.Remarks = dr["Remarks"].ToString(); return(TheMediclaimApplication); }
public static MediclaimApplication GetApprovalStatuswiseMediclaimApplication(int customerID, bool allOffices = false, bool showDeleted = false) { MediclaimApplication ReturnValue; var ApprovalStatuswiseMediclaimApplication = (from mediclaimApplication in GetMediclaimApplicationsList(allOffices, showDeleted) where mediclaimApplication.CustomerID == customerID select mediclaimApplication).SingleOrDefault(); if (ApprovalStatuswiseMediclaimApplication != null) { ReturnValue = ApprovalStatuswiseMediclaimApplication; } else { ReturnValue = new MediclaimApplication(); } return(ReturnValue); }
public int DeleteMediclaimApplication(MediclaimApplication theMediclaimApplication) { int ReturnValue = 0; using (SqlCommand DeleteCommand = new SqlCommand()) { DeleteCommand.CommandType = CommandType.StoredProcedure; DeleteCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output; DeleteCommand.Parameters.Add(GetParameter("@MediclaimApplicationID", SqlDbType.Int, theMediclaimApplication.MediclaimApplicationID)); DeleteCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID)); DeleteCommand.CommandText = "pCRM_MediclaimApplications_Delete"; ExecuteStoredProcedure(DeleteCommand); ReturnValue = int.Parse(DeleteCommand.Parameters[0].Value.ToString()); return(ReturnValue); } }
public int UpdateMediclaimApplicationApprovalStatus(MediclaimApplication theMediclaimApplication) { int ReturnValue = 0; using (SqlCommand UpdateCommand = new SqlCommand()) { UpdateCommand.CommandType = CommandType.StoredProcedure; UpdateCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output; UpdateCommand.Parameters.Add(GetParameter("@MediclaimApplicationID", SqlDbType.Int, theMediclaimApplication.MediclaimApplicationID)); UpdateCommand.Parameters.Add(GetParameter("@ApprovedByEmployeeID", SqlDbType.Int, theMediclaimApplication.ApprovedByEmployeeID)); UpdateCommand.Parameters.Add(GetParameter("@ApprovalStatus", SqlDbType.VarChar, theMediclaimApplication.ApprovalStatus)); UpdateCommand.Parameters.Add(GetParameter("@Remarks", SqlDbType.VarChar, theMediclaimApplication.Remarks)); UpdateCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID)); UpdateCommand.CommandText = "pCRM_MediclaimApplications_UpdateApprovalStatus"; ExecuteStoredProcedure(UpdateCommand); ReturnValue = int.Parse(UpdateCommand.Parameters[0].Value.ToString()); return(ReturnValue); } }
public int InsertMediclaimApplication(MediclaimApplication theMediclaimApplication) { int ReturnValue = 0; using (SqlCommand InsertCommand = new SqlCommand()) { InsertCommand.CommandType = CommandType.StoredProcedure; InsertCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output; InsertCommand.Parameters.Add(GetParameter("@CustomerID", SqlDbType.Int, theMediclaimApplication.CustomerID)); InsertCommand.Parameters.Add(GetParameter("@MediclaimApplicationDate", SqlDbType.VarChar, theMediclaimApplication.MediclaimApplicationDate)); InsertCommand.Parameters.Add(GetParameter("@ReasonForClaim", SqlDbType.VarChar, theMediclaimApplication.ReasonForClaim)); InsertCommand.Parameters.Add(GetParameter("@Remarks", SqlDbType.VarChar, theMediclaimApplication.Remarks)); InsertCommand.Parameters.Add(GetParameter("@OfficeId", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.OfficeID)); InsertCommand.Parameters.Add(GetParameter("@AddedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID)); InsertCommand.CommandText = "pCRM_MediclaimApplications_Insert"; ExecuteStoredProcedure(InsertCommand); ReturnValue = int.Parse(InsertCommand.Parameters[0].Value.ToString()); return(ReturnValue); } }
public static int DeleteMediclaimApplication(MediclaimApplication theMediclaimApplication) { return(MediclaimApplicationDataAccess.GetInstance.DeleteMediclaimApplication(theMediclaimApplication)); }
public static int UpdateMediclaimApplicationApprovalStatus(MediclaimApplication theMediclaimApplication) { return(MediclaimApplicationDataAccess.GetInstance.UpdateMediclaimApplicationApprovalStatus(theMediclaimApplication)); }
public int DeleteMediclaimApplication(MediclaimApplication theMediclaimApplication) { return(MediclaimApplicationIntegration.DeleteMediclaimApplication(theMediclaimApplication)); }
public int UpdateMediclaimApplicationApprovalStatus(MediclaimApplication theMediclaimApplication) { return(MediclaimApplicationIntegration.UpdateMediclaimApplicationApprovalStatus(theMediclaimApplication)); }
public int UpdateMediclaimApplication(MediclaimApplication theMediclaimApplication) { return(MediclaimApplicationIntegration.UpdateMediclaimApplication(theMediclaimApplication)); }
public int InsertMediclaimApplication(MediclaimApplication theMediclaimApplication) { return(MediclaimApplicationIntegration.InsertMediclaimApplication(theMediclaimApplication)); }