public List<Customer> GetCustomerDetailByCustID(ref Customer objCust) { List<Customer> lstobjCustomer = new List<Customer>(); try { object[] mParams = { new SqlParameter("@CustomerID", SqlDbType.Int), }; mParams[0] = objCust.CustomerID; using (IDataReader reader = dBase.ExecuteReader("sprocCS_GetCustomerDetailByCustID", mParams)) { while (reader.Read()) { lstobjCustomer.Add(PopulateCustomer(reader)); } } } catch (Exception ex) { Common.LogError("CSWeb > Error > " + (new StackTrace()).GetFrame(0).GetMethod().Name, ex.ToString()); } return lstobjCustomer; }
private Customer PopulateCustomer(IDataReader drData) { Customer objCustomer = new Customer(); try { if (FieldExists(drData, "CustomerID") && drData["CustomerID"] != DBNull.Value) { objCustomer.CustomerID = Convert.ToInt32(drData["CustomerID"]); } if (FieldExists(drData, "FirstName") && drData["FirstName"] != DBNull.Value) { objCustomer.FirstName = Convert.ToString(drData["FirstName"]); } if (FieldExists(drData, "LastName") && drData["LastName"] != DBNull.Value) { objCustomer.LastName = Convert.ToString(drData["LastName"]); } if (FieldExists(drData, "Address") && drData["Address"] != DBNull.Value) { objCustomer.Address = Convert.ToString(drData["Address"]); } if (FieldExists(drData, "City") && drData["City"] != DBNull.Value) { objCustomer.City = Convert.ToString(drData["City"]); } if (FieldExists(drData, "ZIP") && drData["ZIP"] != DBNull.Value) { objCustomer.ZIP = Convert.ToString(drData["ZIP"]); } if (FieldExists(drData, "Country") && drData["Country"] != DBNull.Value) { objCustomer.Country = Convert.ToString(drData["Country"]); } if (FieldExists(drData, "TeleNumber") && drData["TeleNumber"] != DBNull.Value) { objCustomer.TeleNumber = Convert.ToString(drData["TeleNumber"]); } if (FieldExists(drData, "Email") && drData["Email"] != DBNull.Value) { objCustomer.Email = Convert.ToString(drData["Email"]); } if (FieldExists(drData, "Notes") && drData["Notes"] != DBNull.Value) { objCustomer.Notes = Convert.ToString(drData["Notes"]); } if (FieldExists(drData, "CreatedOn") && drData["CreatedOn"] != DBNull.Value) { objCustomer.CreatedOn = Convert.ToDateTime(drData["CreatedOn"]); } if (FieldExists(drData, "UpdatedOn") && drData["UpdatedOn"] != DBNull.Value) { objCustomer.UpdatedOn = Convert.ToDateTime(drData["UpdatedOn"]); } } catch (Exception ex) { Common.LogError("CSWeb > Error > " + (new StackTrace()).GetFrame(0).GetMethod().Name, ex.ToString()); } return objCustomer; }
public Message InsertUpdatePlatformCustomer(Customer objCustomer) { Message objMessage = new Message(); try { DbCommand objCmd = dBase.GetStoredProcCommand("sprocCS_InsertUpdatePlatformCustomer"); dBase.AddInParameter(objCmd, "@CustomerID", DbType.Int32, objCustomer.CustomerID); dBase.AddInParameter(objCmd, "@FirstName", DbType.String, objCustomer.FirstName); dBase.AddInParameter(objCmd, "@LastName", DbType.String, objCustomer.LastName); dBase.AddInParameter(objCmd, "@Address", DbType.String, objCustomer.Address); dBase.AddInParameter(objCmd, "@ZIP", DbType.String, objCustomer.ZIP); dBase.AddInParameter(objCmd, "@City", DbType.String, objCustomer.City); dBase.AddInParameter(objCmd, "@Country", DbType.String, objCustomer.Country); dBase.AddInParameter(objCmd, "@TeleNumber", DbType.String, objCustomer.TeleNumber); dBase.AddInParameter(objCmd, "@Email", DbType.String, objCustomer.Email); dBase.AddInParameter(objCmd, "@Notes", DbType.String, objCustomer.Notes); dBase.AddInParameter(objCmd, "@CreatedBy", DbType.String, objCustomer.CreatedBy); dBase.AddOutParameter(objCmd, "@ReturnValue", DbType.Int32, 4); dBase.AddOutParameter(objCmd, "@ReturnMessage", DbType.String, 255); dBase.ExecuteNonQuery(objCmd); objMessage.ReturnValue = (int)dBase.GetParameterValue(objCmd, "@ReturnValue"); objMessage.ReturnMessage = (string)dBase.GetParameterValue(objCmd, "@ReturnMessage"); } catch (Exception ex) { Common.LogError("CSWeb > Error > " + (new StackTrace()).GetFrame(0).GetMethod().Name, ex.ToString()); } return objMessage; }
public Message DeletePlatformCustomer(Customer objCustomer) { Message objMessage = new Message(); try { DbCommand objCmd = dBase.GetStoredProcCommand("sprocCS_DeletePlatformCustomer"); dBase.AddInParameter(objCmd, "@CustomerID", DbType.Int32, objCustomer.CustomerID); dBase.AddOutParameter(objCmd, "@ReturnValue", DbType.Int32, 4); dBase.AddOutParameter(objCmd, "@ReturnMessage", DbType.String, 255); dBase.ExecuteNonQuery(objCmd); objMessage.ReturnValue = (int)dBase.GetParameterValue(objCmd, "@ReturnValue"); objMessage.ReturnMessage = (string)dBase.GetParameterValue(objCmd, "@ReturnMessage"); } catch (Exception ex) { Common.LogError("CSWeb > Error > " + (new StackTrace()).GetFrame(0).GetMethod().Name, ex.ToString()); } return objMessage; }
public Message InsertUpdatePlatformCustomer(Customer objCustomer) { return objDB.InsertUpdatePlatformCustomer(objCustomer); }
public Message DeletePlatformCustomer(Customer objData) { return objDB.DeletePlatformCustomer(objData); }
public List<Customer> GetCustomerDetailByCustID(ref Customer objData) { return objDB.GetCustomerDetailByCustID(ref objData); }