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