public CommonModal insert(CompanycomplaintModel a)
{
CommonModal e1 = new CommonModal();
SqlConnection conn = new SqlConnection(commonCode.conStr);
conn.Open();
SqlCommand cmd = new SqlCommand("Pro_companycomplaints", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ad_compy_id", SqlDbType.Int).Value = a.ad_compy_id;
cmd.Parameters.Add("@login_id", SqlDbType.Int).Value = a.login_id;
cmd.Parameters.Add("@name_loadgcompt", SqlDbType.NVarChar).Value = a.name_loadgcompt;
cmd.Parameters.Add("@name_compy", SqlDbType.NVarChar).Value = a.name_compy;
cmd.Parameters.Add("@mobileno", SqlDbType.NVarChar).Value = a.mobileno;
cmd.Parameters.Add("@name_defaultcompy", SqlDbType.NVarChar).Value = a.name_defaultcompy;
cmd.Parameters.Add("@appro_compy", SqlDbType.Int).Value = a.appro_compy;
cmd.Parameters.Add("@detail_persncont", SqlDbType.NVarChar).Value = a.detail_persncont;
cmd.Parameters.Add("@amount", SqlDbType.Int).Value = a.amount;
cmd.Parameters.Add("@durat_pend_pay", SqlDbType.NVarChar).Value = a.durat_pend_pay;
cmd.Parameters.Add("@category_id", SqlDbType.Int).Value = a.category_id;
cmd.Parameters.Add("@location", SqlDbType.NVarChar).Value = a.location;
cmd.Parameters.Add("@location_id", SqlDbType.NVarChar).Value = a.location_id;
cmd.Parameters.Add("@image1", SqlDbType.NVarChar).Value = a.image1;
cmd.Parameters.Add("@payment_status", SqlDbType.Int).Value = a.payment_status;
cmd.Parameters.Add("@mode", SqlDbType.NVarChar).Value = a.mode;
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds);
DataTable Dt = ds.Tables[0];
DataTable Dt1 = ds.Tables[1];
conn.Close();
if (Dt.Rows.Count > 0)
{
e1.ResponseStatus = Dt1.Rows[0]["status"].ToString();
e1.ResponseMessage = Dt1.Rows[0]["MSG"].ToString();
e1.data = Dt;
}
else
{
e1.ResponseStatus = "False";
e1.ResponseMessage = "Ad Posting Failed";
}
return(e1);
}
public int delete(CompanycomplaintModel a)
{
try
{
SqlConnection con = new SqlConnection(commonCode.conStr);
con.Open();
SqlCommand cmd = new SqlCommand("Pro_companycomplaints", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ad_compy_id", SqlDbType.Int).Value = a.ad_compy_id;
cmd.Parameters.Add("@mode", SqlDbType.NVarChar).Value = a.mode;
int s = (int)cmd.ExecuteNonQuery();
con.Close();
if (s < 0)
{
s = -1;
}
return(s);
}
catch (Exception ex)
{
return(-1);
}
}
public DataTable get(CompanycomplaintModel a)
{
SqlConnection conn = new SqlConnection(commonCode.conStr);
conn.Open();
SqlCommand cmd = new SqlCommand("Pro_companycomplaints", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@login_id", SqlDbType.Int).Value = a.login_id;
cmd.Parameters.Add("@category_id", SqlDbType.Int).Value = a.category_id;
cmd.Parameters.Add("@lastDate", SqlDbType.DateTime).Value = a.lastDate == Convert.ToDateTime("1/1/0001 12:00:00 AM") ? DateTime.Now : a.lastDate;
cmd.Parameters.Add("@dataCount", SqlDbType.Int).Value = a.dataCount;
cmd.Parameters.Add("@location_id", SqlDbType.NVarChar).Value = a.location_id;
cmd.Parameters.Add("@mode", SqlDbType.NVarChar).Value = a.mode;
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds);
DataTable Dt = ds.Tables[0];
conn.Close();
return(Dt);
}
