public object doc_files(HttpPostedFile file, string sid)
{
try {
if (file != null && file.ContentLength > 0)
// if (Request.Files.Count > 0)
{
// var sid = Request.Form["sid"];
// var file = Request.Files[0];
string filename = Path.GetFileName(file.FileName);
string fileext = Path.GetExtension(filename);
if (fileext == ".pdf" || fileext == ".docx" || fileext == ".xlsx")
{
string filepath = Path.Combine(Server.MapPath("~/Uploadfile"), filename);
supplieronboard sb = new supplieronboard();
sb.supplier_id = Int32.Parse(sid);
sb.file_name = filename;
sb.file_uploder = filepath;
dblayer.Supp_add_file(sb);
file.SaveAs(filepath);
}
}
}
catch (Exception e) { }
return(new object { });
}
//UPDATE supplier
public int update_rule(supplieronboard rs)
{
int sqlExecutionResult;
SqlCommand cmd = new SqlCommand("sp_rulespplierupdate", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@supplier_id", rs.supplier_id);
cmd.Parameters.AddWithValue("@supplier_name", rs.supplier_name);
cmd.Parameters.AddWithValue("@rules_type", rs.rules_type);
cmd.Parameters.AddWithValue("@rules", rs.rules);
con.Open();
sqlExecutionResult = cmd.ExecuteNonQuery();
con.Close();
return(sqlExecutionResult);
}
//add suppliers file
public int Supp_add_file(supplieronboard sb)
{
int sqlExecutionRes;
SqlCommand cmd = new SqlCommand("sp_supplier_add_file", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@supplier_id", sb.supplier_id);
cmd.Parameters.AddWithValue("@file_name", sb.file_name);
cmd.Parameters.AddWithValue("@file_uploder", sb.file_uploder);
con.Open();
sqlExecutionRes = cmd.ExecuteNonQuery();
con.Close();
return(sqlExecutionRes);
}
public JsonResult updated_rules(supplieronboard rs)
{
string result = string.Empty;
try
{
if (dblayer.update_rule(rs) > 0)
{
result = "Supplier Updated Successfully ";
}
else
{
result = "Failed..!!!";
}
}
catch (Exception e)
{
Console.WriteLine("Exception here" + e);
result = "update failed";
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
//----------add------------
//add supplier_onboard
public JsonResult supplier(supplieronboard sd)
{
string result = string.Empty;
try
{
if (dblayer.suppplier_add(sd) > 0)
{
result = "Data Saved Successfully..!!";
}
else
{
result = "Failed to save data..!!";
}
}
catch (Exception e)
{
Console.WriteLine("Exception here" + e);
result = "Data Saved failed..!!";
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
//add suppliers
public int Supp_add(supplieronboard sb)
{
int sqlExecutionRes;
SqlCommand cmd = new SqlCommand("sp_supplier_add", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@supplier_name", sb.supplier_name);
cmd.Parameters.AddWithValue("@account_number", sb.account_number);
cmd.Parameters.AddWithValue("@email", sb.email);
cmd.Parameters.AddWithValue("@address", sb.address);
cmd.Parameters.AddWithValue("@document_types", sb.document_types);
cmd.Parameters.AddWithValue("@comments", sb.comments);
cmd.Parameters.AddWithValue("@rules_type", sb.rules_type);
cmd.Parameters.AddWithValue("@rules", sb.rules);
cmd.Parameters.AddWithValue("@signature_by", sb.signature_by);
con.Open();
sqlExecutionRes = cmd.ExecuteNonQuery();
con.Close();
return(sqlExecutionRes);
}
public JsonResult Addsupplier(supplieronboard sd)
{
// string result = string.Empty;
int result;
try
{
int idx = dblayer.Supp_add(sd);
result = idx;
/* if (dblayer.Supp_add(sd) > 0)
* result = "Data Saved Successfully..!!";
* else
* result = "Failed to save data..!!"; */
}
catch (Exception e)
{
Console.WriteLine("Exception here" + e);
// result = "Data Saved failed..!!";
result = -1;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
//UPDATE supplier
public int update_supplier(supplieronboard rs)
{
int sqlExecutionResult;
SqlCommand cmd = new SqlCommand("sp_supplierupdate", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@supplier_id", rs.supplier_id);
cmd.Parameters.AddWithValue("@supplier_name", rs.supplier_name);
cmd.Parameters.AddWithValue("@account_number", rs.account_number);
cmd.Parameters.AddWithValue("@email", rs.email);
cmd.Parameters.AddWithValue("@address", rs.address);
cmd.Parameters.AddWithValue("@document_type", rs.document_types);
cmd.Parameters.AddWithValue("@file_uploder", rs.file_uploder);
cmd.Parameters.AddWithValue("@comments", rs.comments);
cmd.Parameters.AddWithValue("@rules_type", rs.rules_type);
cmd.Parameters.AddWithValue("@rules", rs.rules);
cmd.Parameters.AddWithValue("@signature_by", rs.signature_by);
cmd.Parameters.AddWithValue("@date", DateTime.Now);
con.Open();
sqlExecutionResult = cmd.ExecuteNonQuery();
con.Close();
return(sqlExecutionResult);
}
