public IActionResult Index(Scm_Supplier ss) { bool status = false; string R_Status = null; if (ss.Supp_STATUS == true) { R_Status = "Y"; } else { R_Status = "N"; } Scm_Supplier SCM_supp_id = database.SCM_Supplier_id_Generate(); ss.SUPP_id = SCM_supp_id.SUPP_id; database.Insert_SCM_Supplier(ss, R_Status); foreach (var details_record in ss.Scm_Supplier_details) { database.Insert_SCM_Supplier_Details(details_record, ss.SUPP_id); } status = true; return(Json(new { success = status })); }
public IActionResult Index() { Scm_Supplier SCM_supp_id = database.SCM_Supplier_id_Generate(); ViewBag.scm_supp_id = SCM_supp_id; return(View()); }
//Set_Generic End public Scm_Supplier SCM_Supplier_id_Generate() { Scm_Supplier ads = new Scm_Supplier(); SqlConnection con = new SqlConnection(connectString); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select isnull(max(g.SUPP_id),0)+1 SUPP_id from SCM_SUPPLIER g"; cmd.Connection = con; con.Open(); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); ads.SUPP_id = Convert.ToInt16(reader["SUPP_id"]); reader.Close(); return(ads); }
public void Insert_SCM_Supplier(Scm_Supplier ss, string R_Status) { using (SqlConnection conn = new SqlConnection(connectString)) { using (SqlCommand cmd = new SqlCommand("insert into SCM_SUPPLIER values (@SUPP_id,@SUPP_CODE,@SUPPLIER,@Contact_PERSON,@Oth_Contact_PERSON,@SUPP_TYPE,@SUPP_NTN,@SUPP_EMAIL,@SUPP_FAX,@Contact_Office,@MOBILE_no,@Oth_MOBILE_no,@CNIC,@Regions,@COUNTRY,@PROVINCE,@CITY,@Area,@SUPP_ADDRESS,@INVOICE_CURRENCY,@PAY_CURRENCY,@Supp_STATUS)", conn)) { conn.Open(); cmd.Parameters.AddWithValue("@SUPP_id", ss.SUPP_id); cmd.Parameters.AddWithValue("@SUPP_CODE", ss.SUPP_CODE); cmd.Parameters.AddWithValue("@SUPPLIER", ss.SUPPLIER); cmd.Parameters.AddWithValue("@Contact_PERSON", ss.Contact_PERSON); cmd.Parameters.AddWithValue("@Oth_Contact_PERSON", ss.Oth_Contact_PERSON); cmd.Parameters.AddWithValue("@SUPP_TYPE", ss.SUPP_TYPE); cmd.Parameters.AddWithValue("@SUPP_NTN", ss.SUPP_NTN); cmd.Parameters.AddWithValue("@SUPP_EMAIL", ss.SUPP_EMAIL); cmd.Parameters.AddWithValue("@SUPP_FAX", ss.SUPP_FAX); cmd.Parameters.AddWithValue("@Contact_Office", ss.Contact_Office); cmd.Parameters.AddWithValue("@MOBILE_no", ss.MOBILE_no); cmd.Parameters.AddWithValue("@Oth_MOBILE_no", ss.Oth_MOBILE_no); cmd.Parameters.AddWithValue("@CNIC", ss.CNIC); cmd.Parameters.AddWithValue("@Regions", ss.Regions); cmd.Parameters.AddWithValue("@COUNTRY", ss.COUNTRY); cmd.Parameters.AddWithValue("@PROVINCE", ss.PROVINCE); cmd.Parameters.AddWithValue("@CITY", ss.CITY); cmd.Parameters.AddWithValue("@Area", ss.Area); cmd.Parameters.AddWithValue("@SUPP_ADDRESS", ss.SUPP_ADDRESS); cmd.Parameters.AddWithValue("@INVOICE_CURRENCY", ss.INVOICE_CURRENCY); cmd.Parameters.AddWithValue("@PAY_CURRENCY", ss.PAY_CURRENCY); cmd.Parameters.AddWithValue("@Supp_STATUS", R_Status); cmd.ExecuteNonQuery(); } } }
public IActionResult GetData() { Scm_Supplier SCM_supp_id = database.SCM_Supplier_id_Generate(); return(Json(new { success = true, fetchdata = SCM_supp_id.SUPP_id })); }