protected void lstSupplier_SelectedIndexChanged(object sender, EventArgs e)
{
List <ATTInvSupplier> supplier = (List <ATTInvSupplier>)Session["supplier_list"];
ATTInvSupplier obj = supplier[this.lstSupplier.SelectedIndex].CreateDeepCopy();
Session["Supplier"] = obj;
this.txtSupplierName_Rqd.Text = obj.SupplierName;
this.txtSupplierAddress.Text = obj.SupplierAddress;
this.txtPanNo.Text = obj.PanNo;
string chk = obj.Active;
if (chk == "Y")
{
this.chkSActive.Checked = true;
}
else
{
this.chkSActive.Checked = false;
}
this.grdSupplierContact.DataSource = obj.LstSupplierContact;
grdSupplierContact.DataBind();
}
protected void grdSupplierContact_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int i = e.RowIndex;
ATTInvSupplier supplier = (ATTInvSupplier)Session["Supplier"];
List <ATTInvSupplierContact> suppContact = supplier.LstSupplierContact;
if ((suppContact[i].Action == null) || (suppContact[i].Action == "E"))
{
suppContact[i].Action = "D";
}
else if (suppContact[i].Action == "D")
{
suppContact[i].Action = "E";
}
else if (suppContact[i].Action == "A")
{
suppContact.RemoveAt(i);
}
this.grdSupplierContact.DataSource = suppContact;
this.grdSupplierContact.DataBind();
this.grdSupplierContact.SelectedIndex = -1;
SetGridColor(5, 7, this.grdSupplierContact);
}
public static List <ATTInvSupplier> GetSupplierList(int?supplierID)
{
List <ATTInvSupplier> lstsupplierList = new List <ATTInvSupplier>();
try
{
foreach (DataRow row in DLLInvSupplier.GetSupplierTable(supplierID).Rows)
{
ATTInvSupplier supplier = new ATTInvSupplier();
supplier.SupplierID = int.Parse(row["SUPPLIERS_ID"].ToString());
supplier.SupplierName = row["SUPPLIERS_NAME"].ToString();
supplier.SupplierAddress = row["SUPPLIERS_ADDRESS"].ToString();
supplier.PanNo = row["pan_no"].ToString();
supplier.Active = row["ACTIVE"].ToString();
//supplier.EntryBy= row["ENTRY_BY"].ToString();
supplier.Action = "";
supplier.LstSupplierContact = BLLInvSupplierContact.GetSupplierContactList(supplier.SupplierID);
lstsupplierList.Add(supplier);
}
return(lstsupplierList);
}
catch (Exception ex)
{
throw ex;
}
}
protected void grdSupplierContact_SelectedIndexChanged(object sender, EventArgs e)
{
ATTInvSupplier obj = (ATTInvSupplier)Session["Supplier"];
List <ATTInvSupplierContact> suppContact = obj.LstSupplierContact;
this.txtContactPerson_Rqd.Text = suppContact[this.grdSupplierContact.SelectedIndex].ContactPerson; // supplierContact.ContactPerson;
this.txtContactPhone.Text = suppContact[this.grdSupplierContact.SelectedIndex].ContactPhone; //supplierContact.ContactPhone;
this.txtEmail.Text = suppContact[this.grdSupplierContact.SelectedIndex].ContactEmail; //supplierContact.ContactEmail;
suppContact[grdSupplierContact.SelectedIndex].Action = (suppContact[grdSupplierContact.SelectedIndex].Action == "A" ? "A" : "E");
}
public static bool AddSupplier(ATTInvSupplier supplier)
{
try
{
return(DLLInvSupplier.AddSupplier(supplier));
}
catch (Exception ex)
{
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Login_User_Detail"] == null)
{
Response.Redirect("~/MODULES/Login.aspx", true);
}
ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]);
if (!Page.IsPostBack)
{
LoadSupplierList(); // load list data of Supplier
Session["Supplier"] = new ATTInvSupplier();
}
}
void ClearSupplier()
{
this.lstSupplier.SelectedIndex = -1;
this.txtSupplierName_Rqd.Text = "";
this.txtSupplierAddress.Text = "";
this.txtPanNo.Text = "";
this.chkSActive.Checked = true;
this.grdSupplierContact.SelectedIndex = -1;
this.grdSupplierContact.DataSource = "";
grdSupplierContact.DataBind();
this.txtContactPerson_Rqd.Text = "";
this.txtContactPhone.Text = "";
this.txtEmail.Text = "";
this.lblStatus.Text = "";
LoadSupplierList();
Session["Supplier"] = new ATTInvSupplier();
}
public static bool AddSupplier(ATTInvSupplier supplier)
{
string InsertSP = "";
if (supplier.Action == "A")
{
InsertSP = "SP_INV_ADD_SUPPLIERS";
}
else if (supplier.Action == "E")
{
InsertSP = "SP_INV_EDIT_SUPPLIERS";
}
List <OracleParameter> paramArray = new List <OracleParameter>();
paramArray.Add(Utilities.GetOraParam(":P_SUPPLIERS_ID", supplier.SupplierID, OracleDbType.Int64, System.Data.ParameterDirection.InputOutput));
paramArray.Add(Utilities.GetOraParam(":P_SUPPLIERS_NAME", supplier.SupplierName, OracleDbType.Varchar2, System.Data.ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_SUPPLIERS_ADDRESS", supplier.SupplierAddress, OracleDbType.Varchar2, System.Data.ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":p_pan_no", supplier.PanNo, OracleDbType.Varchar2, System.Data.ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_ACTIVE", supplier.Active, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_ENTRY_BY", supplier.EntryBy, OracleDbType.Varchar2, System.Data.ParameterDirection.Input));
GetConnection GetConn = new GetConnection();
OracleTransaction Tran = GetConn.GetDbConn(Module.OAS).BeginTransaction();
try
{
SqlHelper.ExecuteNonQuery(Tran, System.Data.CommandType.StoredProcedure, InsertSP, paramArray.ToArray());
supplier.SupplierID = int.Parse(paramArray[0].Value.ToString());
DLLInvSupplierContact.AddSupplierContact(supplier.LstSupplierContact, supplier.SupplierID, Tran);
Tran.Commit();
return(true);
}
catch (Exception ex)
{
Tran.Rollback();
throw ex;
}
finally
{
GetConn.CloseDbConn();
}
}
protected void btnAddSupplierContact_Click(object sender, EventArgs e)
{
if (this.txtContactPerson_Rqd.Text == "")
{
return;
}
ATTInvSupplier obj = (ATTInvSupplier)Session["Supplier"];
if (this.grdSupplierContact.SelectedIndex > -1)
{
obj.LstSupplierContact[grdSupplierContact.SelectedIndex].ContactPerson = txtContactPerson_Rqd.Text;
obj.LstSupplierContact[grdSupplierContact.SelectedIndex].ContactPhone = txtContactPhone.Text;
obj.LstSupplierContact[grdSupplierContact.SelectedIndex].ContactEmail = txtEmail.Text;
obj.LstSupplierContact[grdSupplierContact.SelectedIndex].Action = (obj.LstSupplierContact[grdSupplierContact.SelectedIndex].Action == "A" ? "A" : "E");
obj.LstSupplierContact[grdSupplierContact.SelectedIndex].EntryBy = ((ATTUserLogin)Session["Login_User_Detail"]).UserName;
}
else
{
ATTInvSupplierContact ob = new ATTInvSupplierContact();
ob.ContactPerson = txtContactPerson_Rqd.Text;
ob.ContactPhone = txtContactPhone.Text;
ob.ContactEmail = txtEmail.Text;
ob.EntryBy = ((ATTUserLogin)Session["Login_User_Detail"]).UserName;
ob.Action = "A";
obj.LstSupplierContact.Add(ob);
this.grdSupplierContact.SelectedIndex = -1;
this.txtContactPerson_Rqd.Text = "";
this.txtContactPhone.Text = "";
this.txtEmail.Text = "";
}
this.grdSupplierContact.DataSource = obj.LstSupplierContact;
this.grdSupplierContact.DataBind();
this.grdSupplierContact.SelectedIndex = -1;
this.txtContactPerson_Rqd.Text = "";
this.txtContactPhone.Text = "";
this.txtEmail.Text = "";
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (this.txtSupplierName_Rqd.Text == "")
{
this.lblStatusMessage.Text = "Please enter supplier name.";
this.programmaticModalPopup.Show();
this.lblStatus.Focus();
return;
}
ATTInvSupplier supplier = (ATTInvSupplier)Session["Supplier"];
supplier.SupplierName = txtSupplierName_Rqd.Text;
supplier.PanNo = txtPanNo.Text;
supplier.SupplierAddress = txtSupplierAddress.Text;
supplier.Active = (chkSActive.Checked ? "Y" : "N");
supplier.EntryBy = ((ATTUserLogin)Session["Login_User_Detail"]).UserName;
if (lstSupplier.SelectedIndex >= 0)
{
supplier.Action = "E";
}
else
{
supplier.Action = "A";
}
if (BLLInvSupplier.AddSupplier(supplier))
{
this.lblStatusMessage.Text = "Information Saved";
this.programmaticModalPopup.Show();
}
else
{
this.lblStatusMessage.Text = "Information could not be Saved";
this.programmaticModalPopup.Show();
}
ClearSupplier();
}
