private IList <Cust_Info> FillCustomerInfoModel(DataTable dtCustomerInfo)
{
var customerinfoList = new List <Cust_Info>();
if (null != dtCustomerInfo && dtCustomerInfo.Rows.Count > 0)
{
foreach (DataRow row in dtCustomerInfo.Rows)
{
var customerinfo = new Cust_Info();
customerinfo.CustInfoID = Convert.ToInt32(row["CUST_INFO_ID"]);
customerinfo.CustVendorAdminID = Convert.ToInt32(row["FK_CUST_VEND_ADMIN_ID"]);
customerinfo.FirstName = Convert.ToString(row["FIRST_NAME"]);
customerinfo.LastName = Convert.ToString(row["LAST_NAME"]);
customerinfo.FullName = Convert.ToString(row["FULL_NAME"]);
customerinfo.NamePrefix = Convert.ToString(row["NAMEPREFIX"]);
customerinfo.Gender = Convert.ToString(row["GENDER"]);
//customerinfo.DateOfBirth=Convert
customerinfo.CreatedDate = Convert.ToDateTime(row["CREATED_DATE"]);
customerinfo.CreatedBy = Convert.ToInt32(row["CREATED_BY"]);
customerinfo.LastModifiedDate = Convert.ToDateTime(row["LASTMODIFIED_DATE"]);
customerinfo.LastModifiedBy = Convert.ToInt32(row["LASTMODIFIED_BY"]);
customerinfoList.Add(customerinfo);
}
}
return(customerinfoList);
}
public Cust_Info GetCustomerInfo(Cust_Info customerInfo)
{
string fetchCustomerInfo = $"SELECT * FROM Mobifix_DB.CUST_INFO WHERE LOWER (CUST_INFO_ID) = '{customerInfo.CustInfoID.ToString() }'";
var dtResult = MySqlCustomerInfoHelper.ExecuteQuery(fetchCustomerInfo);
var getcustomerinfo = FillCustomerInfoModel(dtResult);
return(getcustomerinfo.FirstOrDefault <Cust_Info>());
}
public IHttpActionResult DeleteCustomerInfo([FromBody] Cust_Info customerinfo)
{
var customerinfoRepo = new CustomerInfoRepository();
var result = customerinfoRepo.DeleteCustomerInfo(customerinfo);
if (result <= 0)
{
return(Ok("Error occurred while Deleting the customer info"));
}
return(Ok("Deleted Customer info"));
}
public IHttpActionResult UpdateCustomerInfoStatus([FromBody] Cust_Info customerinfo)
{
var custinfoRepo = new CustomerInfoRepository();
var result = custinfoRepo.UpdateCustomerInfoStatus(customerinfo);
if (result <= 0)
{
return(Ok("Error occurred while updating the Customer Info status"));
}
return(Ok("Customer Info Status updated"));
}
public IHttpActionResult GetCustomerInfo([FromBody] Cust_Info customerinfo)
{
var custinfoRepo = new CustomerInfoRepository();
var getcustomerinfo = custinfoRepo.GetCustomerInfo(customerinfo);
if (getcustomerinfo == null)
{
return(NotFound());
}
return(Ok(getcustomerinfo));
}
public int DeleteCustomerInfo(Cust_Info customerinfo)
{
string updateCustomerInfo = $"DELETE FROM Mobifix_DB.CUST_INFO WHERE LOWER(CUST_INFO_ID) = '{customerinfo.CustInfoID.ToString()}' ";
return(MySqlCustomerInfoHelper.ExecuteNonQuery(updateCustomerInfo));
}
public int UpdateCustomerInfoStatus(Cust_Info customerinfo)
{
string updateCustomerInfo = $"UPDATE Mobifix_DB.CUST_INFO SET LAST_NAME = '{customerinfo.LastName}' WHERE LOWER(CUST_INFO_ID) = '{customerinfo.CustInfoID.ToString()}' ";
return(MySqlCustomerInfoHelper.ExecuteNonQuery(updateCustomerInfo));
}
