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