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