public async Task <SpVendors> UpdateVendors(string Name, int id)
{
// Initialization.
SpVendors vendor = new SpVendors();
try
{
string sqlQuery = $"EXEC Sp_UpdateVendors @Name = \'{Name}\', @Id = {id} ";
var lst = await this.Query <SpVendors>().FromSqlRaw(sqlQuery).ToListAsync();
vendor = lst.FirstOrDefault();
}
catch (Exception ex)
{
throw ex;
}
// Info.
return(vendor);
}
public async Task <SpVendors> AddVendors(string Name)
{
// Initialization.
// List<SpVendors> lst = new List<SpVendors>();
var vendor = new SpVendors();
try
{
string sqlQuery = $"EXEC AddVendors @Name = \'{Name}\' ";
var lst = await this.Query <SpVendors>().FromSqlRaw(sqlQuery).ToListAsync();
//var lst = await this.Query<SpVendors>().FromSqlRaw(sqlQuery).ToListAsync();
vendor = lst.FirstOrDefault();
}
catch (Exception ex)
{
throw ex;
}
// Info.
return(vendor);
}
