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