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