private IList <Cust_Addr> FillCustomerAddressModel(DataTable dtCustomerAddress)
{
var customeraddressList = new List <Cust_Addr>();
if (null != dtCustomerAddress && dtCustomerAddress.Rows.Count > 0)
{
foreach (DataRow row in dtCustomerAddress.Rows)
{
var customeraddress = new Cust_Addr();
customeraddress.CustAddrID = Convert.ToInt32(row["CUST_ADDR_ID"]);
customeraddress.CustID = Convert.ToInt32(row["FK_CUST_VEND_ADMIN_ID"]);
customeraddress.ContactAddrID = Convert.ToInt32(row["FK_CONTACT_TYPE_ID"]);
customeraddress.AddressLine1 = Convert.ToString(row["ADDR_LINE1"]);
customeraddress.AddressLine2 = Convert.ToString(row["ADDR_LINE2"]);
customeraddress.City = Convert.ToString(row["CITY"]);
customeraddress.State = Convert.ToString(row["STATE"]);
customeraddress.Country = Convert.ToString(row["COUNTRY"]);
customeraddress.ZIPCode = Convert.ToString(row["ZIP_CODE"]);
customeraddress.ContactStatusCD = Convert.ToString(row["FK_CONTACT_STATUS_CD"]);
customeraddress.ChangedDate = Convert.ToDateTime(row["CREATED_DATE"]);
customeraddress.ChangedByID = Convert.ToInt32(row["CREATED_BY"]);
// customeraddress.AddedDate = Convert.ToDateTime(row["LASTMODIFIED_DATE"]);
// customeraddress.AddByUserID = Convert.ToInt32(row["LASTMODIFIED_BY"]);
customeraddressList.Add(customeraddress);
}
}
return(customeraddressList);
}
public Cust_Addr GetCustomerAddress(Cust_Addr customeraddress)
{
string fetchCustomerAddress = $"SELECT * FROM Mobifix_DB.CUST_ADDRESS WHERE LOWER (CUST_ADDR_ID) = '{customeraddress.CustAddrID.ToString() }'";
var dtResult = MySqlCustomerAddressHelper.ExecuteQuery(fetchCustomerAddress);
var getcustomeraddress = FillCustomerAddressModel(dtResult);
return(getcustomeraddress.FirstOrDefault <Cust_Addr>());
}
public IHttpActionResult DeleteCustomerAddress([FromBody] Cust_Addr customeraddress)
{
var customeraddressRepo = new CustomerAddressRepository();
var result = customeraddressRepo.DeleteCustomerAddress(customeraddress);
if (result <= 0)
{
return(Ok("Error occurred while Deleting the Customer address"));
}
return(Ok("Deleted Customer address"));
}
public IHttpActionResult UpdateCustomerAddressStatus([FromBody] Cust_Addr customeraddress)
{
var custaddressRepo = new CustomerAddressRepository();
var result = custaddressRepo.UpdateCustomerAddressStatus(customeraddress);
if (result <= 0)
{
return(Ok("Error occurred while updating the Customer Address status"));
}
return(Ok("Customer Address Status updated"));
}
public IHttpActionResult GetCustomerAddress([FromBody] Cust_Addr customeraddress)
{
var custaddressRepo = new CustomerAddressRepository();
var getcustomeraddress = custaddressRepo.GetCustomerAddress(customeraddress);
if (getcustomeraddress == null)
{
return(NotFound());
}
return(Ok(getcustomeraddress));
}
public int DeleteCustomerAddress(Cust_Addr customeraddress)
{
string updateCustomerAddressInfo = $"DELETE FROM Mobifix_DB.CUST_ADDRESS WHERE LOWER(CUST_ADDR_ID) = '{customeraddress.CustAddrID.ToString()}' ";
return(MySqlCustomerAddressHelper.ExecuteNonQuery(updateCustomerAddressInfo));
}
public int UpdateCustomerAddressStatus(Cust_Addr customeraddress)
{
string updateCustomerAddressInfo = $"UPDATE Mobifix_DB.CUST_ADDRESS SET ADDR_LINE1 = '{customeraddress.AddressLine1}' WHERE LOWER(CUST_ADDR_ID) = '{customeraddress.CustAddrID.ToString()}' ";
return(MySqlCustomerAddressHelper.ExecuteNonQuery(updateCustomerAddressInfo));
}
