public static OneTimeCertificate DataRowToObject(DataRow dr)
{
OneTimeCertificate TheOneTimeCertificate = new OneTimeCertificate();
TheOneTimeCertificate.OneTimeCertificateID = int.Parse(dr["OneTimeCertificateID"].ToString());
TheOneTimeCertificate.OneTimeCertificateCode = dr["OneTimeCertificateCode"].ToString();
TheOneTimeCertificate.CustomerAccountID = int.Parse(dr["CustomerAccountID"].ToString());
if (!string.IsNullOrEmpty(dr["DatePrinted"].ToString()))
{
TheOneTimeCertificate.DatePrinted = DateTime.Parse(dr["DatePrinted"].ToString()).ToString(MicroConstants.DateFormat);
}
TheOneTimeCertificate.ReceivedBy = dr["ReceivedBy"].ToString();
if (!string.IsNullOrEmpty(dr["ReceivedOnDate"].ToString()))
{
TheOneTimeCertificate.ReceivedOnDate = DateTime.Parse(dr["ReceivedOnDate"].ToString()).ToString(MicroConstants.DateFormat);
}
//TheOneTimeCertificate.Remarks = dr["Remarks"].ToString();
TheOneTimeCertificate.OfficeID = int.Parse(dr["OfficeID"].ToString());
TheOneTimeCertificate.OfficeName = dr["OfficeName"].ToString();
TheOneTimeCertificate.OfficeCode = dr["OfficeCode"].ToString();
TheOneTimeCertificate.CustomerAccountCode = dr["CustomerAccountCode"].ToString();
return(TheOneTimeCertificate);
}
public static OneTimeCertificate GetOneTimeCertificatesByOneTimeCertificateID(int OneTimeCertificateID)
{
OneTimeCertificate OneTimeCertificateList = new OneTimeCertificate();
DataRow OneTimeCertificateTableType = OneTimeCertificateDataAccess.GetInstance.GetOneTimeCertificatesByOneTimeCertificateID(OneTimeCertificateID);
OneTimeCertificate TheOneTimeCertificate = DataRowToObject(OneTimeCertificateTableType);
return(TheOneTimeCertificate);
}
public static List <OneTimeCertificate> GetOneTimeCertificateList(bool allOffices = false, bool showDeleted = false)
{
List <OneTimeCertificate> OneTimeCertificateList = new List <OneTimeCertificate>();
DataTable OneTimeCertificateTable = OneTimeCertificateDataAccess.GetInstance.GetOneTimeCertificateList(allOffices, showDeleted);
foreach (DataRow dr in OneTimeCertificateTable.Rows)
{
OneTimeCertificate TheOneTimeCertificate = DataRowToObject(dr);
OneTimeCertificateList.Add(TheOneTimeCertificate);
}
return(OneTimeCertificateList);
}
public static List <OneTimeCertificate> GetOneTimeCertificatesByFieldForceID(int FieldForceID)
{
List <OneTimeCertificate> OneTimeCertificateList = new List <OneTimeCertificate>();
DataTable OneTimeCertificateTableType = OneTimeCertificateDataAccess.GetInstance.GetOneTimeCertificatesByFieldForceID(FieldForceID);
foreach (DataRow dr in OneTimeCertificateTableType.Rows)
{
OneTimeCertificate TheOneTimeCertificate = DataRowToObject(dr);
OneTimeCertificateList.Add(TheOneTimeCertificate);
}
return(OneTimeCertificateList);
}
public static List <OneTimeCertificate> GetOneTimeCertificatesByDate(string FromDate, string ToDate)
{
List <OneTimeCertificate> OneTimeCertificateList = new List <OneTimeCertificate>();
DataTable OneTimeCertificateTableType = OneTimeCertificateDataAccess.GetInstance.GetOneTimeCertificatesByDate(FromDate, ToDate);
foreach (DataRow dr in OneTimeCertificateTableType.Rows)
{
OneTimeCertificate TheOneTimeCertificate = DataRowToObject(dr);
OneTimeCertificateList.Add(TheOneTimeCertificate);
}
return(OneTimeCertificateList);
}
public int PrintDuplicateOneTimeCertificate(OneTimeCertificate theCertificate)
{
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("@OneTimeCertificateID", SqlDbType.Int, theCertificate.OneTimeCertificateID));
InsertCommand.Parameters.Add(GetParameter("@Remarks", SqlDbType.VarChar, theCertificate.Remarks));
InsertCommand.Parameters.Add(GetParameter("@AddedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
InsertCommand.CommandText = "pCRM_OneTimeCertificatesPrintLog_Insert";
ExecuteStoredProcedure(InsertCommand);
ReturnValue = int.Parse(InsertCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
}
public int InsertOneTimeCertificate(OneTimeCertificate theCertificate)
{
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("@CustomerAccountID", SqlDbType.Int, theCertificate.CustomerAccountID));
InsertCommand.Parameters.Add(GetParameter("@DatePrinted", SqlDbType.VarChar, theCertificate.DatePrinted));
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_OneTimeCertificates_Insert";
ExecuteStoredProcedure(InsertCommand);
ReturnValue = int.Parse(InsertCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
}
public int IssueOneTimeCertificate(OneTimeCertificate theCertificate, string OneTimeCertificateIDs)
{
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("@OneTimeCertificateIDs", SqlDbType.VarChar, OneTimeCertificateIDs));
InsertCommand.Parameters.Add(GetParameter("@ReceivedBy", SqlDbType.VarChar, theCertificate.ReceivedBy));
InsertCommand.Parameters.Add(GetParameter("@ReceivedOnDate", SqlDbType.VarChar, theCertificate.ReceivedOnDate));
InsertCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
InsertCommand.CommandText = "pCRM_OneTimeCertificates_Issue";
ExecuteStoredProcedure(InsertCommand);
ReturnValue = int.Parse(InsertCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
}
public static int PrintDuplicateOneTimeCertificate(OneTimeCertificate theCertificate)
{
return(OneTimeCertificateDataAccess.GetInstance.PrintDuplicateOneTimeCertificate(theCertificate));
}
public static int IssueOneTimeCertificate(OneTimeCertificate theCertificate, string OneTimeCertificateIDs)
{
return(OneTimeCertificateDataAccess.GetInstance.IssueOneTimeCertificate(theCertificate, OneTimeCertificateIDs));
}
public static int InsertOneTimeCertificate(OneTimeCertificate theCertificate)
{
return(OneTimeCertificateDataAccess.GetInstance.InsertOneTimeCertificate(theCertificate));
}
public int PrintDuplicateOneTimeCertificate(OneTimeCertificate theCertificate)
{
return(OneTimeCertificateIntegration.PrintDuplicateOneTimeCertificate(theCertificate));
}
public int IssueOneTimeCertificate(OneTimeCertificate theCertificate, string OneTimeCertificateIDs)
{
return(OneTimeCertificateIntegration.IssueOneTimeCertificate(theCertificate, OneTimeCertificateIDs));
}
public int InsertOneTimeCertificate(OneTimeCertificate theCertificate)
{
return(OneTimeCertificateIntegration.InsertOneTimeCertificate(theCertificate));
}
