/// <summary>
/// Put user code to initialize the page here
/// This method is used for setting the Session variable for userId and
/// after that filling the required dropdowns with database values and also fill some
/// additional information and also check accessing priviledges for particular user
/// and generate the next ID also.
/// and also fatch the customer information according to select customer 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:Customer_Update.aspx,Method:on_pageload,Class:PartiesClass.cs " + "EXCEPTION " + ex.Message + " " + uid);
Response.Redirect("../../Sysitem/ErrorPage.aspx", false);
return;
}
if (!Page.IsPostBack)
{
try
{
//*************
SqlCommand cmd;
SqlConnection con;
con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["Servosms"]);
con.Open();
SqlDataReader SqlDtr1;
cmd = new SqlCommand("select * from CustomerType order by CustomerTypeName", con);
SqlDtr1 = cmd.ExecuteReader();
DropCustType.Items.Clear();
DropCustType.Items.Add("SELECT");
if (SqlDtr1.HasRows)
{
while (SqlDtr1.Read())
{
DropCustType.Items.Add(SqlDtr1.GetValue(1).ToString());
}
}
con.Close();
SqlDtr1.Close();
cmd.Dispose();
getbeat();
//********
#region Check Privileges
int i;
string View_flag = "0", Add_Flag = "0", Edit_Flag = "0", Del_Flag = "0";
string Module = "3";
string SubModule = "2";
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
for (i = 1; i <= 30; i++)
{
DropCrDay.Items.Add(i.ToString());
}
LblCustomerID.Text = Request.QueryString.Get("ID");
PartiesClass obj = new PartiesClass();
PartiesClass obj1 = new PartiesClass();
SqlDataReader SqlDtr;
string sql;
#region Fetch Extra Cities from Database and add to the ComboBox
sql = "select City from Beat_Master order by city";
SqlDtr = obj.GetRecordSet(sql);
while (SqlDtr.Read())
{
DropCity.Items.Add(SqlDtr.GetValue(0).ToString());
}
SqlDtr.Close();
sql = "select distinct State from Beat_Master";
SqlDtr = obj.GetRecordSet(sql);
while (SqlDtr.Read())
{
DropState.Items.Add(SqlDtr.GetValue(0).ToString());
}
SqlDtr.Close();
sql = "select distinct Country from Beat_Master";
SqlDtr = obj.GetRecordSet(sql);
while (SqlDtr.Read())
{
DropCountry.Items.Add(SqlDtr.GetValue(0).ToString());
}
SqlDtr.Close();
#endregion
#region Fetch SSR Employee from Employee Table and add to the ComboBox
sql = "select Emp_Name from Employee where Designation='Servo Sales Representative' and status=1 order by Emp_Name";
SqlDtr = obj.GetRecordSet(sql);
DropSSR.Items.Clear();
DropSSR.Items.Add("Select");
while (SqlDtr.Read())
{
DropSSR.Items.Add(SqlDtr.GetValue(0).ToString());
}
SqlDtr.Close();
#endregion
#region Fatch the Customer information according to Customer ID and fill the textboxes and dropdownlist
SqlDtr = obj.CustomerList(LblCustomerID.Text.ToString(), "", "");
while (SqlDtr.Read())
{
lblName.Text = SqlDtr.GetValue(1).ToString();
TempCustName.Text = SqlDtr.GetValue(1).ToString();
DropCustType.SelectedIndex = DropCustType.Items.IndexOf(DropCustType.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();
txtCRLimit.Text = SqlDtr.GetValue(11).ToString();
DropCrDay.SelectedIndex = DropCrDay.Items.IndexOf(DropCrDay.Items.FindByValue(SqlDtr.GetValue(12).ToString()));
if (SqlDtr["SSR"].ToString() != "" && SqlDtr["SSR"].ToString() != null)
{
SqlDtr1 = obj1.GetRecordSet("select Emp_Name from Employee where Emp_ID='" + SqlDtr["SSR"].ToString() + "'");
if (SqlDtr1.Read())
{
DropSSR.SelectedIndex = DropSSR.Items.IndexOf(DropSSR.Items.FindByValue(SqlDtr1["Emp_Name"].ToString()));
}
else
{
DropSSR.SelectedIndex = 0;
}
SqlDtr1.Close();
}
else
{
DropSSR.SelectedIndex = 0;
}
txtOpBalance.Text = SqlDtr.GetValue(13).ToString();
DropBal.SelectedIndex = DropBal.Items.IndexOf(DropBal.Items.FindByValue(SqlDtr.GetValue(14).ToString()));
txtTinNo.Text = SqlDtr.GetValue(15).ToString().Trim();
txtcode.Text = SqlDtr.GetValue(17).ToString().Trim();
txtContactPerson.Text = SqlDtr["ContactPerson"].ToString();
}
SqlDtr.Close();
#endregion
}
catch (Exception ex)
{
CreateLogFiles.ErrorLog("Form:Customer_Update.aspx,Method:on_pageload,Class:PartiesClass.cs " + "EXCEPTION " + ex.Message + " " + uid);
}
}
}
