/// <summary>
/// This method is used for setting the Session variable for userId and
/// after that filling the required dropdowns with database values
/// and also check accessing priviledges for particular user
/// and generate the next ID also.
/// and also fatch the vendor information according to select supplier ID in comes from url.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, System.EventArgs e)
{
try
{
uid = (Session["User_Name"].ToString());
}
catch (Exception ex)
{
CreateLogFiles.ErrorLog("Form:Supplier_Update.aspx,Class:PartiesClass.cs,Method:page_load " + ex.Message + " EXCEPTION " + uid);
Response.Redirect("../../Sysitem/ErrorPage.aspx", false);
return;
}
if (!Page.IsPostBack)
{
try
{
#region Check Privileges
int i;
string View_flag = "0", Add_Flag = "0", Edit_Flag = "0", Del_Flag = "0";
string Module = "3";
string SubModule = "12";
string[,] Priv = (string[, ])Session["Privileges"];
for (i = 0; i < Priv.GetLength(0); i++)
{
if (Priv[i, 0] == Module && Priv[i, 1] == SubModule)
{
View_flag = Priv[i, 2];
Add_Flag = Priv[i, 3];
Edit_Flag = Priv[i, 4];
Del_Flag = Priv[i, 5];
break;
}
}
if (View_flag == "0")
{
Response.Redirect("../../Sysitem/AccessDeny.aspx", false);
}
if (Edit_Flag == "0")
{
btnUpdate.Enabled = false;
}
#endregion
getbeat();
// Fills the credit limit combo with the 30 numbers.
for (i = 1; i <= 30; i++)
{
DropCrDay.Items.Add(i.ToString());
}
lblSupplierID.Text = Request.QueryString.Get("ID");
PartiesClass obj = new PartiesClass();
SqlDataReader SqlDtr;
string sql;
#region Fetch Extra Cities from Database and add to the ComboBox
sql = "select distinct Country from Beat_Master";
SqlDtr = obj.GetRecordSet(sql);
while (SqlDtr.Read())
{
DropCountry.Items.Add(SqlDtr.GetValue(0).ToString());
}
SqlDtr.Close();
sql = "select distinct City from Beat_Master";
SqlDtr = obj.GetRecordSet(sql);
while (SqlDtr.Read())
{
DropCity.Items.Add(SqlDtr.GetValue(0).ToString());
}
SqlDtr.Close();
string sql1;
sql1 = "select distinct State from Beat_Master";
SqlDtr = obj.GetRecordSet(sql1);
while (SqlDtr.Read())
{
DropState.Items.Add(SqlDtr.GetValue(0).ToString());
}
SqlDtr.Close();
#endregion
SqlDtr = obj.SupplierList(lblSupplierID.Text.ToString(), "", "");
while (SqlDtr.Read())
{
lblName.Text = SqlDtr.GetValue(1).ToString();
TempVenderName.Text = SqlDtr.GetValue(1).ToString();
DropSuppType.SelectedIndex = DropSuppType.Items.IndexOf(DropSuppType.Items.FindByValue(SqlDtr.GetValue(2).ToString()));
txtAddress.Text = SqlDtr.GetValue(3).ToString();
DropCity.SelectedIndex = DropCity.Items.IndexOf(DropCity.Items.FindByValue(SqlDtr.GetValue(4).ToString()));
DropState.SelectedIndex = DropState.Items.IndexOf(DropState.Items.FindByValue(SqlDtr.GetValue(5).ToString()));
DropCountry.SelectedIndex = DropCountry.Items.IndexOf(DropCountry.Items.FindByValue(SqlDtr.GetValue(6).ToString()));
if (SqlDtr.GetValue(7).ToString().Equals("0"))
{
txtPhoneRes.Text = "";
}
else
{
txtPhoneRes.Text = SqlDtr.GetValue(7).ToString();
}
if (SqlDtr.GetValue(8).ToString().Equals("0"))
{
txtPhoneOff.Text = "";
}
else
{
txtPhoneOff.Text = SqlDtr.GetValue(8).ToString();
}
if (SqlDtr.GetValue(9).ToString().Equals("0"))
{
txtMobile.Text = "";
}
else
{
txtMobile.Text = SqlDtr.GetValue(9).ToString();
}
txtEMail.Text = SqlDtr.GetValue(10).ToString();
txtOpBalance.Text = SqlDtr.GetValue(11).ToString();
DropBal.SelectedIndex = DropBal.Items.IndexOf(DropBal.Items.FindByValue(SqlDtr.GetValue(12).ToString()));
DropCrDay.SelectedIndex = DropCrDay.Items.IndexOf(DropCrDay.Items.FindByValue(SqlDtr.GetValue(13).ToString()));
txtTinNo.Text = SqlDtr.GetValue(14).ToString();
}
SqlDtr.Close();
}
catch (Exception ex)
{
CreateLogFiles.ErrorLog("Form:Supplier_Update.aspx,Class:PartiesClass.cs,Method:page_load EXCEPTION: " + ex.Message + " User_ID: " + uid);
}
}
}
