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