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