private IList <GetVendor> FillGetVendorModel(DataTable dtUsers)
{
var userList = new List <GetVendor>();
if (null != dtUsers && dtUsers.Rows.Count > 0)
{
foreach (DataRow row in dtUsers.Rows)
{
var user = new GetVendor();
user.FirstName = Convert.ToString(row["FIRST_NAME"]);
user.LastName = Convert.ToString(row["LAST_NAME"]);
user.ContactNumber = Convert.ToString(row["CONTACT_NUMBER"]);
user.LoginId = Convert.ToString(row["LOGIN_ID"]);
user.Password = Convert.ToString(row["LOGIN_PWD"]);
user.AddressLine1 = Convert.ToString(row["ADDR_LINE1"]);
user.AddressLine2 = Convert.ToString(row["ADDR_LINE2"]);
user.City = Convert.ToString(row["CITY"]);
user.State = Convert.ToString(row["STATE"]);
user.Country = Convert.ToString(row["COUNTRY"]);
user.ZIPCode = Convert.ToString(row["ZIP_CODE"]);
userList.Add(user);
}
}
return(userList);
}
public IList <GetVendor> VendorNameStatus(GetVendor getvendor)
{
string VendorNameStatusInfo = $"SELECT CUST_VEND_ADMIN_ID, FIRST_NAME, LAST_NAME, CONTACT_NUMBER, LOGIN_ID, LOGIN_PWD, ADDR_LINE1, ADDR_LINE2, CITY, STATE, COUNTRY, ZIP_CODE from USER_TBL U LEFT JOIN CUST_INFO ci ON ci.FK_CUST_VEND_ADMIN_ID = U.CUST_VEND_ADMIN_ID LEFT JOIN CUST_ADDRESS ca ON ca.FK_CUST_INFO_ID = ci.CUST_INFO_ID LEFT JOIN CUST_PHONE cp ON cp.FK_CUST_ADDRESS_ID = ca.CUST_ADDR_ID WHERE LOWER(LOGIN_ID) = '{getvendor.LoginId.ToLowerInvariant()}' and LOWER(LOGIN_PWD) ='{getvendor.Password}' and FK_USER_TYPE_ID=2";
var dtResult = mySqlHelper.ExecuteQuery(VendorNameStatusInfo);
var result = FillGetVendorModel(dtResult);
return(result);
}
public IHttpActionResult VendorNameStatus([FromBody] GetVendor getvendor)
{
var vendorRepo = new VendorRepository();
var result = vendorRepo.VendorNameStatus(getvendor);
if (result == null || result.Count == 0)
{
return(NotFound());
}
return(Ok(result));
}
public static async Task <Either <Error, Instrument> > FromId(NonEmptyGuid id, GetVendor getVendor)
{
var vendor = await getVendor(id);
return(vendor.MapRight(v => new Instrument(id)
{
Vendor = v
}));
}
