public int Delete(SubcontractorsServicesInputModel data)
{
using (SqlConnection conn = new SqlConnection("Server=192.168.25.111;Database=CRM; User ID=ma;password=123"))
{
try
{
var dbParams = new DynamicParameters();
conn.Open();
dbParams.Add("@servicesId", Newtonsoft.Json.JsonConvert.SerializeObject(data.ServicesId));
dbParams.Add("@subcontractorsId", Newtonsoft.Json.JsonConvert.SerializeObject(data.SubcontractorsId));
var reader = conn.ExecuteReader(
sql: "[CRM].[CRM_SP_PARTNERS_SERVICES_DELETE]",
param: dbParams,
commandType: CommandType.StoredProcedure);
return(1);
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
}
public int Insert(SubcontractorsServicesInputModel data)
{
using (SqlConnection conn = new SqlConnection(_configuration.Get("ConnectionString:SQLConnection")))
{
try
{
var dbParams = new DynamicParameters();
conn.Open();
dbParams.Add("@servicesId", Newtonsoft.Json.JsonConvert.SerializeObject(data.ServicesId));
dbParams.Add("@subcontractorsId", Newtonsoft.Json.JsonConvert.SerializeObject(data.SubcontractorsId));
var reader = conn.ExecuteReader(
sql: "[CRM].[CRM_SP_PARTNERS_SERVICES_INSERT]",
param: dbParams,
commandType: CommandType.StoredProcedure);
return(1);
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
}
