private COLog CreateLOGObject(DataRow dr) { try { COLog log = new COLog(); log.Address = new Address(); log.LogValue = Convert.ToString(dr["LogValue"]); log.Address.Address1 = Convert.ToString(dr["Address1"]); log.Address.Address2 = Convert.ToString(dr["Address2"]); log.Address.Address3 = Convert.ToString(dr["Address3"]); log.Address.Address4 = Convert.ToString(dr["Address4"]); log.Address.CityId = Convert.ToInt32(dr["CityCode"]); log.Address.StateId = Convert.ToInt32(dr["StateCode"]); log.Address.CountryId = Convert.ToInt32(dr["CountryCode"]); log.Address.PhoneNumber1 = Convert.ToString(dr["Phone1"]); log.Address.Mobile1 = Convert.ToString(dr["Mobile1"]); log.Address.PinCode = Convert.ToString(dr["PinCode"]); log.Address.City = Convert.ToString(dr["CityName"]);; log.Address.State = Convert.ToString(dr["StateName"]);; log.Address.Country = Convert.ToString(dr["CountryName"]);; log.CreatedBy = Convert.ToInt32(dr["CreatedBy"]); log.CreatedDate = Convert.ToDateTime(dr["CreatedDate"]).ToString(Common.DTP_DATE_FORMAT); //m_ModifiedDate.ToString(Common.DATE_TIME_FORMAT); dr["CreatedDate"].ToString(Common.DATE_TIME_FORMAT) log.LogType = Convert.ToInt32(dr["LogType"]); log.PCId = Convert.ToInt32(dr["PCId"]); log.BOId = Convert.ToInt32(dr["BOID"]); log.PCName = Convert.ToString(dr["PCName"]); log.DistributorId = Convert.ToInt32(dr["DistributorId"]); log.DistributorName = Convert.ToString(dr["DistributorName"]); log.LogNo = Convert.ToString(dr["LogNo"]); log.ModifiedBy = Convert.ToInt32(dr["ModifiedBy"]); log.ModifiedDate = Convert.ToDateTime(dr["ModifiedDate"]); log.Status = Convert.ToInt32(dr["Status"]); log.LogOrderTotal = Math.Round(Convert.ToDecimal(dr["LogOrderTotal"]), Common.DisplayAmountRounding, MidpointRounding.AwayFromZero); log.LogInvoiceTotal = Math.Round(Convert.ToDecimal(dr["LogInvoiceTotal"]), Common.DisplayAmountRounding, MidpointRounding.AwayFromZero); log.LogCashTotal = Math.Round(Convert.ToDecimal(dr["LogCashTotal"]), Common.DisplayAmountRounding, MidpointRounding.AwayFromZero); log.LogChequeTotal = Math.Round(Convert.ToDecimal(dr["LogChequeTotal"]), Common.DisplayAmountRounding, MidpointRounding.AwayFromZero); log.LogCreditCardTotal = Math.Round(Convert.ToDecimal(dr["LogCreditCardTotal"]), Common.DisplayAmountRounding, MidpointRounding.AwayFromZero); log.LogBonusChequeTotal = Math.Round(Convert.ToDecimal(dr["LogBonusChequeTotal"]), Common.DisplayAmountRounding, MidpointRounding.AwayFromZero); log.LogBankTotal = Math.Round(Convert.ToDecimal(dr["LogBankTotal"]), Common.DisplayAmountRounding, MidpointRounding.AwayFromZero); return(log); } catch (Exception ex) { throw ex; } }
public List <COLog> Search(int Status, int BOID, string LogNo, int LogType, int DistributorID, int PCID) { string errorMessage = string.Empty; List <COLog> LogList = new List <COLog>(); System.Data.DataTable dTable = new DataTable(); DBParameterList dbParam; try { Vinculum.Framework.Data.DataTaskManager dtManager = new DataTaskManager(); // initialize the parameter list object dbParam = new DBParameterList(); dbParam.Add(new DBParameter("@Status", Status, DbType.Int32)); dbParam.Add(new DBParameter("@BOID", BOID, DbType.Int32)); dbParam.Add(new DBParameter("@LogNo", LogNo, DbType.String)); dbParam.Add(new DBParameter("@LogType", LogType, DbType.Int32)); dbParam.Add(new DBParameter("@DistributorID", DistributorID, DbType.Int32)); dbParam.Add(new DBParameter("@PCID", PCID, DbType.Int32)); dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, string.Empty, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); // executing procedure to save the record dTable = dtManager.ExecuteDataTable(SP_LOG_SEARCH, dbParam); // update database message errorMessage = dbParam[Common.PARAM_OUTPUT].Value.ToString(); if (dTable != null && dTable.Rows.Count > 0) { foreach (System.Data.DataRow drow in dTable.Rows) { COLog log = CreateLOGObject(drow); LogList.Add(log); } } return(LogList); } catch (Exception ex) { throw ex; } }