//generet invoice no automatic public void GetNextInvoiceNo() { InventoryClass obj = new InventoryClass(); SqlDataReader SqlDtr; string sql; #region Fetch the Next Invoice Number sql = "select max(Invoice_No)+1 from Sales_Master"; SqlDtr = obj.GetRecordSet(sql); while (SqlDtr.Read()) { lblInvoiceNo.Text = SqlDtr.GetValue(0).ToString(); if (lblInvoiceNo.Text == "") { lblInvoiceNo.Text = "1001"; } } SqlDtr.Close(); #endregion }
public IHttpActionResult FetchData() { SqlDataReader SqlDtr; string sql, str = ""; sql = "select city,state,country from beat_master"; SqlDtr = obj.GetRecordSet(sql); while (SqlDtr.Read()) { str = str + SqlDtr.GetValue(0).ToString() + ":"; str = str + SqlDtr.GetValue(1).ToString() + ":"; str = str + SqlDtr.GetValue(2).ToString() + "#"; } SqlDtr.Close(); if (str == "" || str == null) { return(Content(HttpStatusCode.NotFound, "Data Not Found")); } return(Ok(str)); }
/// <summary> /// This method is used to fatch the all customer from customer table and fill the list. /// </summary> public void FillList() { try { InventoryClass obj = new InventoryClass(); SqlDataReader SqlDtr; string sql = "select Cust_Name from customer order by cust_name"; SqlDtr = obj.GetRecordSet(sql); ListCustomer.Items.Clear(); while (SqlDtr.Read()) { ListCustomer.Items.Add(SqlDtr.GetValue(0).ToString()); } SqlDtr.Close(); } catch (Exception ex) { CreateLogFiles.ErrorLog("Form:CustomerMapping.aspx,Method:FillList" + ex.Message + " EXCEPTION " + uid); } }
public IHttpActionResult LedgerName_SelectedIndexChanged(string VoucherId) { SqlDataReader SqlDtr, SqlDtr1; SqlCommand SqlCmd; string sql, sql2; using (SqlCon = new SqlConnection()) { SqlCon = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ServoSMS"]); SqlCon.Open(); sql = "Select * from payment_transaction where voucher_Id ='" + VoucherId + "' "; SqlDtr = obj.GetRecordSet(sql); while (SqlDtr.Read()) { payment.tempPaymentID = SqlDtr.GetValue(0).ToString(); payment.txtBankname = SqlDtr["Bank_Name"].ToString().Trim(); payment.txtCheque = SqlDtr["Cheque_No"].ToString().Trim(); payment.txtchkDate = obj.checkDate(GenUtil.str2DDMMYYYY(obj.trimDate(SqlDtr["cheque_date"].ToString().Trim()))); payment.txtAmount = SqlDtr["Amount1"].ToString().Trim(); payment.txtNarrartion = SqlDtr["Narration"].ToString().Trim(); payment.txtDate = GenUtil.str2DDMMYYYY(GenUtil.trimDate(SqlDtr["Entry_Date"].ToString())); payment.Invoice_Date = SqlDtr["Entry_Date"].ToString(); payment.LedgerID = SqlDtr["Ledger_ID_Dr"].ToString(); payment.LedgerID1 = SqlDtr["Ledger_ID_Cr"].ToString(); sql2 = "Select Ledger_Name from Ledger_Master where Ledger_ID = " + SqlDtr["Ledger_ID_Cr"].ToString().Trim(); SqlCmd = new SqlCommand(sql2, SqlCon); SqlDtr1 = SqlCmd.ExecuteReader(); if (SqlDtr1.Read()) { payment.CheckCashMode = SqlDtr1["Ledger_Name"].ToString(); } SqlDtr1.Close(); } SqlDtr.Close(); } if (payment.Equals(0) || payment == null) { return(Content(HttpStatusCode.NotFound, "Ledger Name Not Found")); } return(Ok(payment)); }
public IHttpActionResult SavePayment(PaymentModels payment) { SqlDataReader SqlDtr; string Vouch_ID; string By_ID = ""; string sql = "Select Ledger_ID from Ledger_Master where Ledger_Name ='" + payment.By_Name + "'"; SqlDtr = obj.GetRecordSet(sql); if (SqlDtr.Read()) { By_ID = SqlDtr.GetValue(0).ToString(); } SqlDtr.Close(); sql = "Select top 1(voucher_ID + 1) from Payment_Transaction order by voucher_ID desc"; SqlDtr = obj.GetRecordSet(sql); if (SqlDtr.Read()) { Vouch_ID = SqlDtr.GetValue(0).ToString(); } else { Vouch_ID = "50001"; } SqlDtr.Close(); payment.c = 0; sql = "insert into payment_transaction values(" + Vouch_ID + ",'Payment'," + payment.Ledger_ID + "," + payment.Amount + "," + By_ID + "," + payment.Amount + ",'" + payment.Bank_name + "','" + payment.Cheque_No + "',CONVERT(datetime,'" + payment.dtDate + "', 103),'" + payment.narration + "','" + payment.uid + "', CONVERT(datetime,'" + payment.Entry_Date + "', 103))"; SqlDtr = obj.GetRecordSet(sql); payment.c = 1; object obj1 = null; dbobj.ExecProc(DbOperations_LATEST.OprType.Insert, "ProInsertAccountsLedger", ref obj1, "@Ledger_ID", payment.Ledger_ID, "@Particulars", "Payment (" + Vouch_ID + ")", "@Debit_Amount", payment.Amount, "@Credit_Amount", "0.0", "@type", "Dr", "@Invoice_Date", System.Convert.ToDateTime(payment.Entry_Date)); dbobj.ExecProc(DbOperations_LATEST.OprType.Insert, "ProInsertAccountsLedger", ref obj1, "@Ledger_ID", By_ID, "@Particulars", "Payment (" + Vouch_ID + ")", "@Debit_Amount", "0.0", "@Credit_Amount", payment.Amount, "@type", "Cr", "@Invoice_Date", System.Convert.ToDateTime(payment.Entry_Date)); dbobj.ExecProc(DbOperations_LATEST.OprType.Insert, "ProCustomerLedgerEntry", ref obj1, "@Voucher_ID", Vouch_ID, "@Ledger_ID", payment.Ledger_ID, "@Amount", payment.Amount, "@Type", "Dr.", "@Invoice_Date", System.Convert.ToDateTime(payment.Entry_Date)); dbobj.ExecProc(DbOperations_LATEST.OprType.Insert, "ProCustomerLedgerEntry", ref obj1, "@Voucher_ID", Vouch_ID, "@Ledger_ID", By_ID, "@Amount", payment.Amount, "@Type", "Cr.", "@Invoice_Date", System.Convert.ToDateTime(payment.Entry_Date)); if (payment.Equals(0) || payment == null) { return(Content(HttpStatusCode.NotFound, "Payment Not Saved")); } return(Ok(payment)); }
public IHttpActionResult BindTheData(string str1, string str2) { try { SqlDataReader SqlDtr; string sql, str3 = ""; sql = "select sum(cast(status as integer)) Total_Present from attandance_register where cast(floor(cast(cast(att_date as datetime) as float)) as datetime) >= '" + str1 + "' and cast(floor(cast(cast(att_date as datetime) as float)) as datetime) <= '" + str2 + "' "; SqlDtr = obj.GetRecordSet(sql); while (SqlDtr.Read()) { str3 = SqlDtr.GetValue(0).ToString(); } SqlDtr.Close(); return(Ok(str3)); } catch (Exception) { return(Content(HttpStatusCode.NotFound, "Data Not Found")); } }
public IHttpActionResult GetLeaveRegister(string str1, string str2, string str3) { try { SqlDataReader SqlDtr; string sql; int count = 0; sql = "select * from Leave_Register where Emp_ID='" + str1 + "' and cast(floor(cast(cast(date_from as datetime) as float)) as datetime) <='" + str2 + "' and cast(floor(cast(cast(date_to as datetime) as float)) as datetime)>='" + str3 + "' and isSanction=0"; SqlDtr = obj.GetRecordSet(sql); while (SqlDtr.Read()) { count = int.Parse(SqlDtr.GetValue(0).ToString()); } SqlDtr.Close(); return(Ok(count)); } catch (Exception) { return(Content(HttpStatusCode.NotFound, "OT Register Not Found")); } }
// Method to fetch the next Bill no from print_credit_bill table. public void GetNextBillNo() { InventoryClass obj = new InventoryClass(); SqlDataReader SqlDtr; string sql; #region Fetch the Next Bill No sql = "select Max(Bill_No)+1 from Print_Credit_Bill"; SqlDtr = obj.GetRecordSet(sql); while (SqlDtr.Read()) { lblBillNo.Text = SqlDtr.GetValue(0).ToString(); if (lblBillNo.Text == "") { lblBillNo.Text = "1001"; } } SqlDtr.Close(); #endregion }
/// <summary> /// Method Fetch the next beat ID from Beat_Master table. /// </summary> public void FillID() { try { PartiesClass obj = new PartiesClass(); SqlDataReader SqlDtr; SqlDtr = obj.GetRecordSet("select max(Beat_No)+1 from Beat_Master"); while (SqlDtr.Read()) { lblBeatNo.Text = SqlDtr.GetValue(0).ToString(); if (lblBeatNo.Text == "") { lblBeatNo.Text = "1001"; } } } catch (Exception ex) { CreateLogFiles.ErrorLog("Form:BeatMasterEntery.aspx,Method:FillID(). EXCEPTION " + ex.Message + " " + uid); } }
/// <summary> /// This method is used to fatch the Employee name whose designation have Servo Sales Representative /// and fill the dropdownlist when page is loaded. /// </summary> public void FillCustomer() { try { InventoryClass obj = new InventoryClass(); SqlDataReader SqlDtr; string sql = "select emp_name from employee where Designation='Servo Sales Representative' order by emp_name"; SqlDtr = obj.GetRecordSet(sql); DropSSRName.Items.Clear(); DropSSRName.Items.Add("Select");; while (SqlDtr.Read()) { DropSSRName.Items.Add(SqlDtr.GetValue(0).ToString()); } SqlDtr.Close(); } catch (Exception ex) { CreateLogFiles.ErrorLog("Form:CustomerMapping.aspx,Method:FillCustomer" + ex.Message + " EXCEPTION " + uid); } }
/// <summary> /// This method is used to fatch the city from Beat Master table and fill the information /// in the dropdownlist. /// </summary> public void fillbeat() { try { InventoryClass obj = new InventoryClass(); SqlDataReader SqlDtr; string sql = "select city from beat_master order by city"; SqlDtr = obj.GetRecordSet(sql); Listbeat.Items.Clear(); while (SqlDtr.Read()) { Listbeat.Items.Add(SqlDtr.GetValue(0).ToString()); } SqlDtr.Close(); } catch (Exception ex) { CreateLogFiles.ErrorLog("Form : SelesPersionAssignment.aspx,Method : FillBeat()" + ex.Message + " EXCEPTION " + uid); } }
public void GetCustomerInfo() { try { InventoryClass obj = new InventoryClass(); SqlDataReader SqlDtr, SqlDtr1; sql = "select c.City,CR_Days,Curr_Credit,Cust_ID,Cust_Name,Emp_Name from Customer c,Employee e, customertype ct where e.Emp_ID = c.SSR and Cust_Name = '" + Cust_name + "' and c.cust_type = ct.customertypename order by Cust_Name"; SqlDtr = obj.GetRecordSet(sql); while (SqlDtr.Read()) { Place = SqlDtr.GetValue(0).ToString(); CrDays = SqlDtr.GetValue(1).ToString(); duedate = DateTime.Now.AddDays(System.Convert.ToDouble(SqlDtr["CR_Days"])); CrLimit = SqlDtr.GetValue(2).ToString(); CustID = SqlDtr.GetValue(3).ToString(); UnderSalesMan = SqlDtr.GetValue(5).ToString(); SqlDtr.Close(); sql1 = "select top 1 Balance,BalanceType from customerledgertable where CustID='" + CustID + "' order by EntryDate Desc"; SqlDtr1 = obj.GetRecordSet(sql1); while (SqlDtr1.Read()) { CurrBal = SqlDtr1.GetValue(0).ToString() + " " + SqlDtr1.GetValue(1).ToString(); } SqlDtr1.Close(); break; } } catch (Exception ex) { throw; } }
public IHttpActionResult PrintSelectSumAndTime(string str2, string str3, string Emp_id) { try { SalaryStatementModel salary = new SalaryStatementModel(); SqlDataReader SqlDtr; string sql; sql = "select sum(datepart(hour,Ot_To)-datepart(hour,Ot_From)) OT_Hour,sum(datepart(minute,Ot_To)-datepart(minute,Ot_From)) OT_Minute from OverTime_Register where cast(floor(cast(OT_Date as float)) as datetime) >= '" + str2 + "' and cast(floor(cast(OT_Date as float)) as datetime) <= '" + str3 + "' and emp_id='" + Emp_id + "'"; SqlDtr = obj.GetRecordSet(sql); while (SqlDtr.Read()) { salary.hour = SqlDtr.GetValue(0).ToString(); salary.min = SqlDtr.GetValue(1).ToString(); } SqlDtr.Close(); return(Ok(salary)); } catch (Exception) { return(Content(HttpStatusCode.NotFound, "Data Not Found")); } }
public OrganizationModels GetSelectedOrganization(string OrgID) { InventoryClass obj = new InventoryClass(); SqlDataReader SqlDtr; string sql; OrganizationModels organization = new OrganizationModels(); sql = "select * from Organisation where CompanyID='" + OrgID + "'"; SqlDtr = obj.GetRecordSet(sql); while (SqlDtr.Read()) { organization.DealerName = SqlDtr.GetValue(1).ToString(); organization.DealerShip = SqlDtr.GetValue(2).ToString(); organization.Address = SqlDtr.GetValue(3).ToString(); organization.City = SqlDtr.GetValue(4).ToString(); organization.State = SqlDtr.GetValue(5).ToString(); organization.Country = SqlDtr.GetValue(6).ToString(); organization.PhoneOff = SqlDtr.GetValue(7).ToString(); organization.FaxNo = SqlDtr.GetValue(8).ToString(); organization.EMail = SqlDtr.GetValue(9).ToString(); organization.Website = SqlDtr.GetValue(10).ToString(); organization.Tinno = SqlDtr.GetValue(11).ToString(); organization.Entrytax = SqlDtr.GetValue(12).ToString(); organization.FoodLicNO = SqlDtr.GetValue(13).ToString(); organization.WMlic = SqlDtr.GetValue(14).ToString(); organization.StateOffice = SqlDtr.GetValue(16).ToString(); organization.Logo = SqlDtr.GetValue(15).ToString(); organization.Message = SqlDtr.GetValue(17).ToString(); organization.VATRate = SqlDtr.GetValue(18).ToString().Trim(); organization.DateFrom = SqlDtr.GetValue(19).ToString().Trim(); organization.DateTo = SqlDtr.GetValue(20).ToString().Trim(); organization.InvoiceNo = SqlDtr.GetValue(21).ToString(); } SqlDtr.Close(); return(organization); }
public IHttpActionResult FetchDiscount() { InventoryClass obj = new InventoryClass(); SqlDataReader SqlDtr; string sql; List <string> discount = new List <string>(); sql = "select Ledger_Name from ledger_master lm,ledger_master_sub_grp lms where lms.sub_grp_id=lm.sub_grp_id and lms.sub_grp_name='Discount'"; SqlDtr = obj.GetRecordSet(sql); while (SqlDtr.Read()) { if (!SqlDtr.GetValue(0).ToString().Equals("")) { discount.Add(SqlDtr.GetValue(0).ToString()); } } SqlDtr.Close(); if (discount == null || discount.Count == 0) { return(Content(HttpStatusCode.NotFound, "Discount Not Found")); } return(Ok(discount)); }
/// <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. /// </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_Entry.aspx,Class:PartiesClass.cs ,Method:onpageload" + ex.Message + " EXCEPTION " + uid); Response.Redirect("../../Sysitem/ErrorPage.aspx", false); return; } //txtbeatname.Visible=false; if (!IsPostBack) { try { # region Fill dropType PartiesClass obj = new PartiesClass(); SqlDataReader SqlDtr; string sql; SqlDtr = obj.GetRecordSet("select * from CustomerType order by CustomerTypeName"); DropType.Items.Clear(); DropType.Items.Add("Select"); while (SqlDtr.Read()) { DropType.Items.Add(SqlDtr.GetValue(1).ToString()); } SqlDtr.Close(); #endregion #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 (Add_Flag == "0") { btnUpdate.Enabled = false; } #endregion for (i = 1; i <= 30; i++) { DropCrDay.Items.Add(i.ToString()); } GetNextCustomerID(); getbeat(); #region Fetch Extra Cities from Database and add to the ComboBox sql = "select distinct City from Beat_Master order by City asc"; SqlDtr = obj.GetRecordSet(sql); while (SqlDtr.Read()) { DropCity.Items.Add(SqlDtr.GetValue(0).ToString()); } SqlDtr.Close(); #endregion #region Fetch Extra Cities from Database and add to the ComboBox sql = "select distinct state from Beat_Master order by state asc"; SqlDtr = obj.GetRecordSet(sql); while (SqlDtr.Read()) { DropState.Items.Add(SqlDtr.GetValue(0).ToString()); } SqlDtr.Close(); #endregion #region Fetch Extra Cities from Database and add to the ComboBox sql = "select distinct country from Beat_Master order by country asc"; 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' 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 }
/// <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 /// </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:Leave_Register.aspx,Method:pageload" + "EXCEPTION " + ex.Message + uid); Response.Redirect("../../Sysitem/ErrorPage.aspx", false); return; } if (!Page.IsPostBack) { #region Check Privileges int i; string View_flag = "0", Add_Flag = "0", Edit_Flag = "0", Del_Flag = "0"; string Module = "2"; string SubModule = "3"; 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); return; } //*********** if (Add_Flag == "0") { btnApply.Enabled = false; } //*********** #endregion try { // Sets todays date in from and to date text boxes. txtDateFrom.Text = DateTime.Today.Day.ToString() + "/" + DateTime.Today.Month.ToString() + "/" + DateTime.Today.Year.ToString(); txtDateTO.Text = DateTime.Today.Day.ToString() + "/" + DateTime.Today.Month.ToString() + "/" + DateTime.Today.Year.ToString(); #region Fetch Employee ID and Name of All Employee EmployeeClass obj = new EmployeeClass(); SqlDataReader SqlDtr; string sql; //coment by vikas 17.11.2012 sql="select Emp_ID,Emp_Name from Employee order by Emp_Name"; sql = "select Emp_ID,Emp_Name from Employee where status='1' order by Emp_Name"; SqlDtr = obj.GetRecordSet(sql); while (SqlDtr.Read()) { DropEmpName.Items.Add(SqlDtr.GetValue(0).ToString() + ":" + SqlDtr.GetValue(1).ToString()); } SqlDtr.Close(); #endregion } catch (Exception ex) { CreateLogFiles.ErrorLog("Form:Leave_Register.aspx,Method:pageload" + "EXCEPTION " + ex.Message + uid); } } txtDateFrom.Text = Request.Form["txtDateFrom"] == null?GenUtil.str2DDMMYYYY(System.DateTime.Now.ToShortDateString()) : Request.Form["txtDateFrom"].ToString().Trim(); txtDateTO.Text = Request.Form["txtDateTO"] == null?GenUtil.str2DDMMYYYY(System.DateTime.Now.ToShortDateString()) : Request.Form["txtDateTO"].ToString().Trim(); }
protected string Multiply1(string inv_no) { PetrolPumpClass obj = new PetrolPumpClass(); SqlDataReader SqlDtr; string sql; in_amt = 0; if (Flag == 0) { Cache["Invoice_No"] = inv_no; Flag = 1; } else if (Flag == 3) { Cache["Invoice_No"] = inv_no; } if (status == 0) { sql = "select count(*) from vw_SaleBook where Invoice_No=" + Cache["Invoice_No"].ToString() + ""; SqlDtr = obj.GetRecordSet(sql); while (SqlDtr.Read()) { count += int.Parse(SqlDtr.GetValue(0).ToString()); } SqlDtr.Close(); status = 1; } if (i < count) { Flag = 2; i++; } if (i == count) { //amt1=amt; sql = "select Net_amount from sales_master where Invoice_No=" + Cache["Invoice_No"].ToString() + ""; SqlDtr = obj.GetRecordSet(sql); while (SqlDtr.Read()) { amt1 = double.Parse(SqlDtr.GetValue(0).ToString()); } SqlDtr.Close(); //amt=0; status = 0; i = 0; Flag = 3; count = 0; } else { amt1 = 0; Flag = 4; } if (Flag == 4) { return(" --- "); } else if (Flag == 3) { am += amt1; Cache["am"] = am; return(GenUtil.strNumericFormat(amt1.ToString())); } return(""); }
public PaymentReceiptModel GetSelectedReceipt(string ReceiptNo) { PaymentReceiptModel receipt = new PaymentReceiptModel(); InventoryClass obj = new InventoryClass(); InventoryClass obj1 = new InventoryClass(); SqlDataReader SqlDtr; string sql; sql = "select * from payment_receipt where Receipt_No=" + ReceiptNo; SqlDtr = obj.GetRecordSet(sql); SqlDataReader rdr = null; double totdisc = 0; //bool Flag=true; //*****while(SqlDtr.Read()) if (SqlDtr.Read()) { receipt.SubReceiptNo = SqlDtr["SubReceiptNo"].ToString(); receipt.InvoiceNo = SqlDtr.GetValue(3).ToString(); receipt.Mode = SqlDtr.GetValue(8).ToString(); if (SqlDtr.GetValue(5).ToString() != "") { dbobj.SelectQuery("select Ledger_Name,Ledger_ID from Ledger_Master where Ledger_ID='" + SqlDtr.GetValue(5).ToString() + "'", ref rdr); if (rdr.Read()) { receipt.BankName = rdr["Ledger_Name"].ToString(); receipt.LedgerID = rdr["Ledger_ID"].ToString(); } rdr.Close(); } else { receipt.BankName = "0"; receipt.LedgerID = "0"; } //txtBankName.Text=SqlDtr.GetValue(5).ToString(); receipt.ChequeNumber = SqlDtr.GetValue(6).ToString(); receipt.ChequeDate = SqlDtr.GetValue(7).ToString(); receipt.RecDate = SqlDtr["Receipt_Date"].ToString(); //Invoice_Date=txtReceivedDate.Text.ToString(); receipt.Invoice_Date = SqlDtr["Receipt_Date"].ToString(); //******** receipt.ReceivedAmount = SqlDtr["Received_Amount"].ToString(); if (SqlDtr["Discount1"].ToString() != "") { receipt.Discount1 = SqlDtr["Discount1"].ToString(); } if (SqlDtr["Discount2"].ToString() != "") { receipt.Discount2 = SqlDtr["Discount2"].ToString(); } //******** //str = SqlDtr.GetValue(4).ToString(); //str=System.Convert.ToString(double.Parse(SqlDtr.GetValue(4).ToString())-totdisc); //Cache["RecAmt"] = SqlDtr.GetValue(4).ToString(); //Cache["RecAmt"]=System.Convert.ToString(double.Parse(SqlDtr.GetValue(4).ToString())-totdisc); receipt.Cust_ID = SqlDtr["Cust_ID"].ToString(); receipt.CustomerID = SqlDtr["Cust_ID"].ToString(); receipt.Narration = SqlDtr["Narration"].ToString(); receipt.ReceivedAmount = SqlDtr["Received_Amount"].ToString(); receipt.CustBankName = SqlDtr["CustBankName"].ToString(); //Textbox1.Text = totdisc.ToString(); //Tot_Rec = Convert.ToDouble(totdisc.ToString()); //Add by vikas 12.09.09 dbobj.SelectQuery("select Ledger_Name from Ledger_Master where Ledger_ID='" + SqlDtr["DiscLedgerID1"].ToString() + "'", ref rdr); if (rdr.Read()) { receipt.DiscLedgerID1 = rdr["Ledger_Name"].ToString(); //DiscLedgerName1 = rdr["Ledger_Name"].ToString(); } else { receipt.DiscLedgerID1 = "0"; //DiscLedgerName1 = ""; } rdr.Close(); dbobj.SelectQuery("select Ledger_Name from Ledger_Master where Ledger_ID='" + SqlDtr["DiscLedgerID2"].ToString() + "'", ref rdr); if (rdr.Read()) { receipt.DiscLedgerID2 = rdr["Ledger_Name"].ToString(); //DiscLedgerName2 = rdr["Ledger_Name"].ToString(); } else { receipt.DiscLedgerID2 = "0"; //DiscLedgerName2 = ""; } rdr.Close(); //if (DropDiscount1.SelectedIndex == 0) // txtDisc1.Enabled = false; //else // txtDisc1.Enabled = true; //if (DropDiscount2.SelectedIndex == 0) // txtDisc2.Enabled = false; //else // txtDisc2.Enabled = true; //if (double.Parse(SqlDtr["Discount1"].ToString()) > 0) // TempDiscAmt1 = double.Parse(SqlDtr["Discount1"].ToString()); //else // TempDiscAmt1 = 0; //if (double.Parse(SqlDtr["Discount2"].ToString()) > 0) // TempDiscAmt2 = double.Parse(SqlDtr["Discount2"].ToString()); //else // TempDiscAmt2 = 0; //txtDisc1.Text = SqlDtr["Discount1"].ToString(); //txtDisc2.Text = SqlDtr["Discount2"].ToString(); //DropCustName.Disabled = false; } SqlDtr.Close(); return(receipt); }
/// <summary> /// this is used to fill all the data on the behalf of selected Id in the dropdown. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void dropschid_SelectedIndexChanged(object sender, System.EventArgs e) { SqlConnection con; SqlCommand cmd; InventoryClass obj = new InventoryClass(); SqlDataReader rdr1 = null; try { if (dropschid.SelectedIndex != 0) { con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["Servosms"]); con.Open(); SqlDataReader SqlDtr; string scheme = dropschid.SelectedItem.Text.Trim().ToString(); string[] schid = scheme.Split(new char[] { ':' }, scheme.Length); cmd = new SqlCommand("select * from StktSchDiscount WHERE sch_id='" + schid[0] + "'", con); SqlDtr = cmd.ExecuteReader(); ListEmpAssigned.Items.Clear(); if (SqlDtr.HasRows) { while (SqlDtr.Read()) { //02.06.09 DropSchType.SelectedIndex=(DropSchType.Items.IndexOf((DropSchType.Items.FindByValue(SqlDtr.GetValue(1).ToString())))); /*********Coment By Vikas 1.1.2013****************************/ if (!SqlDtr.GetValue(1).Equals("") || !SqlDtr.GetValue(1).Equals("NULL")) { DropType.SelectedIndex = DropType.Items.IndexOf(DropType.Items.FindByValue(SqlDtr.GetValue(1).ToString())); } /*************************************/ if (SqlDtr.GetValue(3).Equals("") || SqlDtr.GetValue(1).Equals("NULL")) { txtschname.Text = ""; } else { txtschname.Text = SqlDtr.GetValue(3).ToString(); } txtSchDiscount.Text = SqlDtr.GetValue(4).ToString(); DropSchDiscount.SelectedIndex = (DropSchDiscount.Items.IndexOf((DropSchDiscount.Items.FindByValue(SqlDtr.GetValue(5).ToString())))); txtDateFrom.Text = GenUtil.str2DDMMYYYY(GenUtil.trimDate(SqlDtr.GetValue(6).ToString())); txtDateTo.Text = GenUtil.str2DDMMYYYY(GenUtil.trimDate(SqlDtr.GetValue(7).ToString())); dbobj.SelectQuery("select prod_name+':'+pack_type from products where prod_ID=" + SqlDtr.GetValue(2).ToString() + " ", ref rdr1); if (rdr1.Read()) { ListEmpAssigned.Items.Add(rdr1.GetValue(0).ToString()); } } } dropschid.Visible = true; btschid.Visible = false; SqlDtr.Close(); con.Close(); } else { //02.06.09 DropSchType.SelectedIndex=0; txtschname.Text = ""; txtSchDiscount.Text = ""; DropSchDiscount.SelectedIndex = 0; txtDateFrom.Text = GenUtil.str2DDMMYYYY(System.DateTime.Now.ToShortDateString()); txtDateTo.Text = GenUtil.str2DDMMYYYY(System.DateTime.Now.ToShortDateString()); ListEmpAssigned.Items.Clear(); } CreateLogFiles.ErrorLog("Form:StockiestDiscountEntry.aspx,Method:dropschid_SelectedIndexChange, Userid= " + uid); } catch (Exception ex) { CreateLogFiles.ErrorLog("Form:StockiestDiscountEntry.aspx,Method:dropschid_SelectedIndexChange" + " EXCEPTION " + ex.Message + "Userid= " + uid); } }
/// <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); } } }
/// <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); } } }
/// <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 employee information according to select employee ID in comes from url. /// </summary> protected void Page_Load(object sender, System.EventArgs e) { try { uid = (Session["User_Name"].ToString()); } catch (Exception ex) { CreateLogFiles.ErrorLog("Form:Employee_Update.aspx,Method:page_load" + " EXCEPTION " + ex.Message + uid); Response.Redirect("../../Sysitem/ErrorPage.aspx", false); return; } if (!Page.IsPostBack) { #region Check Privileges int i; string View_flag = "0", Add_Flag = "0", Edit_Flag = "0", Del_Flag = "0"; string Module = "2"; 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") { // string msg="UnAthourized Visit to Enployee Entry Page"; //dbobj.LogActivity(msg,Session["User_Name"].ToString()); Response.Redirect("../../Sysitem/AccessDeny.aspx", false); return; } //************ if (Edit_Flag == "0") { btnUpdate.Enabled = false; } //************ #endregion try { LblEmployeeID.Text = Request.QueryString.Get("ID"); MasterClass obj1 = new MasterClass(); EmployeeClass obj = new EmployeeClass(); SqlDataReader SqlDtr; string sql; getbeat(); #region Fetch Extra Cities,Designation,country and State 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 order by city"; 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(); DropVehicleNo.Items.Clear(); DropVehicleNo.Items.Add("Select"); SqlDtr = obj.GetRecordSet("Select vehicle_no from vehicleentry"); while (SqlDtr.Read()) { DropVehicleNo.Items.Add(SqlDtr.GetValue(0).ToString()); } SqlDtr.Close(); txtLicenseNo.Text = ""; txtLicenseValidity.Text = ""; txtLICNo.Text = ""; txtLICvalidity.Text = ""; DropVehicleNo.SelectedIndex = 0; #endregion SqlDtr = obj.EmployeeList(LblEmployeeID.Text.ToString(), "", ""); while (SqlDtr.Read()) { lblName.Text = SqlDtr.GetValue(1).ToString(); TempEmpName.Text = SqlDtr.GetValue(1).ToString(); DropDesig.SelectedIndex = DropDesig.Items.IndexOf(DropDesig.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())); // If the designation is driver then it shows the extra fields related to driver , else hide that fields. if (SqlDtr.GetValue(2).ToString().Trim().Equals("Driver")) { lblDrLicense.Visible = true; lblLicenseVali.Visible = true; lblLICPolicy.Visible = true; lblLICValid.Visible = true; lblVehicleNo.Visible = true; txtLicenseNo.Visible = true; txtLicenseValidity.Visible = true; txtLICNo.Visible = true; txtLICvalidity.Visible = true; DropVehicleNo.Visible = true; } else { lblDrLicense.Visible = false; lblLicenseVali.Visible = false; lblLICPolicy.Visible = false; lblLICValid.Visible = false; lblVehicleNo.Visible = false; txtLicenseNo.Visible = false; txtLicenseValidity.Visible = false; txtLICNo.Visible = false; txtLICvalidity.Visible = false; DropVehicleNo.Visible = false; } DropCountry.SelectedIndex = DropCountry.Items.IndexOf(DropCountry.Items.FindByValue(SqlDtr.GetValue(6).ToString())); txtContactNo.Text = SqlDtr.GetValue(7).ToString(); if (txtContactNo.Text == "0") { txtContactNo.Text = ""; } txtMobile.Text = SqlDtr.GetValue(8).ToString(); if (txtMobile.Text == "0") { txtMobile.Text = ""; } txtEMail.Text = SqlDtr.GetValue(9).ToString(); txtSalary.Text = SqlDtr.GetValue(10).ToString(); txtOT_Comp.Text = SqlDtr.GetValue(11).ToString(); txtLicenseNo.Text = SqlDtr.GetValue(12).ToString(); txtLicenseValidity.Text = GenUtil.str2DDMMYYYY(trimDate(SqlDtr.GetValue(13).ToString())); txtLICNo.Text = SqlDtr.GetValue(14).ToString(); txtLICvalidity.Text = GenUtil.str2DDMMYYYY(trimDate(SqlDtr.GetValue(15).ToString())); //Response.Write(SqlDtr.GetValue(16).ToString()); SqlDataReader rdr = null; dbobj.SelectQuery("Select vehicle_no from vehicleentry where vehicledetail_id = " + SqlDtr.GetValue(16).ToString(), ref rdr); if (rdr.Read()) { //Response.Write(rdr.GetValue(0).ToString ()); DropVehicleNo.SelectedIndex = DropVehicleNo.Items.IndexOf(DropVehicleNo.Items.FindByValue(rdr.GetValue(0).ToString().Trim())); } rdr.Close(); rdr = null; dbobj.SelectQuery("Select Op_Balance,Bal_Type from Ledger_Master where Ledger_Name = '" + SqlDtr.GetValue(1).ToString() + "'", ref rdr); if (rdr.Read()) { txtopbal.Text = rdr.GetValue(0).ToString(); DropType.SelectedIndex = DropVehicleNo.Items.IndexOf(DropVehicleNo.Items.FindByValue(rdr.GetValue(1).ToString().Trim())); } rdr.Close(); /********Add by vikas 27.10.2012*********************/ if (SqlDtr["Status"].ToString().Trim() != null && SqlDtr["Status"].ToString().Trim() != "") { if (SqlDtr["Status"].ToString().Trim() == "1") { RbtnActive.Checked = true; } else { RbtnNone.Checked = true; } } else { RbtnActive.Checked = false; RbtnNone.Checked = false; } /********End*********************/ } SqlDtr.Close(); } catch (Exception ex) { CreateLogFiles.ErrorLog("Form:Employee_Update.aspx,Method:Page_Load() " + "EmployeeID. EXCEPTION" + ex.Message + " userid " + uid); } } }
/// <summary> /// This is used to fetch the customers/scheme corrosponding to the FO/OeID. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void dropschid_SelectedIndexChanged(object sender, System.EventArgs e) { SqlConnection con; SqlCommand cmd; InventoryClass obj = new InventoryClass(); //SqlDataReader rdr2=null; SqlDataReader rdr1 = null; SqlDataReader rdr3 = null; try { con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["Servosms"]); con.Open(); SqlDataReader SqlDtr; //*** string scheme = dropschid.SelectedItem.Text.Trim().ToString(); string[] schid = scheme.Split(new char[] { ':' }, scheme.Length); //**** cmd = new SqlCommand("select * from foe WHERE foid='" + schid[0] + "'", con); SqlDtr = cmd.ExecuteReader(); ListEmpAssigned.Items.Clear(); Listprodassign.Items.Clear(); if (SqlDtr.HasRows) { while (SqlDtr.Read()) { DropShiftID.SelectedIndex = (DropShiftID.Items.IndexOf((DropShiftID.Items.FindByValue(SqlDtr.GetValue(7).ToString())))); dropdiscount.SelectedIndex = (dropdiscount.Items.IndexOf((dropdiscount.Items.FindByValue(SqlDtr.GetValue(4).ToString())))); if (SqlDtr.GetValue(8).Equals("") || SqlDtr.GetValue(8).Equals("NULL")) { txtschname.Text = ""; } else { txtschname.Text = SqlDtr.GetValue(8).ToString(); } txtrs.Text = SqlDtr.GetValue(3).ToString(); txtDateFrom.Text = GenUtil.str2DDMMYYYY(GenUtil.trimDate(SqlDtr.GetValue(5).ToString())); txtDateTo.Text = GenUtil.str2DDMMYYYY(GenUtil.trimDate(SqlDtr.GetValue(6).ToString())); dbobj.SelectQuery("select cust_name+':'+cust_type from customer where cust_ID=" + SqlDtr.GetValue(1).ToString() + " ", ref rdr1); if (rdr1.Read()) { int x = ListEmpAssigned.Items.IndexOf((ListEmpAssigned.Items.FindByValue(rdr1.GetValue(0).ToString()))); //if(ListEmpAssigned.Items.Contains(rdr1.GetValue(0))) if (x >= 0) { } else { ListEmpAssigned.Items.Add(rdr1.GetValue(0).ToString()); } } //Checkfoe.Checked=true; //Panel1.Visible=true; int i = System.Convert.ToInt32(SqlDtr.GetValue(2).ToString()); if (i != 0) { Checkfoe.Checked = true; Panel1.Visible = true; dbobj.SelectQuery("select prod_name+':'+pack_type from products where prod_ID=" + SqlDtr.GetValue(2).ToString() + " ", ref rdr3); if (rdr3.Read()) { int y = Listprodassign.Items.IndexOf((Listprodassign.Items.FindByValue(rdr3.GetValue(0).ToString()))); if (y >= 0) { } // if(Listprodassign.Items.Contains(rdr3.GetValue(0))) // {} else { Listprodassign.Items.Add(rdr3.GetValue(0).ToString()); } } //**dbobj.SelectQuery("select prod_Name, prod_Name + ':' + pack_type from products order by prod_Name", ref rdr3); //**while(rdr3.Read()) //**{ //** Listprodavail.Items.Add(rdr3.GetValue(1).ToString()); //**} btnall.Text = ">>"; } else { Checkfoe.Checked = false; Panel1.Visible = false; //**dbobj.SelectQuery("select prod_Name, prod_Name + ':' + pack_type from products order by prod_Name", ref rdr3); //**while(rdr3.Read()) //**{ //Listprodassign.Items.Add(rdr3.GetValue(1).ToString()); //** Listprodavail.Items.Add(rdr3.GetValue(1).ToString()); //***} //Listprodavail.Items.Clear(); Listprodassign.Items.Clear(); btnall.Text = "<<"; } } } rdr1.Close(); //rdr2.Close(); rdr3.Close(); dropschid.Visible = true; btschid.Visible = false; SqlDtr.Close(); con.Close(); CreateLogFiles.ErrorLog("Form:fleet/oe discountEntry.aspx,Method:dropschid_SelectedIndexChange, Userid= " + uid); } catch (Exception ex) { CreateLogFiles.ErrorLog("Form:fleet/oe discountEntry.aspx,Method:dropschid_SelectedIndexChange" + " EXCEPTION " + ex.Message + "Userid= " + uid); //MessageBox.Show(ex.Message); } }
/// <summary> /// This method is used to check the user is valid or not after that check permission of that user from database. /// </summary> private void btnSign_ServerClick(object sender, System.Web.UI.ImageClickEventArgs e) { CreateLogFiles.ErrorLog("Form:Login.aspx,Method: btnSign_Click, Login Type " + DropUser.SelectedItem.Text + " and Login User " + txtUserLogin.Text); PetrolPumpClass obj = new PetrolPumpClass(); try { SqlDataReader SqlDtr; string sql; string User_ID = ""; string[,] Privileges = new string[98, 6]; /****add-bhal****/ Session["CurrentDate"] = txtSetDate.Text.ToString(); #region Check for Valid User string pwd = ""; string epassword = ""; sql = "select Password from User_Master where LoginName='" + txtUserLogin.Text + "'"; SqlDtr = obj.GetRecordSet(sql); if (SqlDtr.Read()) { pwd = MySecurity.MySecurity.Decrypt(SqlDtr.GetValue(0).ToString(), "!@#$%^"); if (txtPasswd.Text == pwd) { epassword = SqlDtr.GetValue(0).ToString(); SqlDtr.Close(); } else { RMG.MessageBox.Show("Invalid User Login Name or Password"); return; } } else { RMG.MessageBox.Show("Invalid User Login Name or Password"); return; } SqlDtr.Close(); // Calls the method contactServer by passing the selected date to set the system date as a selected date. string ss = MySecurity.MySecurity.contactServer("[CD]" + convertDate(txtSetDate.Text)); // contactServer("[CD]"+convertDate(TxtDateFrom.Text)); #region get the message from Organisation table and put into session to display in all the invoices dbobj.SelectQuery("Select Message from organisation where CompanyID = 1001", ref SqlDtr); if (SqlDtr.Read()) { Session["Message"] = SqlDtr.GetValue(0).ToString(); } else { Session["Message"] = ""; } SqlDtr.Close(); #endregion #region get the VAT_Rate from Organisation table and put into session to access in Sales and Purchase Invoice. dbobj.SelectQuery("Select VAT_Rate from organisation where CompanyID = 1001", ref SqlDtr); if (SqlDtr.Read()) { Session["VAT_Rate"] = SqlDtr.GetValue(0).ToString(); } else { Session["VAT_Rate"] = ""; } SqlDtr.Close(); #endregion #region get the EntryTax from Organisation table and put into session to access in Sales and Purchase Invoice. dbobj.SelectQuery("Select Entrytax from organisation where CompanyID = 1001", ref SqlDtr); if (SqlDtr.Read()) { Session["Entrytax"] = SqlDtr.GetValue(0).ToString(); } else { Session["Entrytax"] = ""; } SqlDtr.Close(); #endregion #region select the user id ,password compare and stored in a session variable. sql = "select UserID, LoginName,password,Role_Name from User_Master um, Roles r where um.role_ID=r.role_ID and um.LoginName='" + txtUserLogin.Text + "' and password='******' and r.Role_ID=(select Role_ID from Roles where Role_Name='" + DropUser.SelectedItem.Value + "')"; SqlDtr = obj.GetRecordSet(sql); if (SqlDtr.Read()) { User_ID = SqlDtr.GetValue(0).ToString(); Session["User_ID"] = User_ID; //string sss=SqlDtr.GetValue(1).ToString(); Session["User_Name"] = (SqlDtr.GetValue(1).ToString()); //string sss1=(Session["User_Name"].ToString()); Cache["User_Name"] = (SqlDtr.GetValue(1).ToString()); Session["PASSWORD"] = SqlDtr.GetValue(2).ToString(); Session["User_Type"] = SqlDtr.GetValue(3).ToString(); SqlDtr.Close(); } else { RMG.MessageBox.Show("Invalid User Login Name or Password"); return; } SqlDtr.Close(); #endregion #endregion if (User_ID != "") { #region Get The User Permission sql = "select * from Privileges where User_ID='" + User_ID + "'"; SqlDtr = obj.GetRecordSet(sql); for (int i = 0; SqlDtr.Read(); i++) { for (int j = 0; j < 6; j++) { Privileges[i, j] = SqlDtr.GetValue(j + 1).ToString(); } } SqlDtr.Close(); //Session["Privileges"]=Privileges; Cache["Privileges"] = Privileges; #endregion Response.Redirect("HomePage.aspx", false); } else { RMG.MessageBox.Show("Invalid User Login Name or Password"); return; } txtUserLogin.Enabled = true; txtPasswd.Enabled = true; } catch (Exception ex) { CreateLogFiles.ErrorLog("Form:Login.aspx,Method: btnSign_Click, Login Type " + DropUser.SelectedItem.Text + " EXCEPTION " + ex.ToString() + " and Login User " + txtUserLogin.Text); } }
/// <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. /// </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_Entry.aspx,Method:page_load" + " EXCEPTION " + ex.Message + uid); Response.Redirect("../../Sysitem/ErrorPage.aspx", false); return; } if (!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") { // string msg="UnAthourized Visit to Vendor Entry Page"; // dbobj.LogActivity(msg,Session["User_Name"].ToString()); Response.Redirect("../../Sysitem/AccessDeny.aspx", false); } if (Add_Flag == "0") { btnUpdate.Enabled = false; } #endregion getbeat(); // Fills the Credit Limit combo with 30 Numbers. for (i = 1; i <= 30; i++) { DropCrDay.Items.Add(i.ToString()); } PartiesClass obj = new PartiesClass(); SqlDataReader SqlDtr; string sql; GetNextSupplierID(); #region Fetch Extra Cities from Database and add to the ComboBox sql = "select distinct City from Beat_Master order by City asc"; SqlDtr = obj.GetRecordSet(sql); while (SqlDtr.Read()) { DropCity.Items.Add(SqlDtr.GetValue(0).ToString()); } SqlDtr.Close(); #endregion #region Fetch Extra Cities from Database and add to the ComboBox sql = "select distinct state from Beat_Master order by state asc"; SqlDtr = obj.GetRecordSet(sql); while (SqlDtr.Read()) { DropState.Items.Add(SqlDtr.GetValue(0).ToString()); } SqlDtr.Close(); #endregion #region Fetch Extra Cities from Database and add to the ComboBox sql = "select distinct country from Beat_Master order by country asc"; SqlDtr = obj.GetRecordSet(sql); while (SqlDtr.Read()) { DropCountry.Items.Add(SqlDtr.GetValue(0).ToString()); } SqlDtr.Close(); #endregion } catch (Exception ex) { CreateLogFiles.ErrorLog("Form:Supplier_Entry.aspx,Method:page_load" + " EXCEPTION " + ex.Message + uid); } } }
/// <summary> /// this method is used to fatch the CustomerTypeName and CustomerTypeID from CustomerType table /// and fill the textboxes. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void dropid_SelectedIndexChanged(object sender, System.EventArgs e) { try { //add by vikas sharma 23.10.2012 if (dropid.SelectedIndex == 0) { txtname.Text = ""; dropGroup.SelectedIndex = 0; dropSGroup.SelectedIndex = 0; return; } btnEdit.Text = "Update"; btnEdit.Enabled = true; btnDelete.Enabled = true; //dropid.Visible=true; SqlCommand cmd; SqlConnection con; con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["Servosms"]); con.Open(); SqlDataReader SqlDtr; // * cmd=new SqlCommand("select * from CustomerType where CustomerTypeID='"+dropid.SelectedItem.Text.ToString()+"'",con); cmd = new SqlCommand("select * from CustomerType where CustomerTypeName='" + dropid.SelectedItem.Text.Trim().ToString() + "'", con); SqlDtr = cmd.ExecuteReader(); while (SqlDtr.Read()) { txtid.Text = SqlDtr.GetValue(0).ToString(); txtname.Text = SqlDtr.GetValue(1).ToString(); dropGroup.SelectedIndex = dropGroup.Items.IndexOf(dropGroup.Items.FindByText(SqlDtr.GetValue(2).ToString())); //Add by Vikas Sharma 23.10.2012 dropSGroup.SelectedIndex = dropSGroup.Items.IndexOf(dropSGroup.Items.FindByText(SqlDtr.GetValue(3).ToString())); //Add by Vikas Sharma 23.10.2012 } Object Add_Flag = Cache["Add"]; Object Edit_Flag = Cache["Edit"]; Object Del_Flag = Cache["Del"]; if (System.Convert.ToString(Add_Flag) == "0") { btnAdd.Enabled = false; } if (System.Convert.ToString(Edit_Flag) == "0") { btnEdit.Enabled = false; } if (System.Convert.ToString(Del_Flag) == "0") { btnDelete.Enabled = false; } CreateLogFiles.ErrorLog("Form:CustomerType.aspx,Method:Dropid_SelectedIndexChange, userid " + uid); } catch (Exception ex) { CreateLogFiles.ErrorLog("Form:CustomerType.aspx,Method:Dropid_SelectedIndexChange, EXCEPTION " + ex.Message + " userid " + uid); } }
/// <summary> /// This method is used to handle two operation /// if button text name is Edit then fatch the CustomerTypeName from CustomerType table and fill into the /// dropdownlist otherwise update the CustomerType from database. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnEdit_Click(object sender, System.EventArgs e) { try { if (btnEdit.Text.Trim().Equals("Edit")) { dropid.Visible = true; SqlCommand cmd; SqlConnection con; con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["Servosms"]); con.Open(); SqlDataReader SqlDtr; cmd = new SqlCommand("select * from CustomerType order by CustomerTypename", con); SqlDtr = cmd.ExecuteReader(); dropid.Items.Clear(); dropid.Items.Add("Select"); while (SqlDtr.Read()) { dropid.Items.Add(SqlDtr.GetValue(1).ToString()); // * dropid.Items.Add(SqlDtr.GetValue(0).ToString()); } btnEdit.Enabled = false; txtid.Visible = false; btnAdd.Enabled = false; btnDelete.Enabled = false; } // txtid.Text=SqlDtr.GetValue(0).ToString(); // txtname.Text=SqlDtr.GetValue(1).ToString(); //MessageBox.Show("CustomerType Saved"); //txtid.Text=""; //txtname.Text=""; else if (dropid.SelectedItem.Text.Equals("Select")) { MessageBox.Show("Please Select the Customer Type"); return; } if (btnEdit.Text == "Update") { SqlCommand cmd; SqlConnection con; con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["Servosms"]); con.Open(); /********** Add by Vikas Sharma Date 23/10/2012 *****************/ string Group = "", Sub_Group = ""; if (dropGroup.SelectedIndex == 0) { MessageBox.Show("Please select Group"); //fetchGroup(); return; } else { if (dropGroup.SelectedItem.Text == "Other") { if (txtGroup.Text.Trim() == "") { MessageBox.Show("Please specify Other Group"); txtGroup.Enabled = true; //fetchGroup(); return; } else { Group = txtGroup.Text.Trim(); } } else { Group = dropGroup.SelectedItem.Text.Trim(); } } if (dropSGroup.SelectedIndex == 0) { MessageBox.Show("Please select Sub Group"); //fetchGroup(); return; } else { if (dropSGroup.SelectedItem.Text == "Other") { if (txtSGroup.Text.Trim() == "") { MessageBox.Show("Please specify Other Sub Group"); txtSGroup.Enabled = true; //fetchGroup(); return; } else { Sub_Group = txtSGroup.Text.Trim(); } } else { Sub_Group = dropSGroup.SelectedItem.Text.Trim(); } } //SqlDataReader SqlDtr; // * cmd=new SqlCommand("update CustomerType set CustomerTypeName='"+txtname.Text.ToString().Trim()+"' where CustomerTypeID='"+dropid.SelectedItem.Text.ToString().Trim()+"'",con); //Comment by Vikas Sharma 23.10.2012 cmd=new SqlCommand("update CustomerType set CustomerTypeName='"+StringUtil.FirstCharUpper(txtname.Text.ToString().Trim())+"' where CustomerTypeName='"+dropid.SelectedItem.Text.ToString().Trim()+"'",con); cmd = new SqlCommand("update CustomerType set CustomerTypeName='" + StringUtil.FirstCharUpper(txtname.Text.ToString().Trim()) + "', Group_Name='" + StringUtil.FirstCharUpper(Group.ToString().Trim()) + "', Sub_Group_Name='" + StringUtil.FirstCharUpper(Sub_Group.ToString().Trim()) + "' where CustomerTypeName='" + dropid.SelectedItem.Text.ToString().Trim() + "'", con); //Add by Vikas Sharma 23.10.2012 cmd.ExecuteNonQuery(); MessageBox.Show("CustomerType Updated"); btnEdit.Text = "Edit"; dropid.Visible = false; txtid.Visible = true; btnDelete.Enabled = false; fillID(); getGroup(); getSubGroup(); btnAdd.Enabled = true; txtname.Text = ""; txtGroup.Text = ""; txtSGroup.Text = ""; } Object Add_Flag = Cache["Add"]; Object Edit_Flag = Cache["Edit"]; Object Del_Flag = Cache["Del"]; if (System.Convert.ToString(Add_Flag) == "0") { btnAdd.Enabled = false; } if (System.Convert.ToString(Edit_Flag) == "0") { btnEdit.Enabled = false; } if (System.Convert.ToString(Del_Flag) == "0") { btnDelete.Enabled = false; } CreateLogFiles.ErrorLog("Form:CustomerType.aspx,Method:btnEdit, userid " + uid); } catch (Exception ex) { CreateLogFiles.ErrorLog("Form:CustomerType.aspx,Method:btnEdit, EXCEPTION " + ex.Message + " userid " + uid); } }
/// <summary> /// This method is used to fatch the information according to select the Market Custoemr ID /// from dropdownlist in edit time. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void dropid_SelectedIndexChanged(object sender, System.EventArgs e) { btnedit.Text = "UPDATE"; btndelete.Enabled = true; clear(); SqlConnection con; SqlCommand cmd; try { con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["Servosms"]); con.Open(); SqlDataReader SqlDtr; cmd = new SqlCommand("select * from marketCustomerentry1 WHERE mcid='" + dropid.SelectedItem.Text.Trim().ToString() + "'", con); SqlDtr = cmd.ExecuteReader(); if (SqlDtr.HasRows) { while (SqlDtr.Read()) { txtfname.Text = SqlDtr.GetValue(1).ToString(); droptype.SelectedIndex = (droptype.Items.IndexOf((droptype.Items.FindByValue(SqlDtr.GetValue(2).ToString())))); dropplace.SelectedIndex = (dropplace.Items.IndexOf((dropplace.Items.FindByValue(SqlDtr.GetValue(18).ToString())))); txtcontact.Text = SqlDtr.GetValue(3).ToString(); txttelno.Text = SqlDtr.GetValue(4).ToString(); txtdetail.Text = SqlDtr.GetValue(5).ToString(); //Droptype2.SelectedIndex=(Droptype2.Items.IndexOf((Droptype2.Items.FindByValue(SqlDtr4.GetValue(13).ToString())))); dropregcust.SelectedIndex = (dropregcust.Items.IndexOf((dropregcust.Items.FindByValue(SqlDtr.GetValue(6).ToString())))); txtpot.Text = SqlDtr.GetValue(7).ToString(); txtservo.Text = SqlDtr.GetValue(8).ToString(); txtcastrol.Text = SqlDtr.GetValue(9).ToString(); txtshell.Text = SqlDtr.GetValue(10).ToString(); txtbpcl.Text = SqlDtr.GetValue(11).ToString(); txtveedol.Text = SqlDtr.GetValue(12).ToString(); txtelf.Text = SqlDtr.GetValue(13).ToString(); txthpcl.Text = SqlDtr.GetValue(14).ToString(); txtpennzoil.Text = SqlDtr.GetValue(15).ToString(); txtspurious.Text = SqlDtr.GetValue(16).ToString(); txtother.Text = SqlDtr.GetValue(17).ToString(); } } dropid.Visible = true; btnselect.Visible = false; SqlDtr.Close(); con.Close(); Object Add_Flag = Cache["Add"]; Object Edit_Flag = Cache["Edit"]; Object Del_Flag = Cache["Del"]; if (System.Convert.ToString(Add_Flag) == "0") { btnadd.Enabled = false; } if (System.Convert.ToString(Edit_Flag) == "0") { btnedit.Enabled = false; } if (System.Convert.ToString(Del_Flag) == "0") { btndelete.Enabled = false; } CreateLogFiles.ErrorLog("Form:MarketCustEntry.aspx,Method:dropid_SelectedIndexChange, Userid= " + uid); } catch (Exception ex) { CreateLogFiles.ErrorLog("Form:MarketCustEntry.aspx,Method:dropid_SelectedIndexChange" + " EXCEPTION " + ex.Message + "Userid= " + uid); MessageBox.Show(ex.Message); } }
/// <summary> /// This method is used to fatch all information from database according to selected user. /// </summary> protected void DropUserID_SelectedIndexChanged(object sender, System.EventArgs e) { int a = 0; int Modules = 6; /*coment by vikas 29.12.2012 int[] SubModules={4,5,12,13,52,3}; * CheckBox[] ChkView={chkView1, chkView2, chkView3, chkView4, chkView5, chkView6, chkView7, chkView8, chkView9, chkView10, chkView11, chkView12, chkView13, chkView14, chkView15, chkView16, chkView17, chkView18, chkView66, chkView67, chkView68, chkView19, chkView20, chkView21, chkView22, chkView23, chkView24, chkView25, chkView26, chkView27,chkView44,chkView64,chkView69,chkView70, chkView28, chkView29, chkView30, chkView31, chkView32, chkView33, chkView34, chkView35, chkView36, chkView37, chkView38, chkView39,chkView40,chkView41,chkView42,chkView43,chkView45,chkView46,chkView47,chkView48,chkView49,chkView50,chkView54,chkView55,chkView56,chkView57,chkView58,chkView59,chkView60,chkView61,chkView62,chkView63,chkView65,chkView71,chkView72,chkView73,chkView74,chkView76,chkView77,chkView78,chkView79,chkView80,chkView81,chkView82,chkView83,chkView84,chkView85,chkView86,chkView87,chkView88,chkView89,chkView90,chkView51,chkView52,chkView53}; * CheckBox[] ChkAdd={chkAdd1, chkAdd2, chkAdd3, chkAdd4, chkAdd5, chkAdd6, chkAdd7, chkAdd8, chkAdd9, chkAdd10, chkAdd11, chkAdd12, chkAdd13, chkAdd14, chkAdd15, chkAdd16, chkAdd17, chkAdd18, chkAdd66, chkAdd67, chkAdd68, chkAdd19, chkAdd20, chkAdd21, chkAdd22, chkAdd23, chkAdd24, chkAdd25, chkAdd26, chkAdd27,chkAdd44,chkAdd64,chkAdd69,chkAdd70, chkAdd28, chkAdd29, chkAdd30, chkAdd31, chkAdd32, chkAdd33, chkAdd34, chkAdd35, chkAdd36, chkAdd37, chkAdd38, chkAdd39,chkAdd40, chkAdd41,chkAdd42,chkAdd43,chkAdd45,chkAdd46,chkAdd47,chkAdd48,chkAdd49,chkAdd50,chkAdd54,chkAdd55,chkAdd56,chkAdd57,chkAdd58,chkAdd59,chkAdd60,chkAdd61,chkAdd62,chkAdd63,chkAdd65,chkAdd71,chkAdd72,chkAdd73,chkAdd74,chkAdd76,chkAdd77,chkAdd78,chkAdd79,chkAdd80,chkAdd81,chkAdd82,chkAdd83,chkAdd84,chkAdd85,chkAdd86,chkAdd87,chkAdd88,chkAdd89,chkAdd90,chkAdd51,chkAdd52,chkAdd53}; * CheckBox[] ChkEdit={chkEdit1, chkEdit2, chkEdit3, chkEdit4, chkEdit5, chkEdit6, chkEdit7, chkEdit8, chkEdit9, chkEdit10, chkEdit11, chkEdit12, chkEdit13, chkEdit14, chkEdit15, chkEdit16, chkEdit17, chkEdit18, chkEdit66, chkEdit67, chkEdit68, chkEdit19, chkEdit20, chkEdit21, chkEdit22, chkEdit23, chkEdit24, chkEdit25, chkEdit26, chkEdit27,chkEdit44,chkEdit64,chkEdit69,chkEdit70, chkEdit28, chkEdit29, chkEdit30, chkEdit31, chkEdit32, chkEdit33, chkEdit34, chkEdit35, chkEdit36, chkEdit37, chkEdit38, chkEdit39,chkEdit40, chkEdit41,chkEdit42,chkEdit43,chkEdit45,chkEdit46,chkEdit47,chkEdit48,chkEdit49,chkEdit50,chkEdit54,chkEdit55,chkEdit56,chkEdit57,chkEdit58,chkEdit59,chkEdit60,chkEdit61,chkEdit62,chkEdit63,chkEdit65,chkEdit71,chkEdit72,chkEdit73,chkEdit74,chkEdit76,chkEdit77,chkEdit78,chkEdit79,chkEdit80,chkEdit81,chkEdit82,chkEdit83,chkEdit84,chkEdit85,chkEdit86,chkEdit87,chkEdit88,chkEdit89,chkEdit90,chkEdit51,chkEdit52,chkEdit53}; * CheckBox[] ChkDel={chkDel1, chkDel2, chkDel3, chkDel4, chkDel5, chkDel6, chkDel7, chkDel8, chkDel9, chkDel10, chkDel11, chkDel12, chkDel13, chkDel14, chkDel15, chkDel16, chkDel17, chkDel18, chkDel66, chkDel67, chkDel68, chkDel19, chkDel20, chkDel21, chkDel22, chkDel23, chkDel24, chkDel25, chkDel26, chkDel27,chkDel44,chkDel64,chkDel69,chkDel70, chkDel28, chkDel29, chkDel30, chkDel31, chkDel32, chkDel33, chkDel34, chkDel35, chkDel36, chkDel37, chkDel38, chkDel39,chkDel40, chkDel41,chkDel42,chkDel43,chkDel45,chkDel46,chkDel47,chkDel48,chkDel49,chkDel50,chkDel54,chkDel55,chkDel56,chkDel57,chkDel58,chkDel59,chkDel60,chkDel61,chkDel62,chkDel63,chkDel65,chkDel71,chkDel72,chkDel73,chkDel74,chkDel76,chkDel77,chkDel78,chkDel79,chkDel80,chkDel81,chkDel82,chkDel83,chkDel84,chkDel85,chkDel86,chkDel87,chkDel88,chkDel89,chkDel90,chkDel51,chkDel52,chkDel53};*/ int[] SubModules = { 4, 5, 12, 13, 61, 3 }; CheckBox[] ChkView = { chkView1, chkView2, chkView3, chkView4, chkView5, chkView6, chkView7, chkView8, chkView9, chkView10, chkView11, chkView12, chkView13, chkView14, chkView15, chkView16, chkView17, chkView18, chkView66, chkView67, chkView68, chkView19, chkView20, chkView21, chkView22, chkView23, chkView24, chkView25, chkView26, chkView27, chkView44, chkView64, chkView69, chkView70, chkView28, chkView29, chkView30, chkView31, chkView32, chkView33, chkView34, chkView35, chkView36, chkView37, chkView38, chkView39, chkView40, chkView41, chkView42, chkView43, chkView45, chkView46, chkView47, chkView48, chkView49, chkView50, chkView54, chkView55, chkView56, chkView57, chkView58, chkView59, chkView60, chkView61, chkView62, chkView63, chkView65, chkView71, chkView72, chkView73, chkView74, chkView76, chkView77, chkView78, chkView79, chkView80, chkView81, chkView82, chkView83, chkView84, chkView85, chkView86, chkView87, chkView88, chkView89, chkView90, chkView91, chkView92, chkView93, chkView94, chkView95, chkView96, chkView97, chkView98, chkView99, chkView51, chkView52, chkView53 }; CheckBox[] ChkAdd = { chkAdd1, chkAdd2, chkAdd3, chkAdd4, chkAdd5, chkAdd6, chkAdd7, chkAdd8, chkAdd9, chkAdd10, chkAdd11, chkAdd12, chkAdd13, chkAdd14, chkAdd15, chkAdd16, chkAdd17, chkAdd18, chkAdd66, chkAdd67, chkAdd68, chkAdd19, chkAdd20, chkAdd21, chkAdd22, chkAdd23, chkAdd24, chkAdd25, chkAdd26, chkAdd27, chkAdd44, chkAdd64, chkAdd69, chkAdd70, chkAdd28, chkAdd29, chkAdd30, chkAdd31, chkAdd32, chkAdd33, chkAdd34, chkAdd35, chkAdd36, chkAdd37, chkAdd38, chkAdd39, chkAdd40, chkAdd41, chkAdd42, chkAdd43, chkAdd45, chkAdd46, chkAdd47, chkAdd48, chkAdd49, chkAdd50, chkAdd54, chkAdd55, chkAdd56, chkAdd57, chkAdd58, chkAdd59, chkAdd60, chkAdd61, chkAdd62, chkAdd63, chkAdd65, chkAdd71, chkAdd72, chkAdd73, chkAdd74, chkAdd76, chkAdd77, chkAdd78, chkAdd79, chkAdd80, chkAdd81, chkAdd82, chkAdd83, chkAdd84, chkAdd85, chkAdd86, chkAdd87, chkAdd88, chkAdd89, chkAdd90, chkAdd91, chkAdd92, chkAdd93, chkAdd94, chkAdd95, chkAdd96, chkAdd97, chkAdd98, chkAdd99, chkAdd51, chkAdd52, chkAdd53 }; CheckBox[] ChkEdit = { chkEdit1, chkEdit2, chkEdit3, chkEdit4, chkEdit5, chkEdit6, chkEdit7, chkEdit8, chkEdit9, chkEdit10, chkEdit11, chkEdit12, chkEdit13, chkEdit14, chkEdit15, chkEdit16, chkEdit17, chkEdit18, chkEdit66, chkEdit67, chkEdit68, chkEdit19, chkEdit20, chkEdit21, chkEdit22, chkEdit23, chkEdit24, chkEdit25, chkEdit26, chkEdit27, chkEdit44, chkEdit64, chkEdit69, chkEdit70, chkEdit28, chkEdit29, chkEdit30, chkEdit31, chkEdit32, chkEdit33, chkEdit34, chkEdit35, chkEdit36, chkEdit37, chkEdit38, chkEdit39, chkEdit40, chkEdit41, chkEdit42, chkEdit43, chkEdit45, chkEdit46, chkEdit47, chkEdit48, chkEdit49, chkEdit50, chkEdit54, chkEdit55, chkEdit56, chkEdit57, chkEdit58, chkEdit59, chkEdit60, chkEdit61, chkEdit62, chkEdit63, chkEdit65, chkEdit71, chkEdit72, chkEdit73, chkEdit74, chkEdit76, chkEdit77, chkEdit78, chkEdit79, chkEdit80, chkEdit81, chkEdit82, chkEdit83, chkEdit84, chkEdit85, chkEdit86, chkEdit87, chkEdit88, chkEdit89, chkEdit90, chkEdit91, chkEdit92, chkEdit93, chkEdit94, chkEdit95, chkEdit96, chkEdit97, chkEdit98, chkEdit99, chkEdit51, chkEdit52, chkEdit53 }; CheckBox[] ChkDel = { chkDel1, chkDel2, chkDel3, chkDel4, chkDel5, chkDel6, chkDel7, chkDel8, chkDel9, chkDel10, chkDel11, chkDel12, chkDel13, chkDel14, chkDel15, chkDel16, chkDel17, chkDel18, chkDel66, chkDel67, chkDel68, chkDel19, chkDel20, chkDel21, chkDel22, chkDel23, chkDel24, chkDel25, chkDel26, chkDel27, chkDel44, chkDel64, chkDel69, chkDel70, chkDel28, chkDel29, chkDel30, chkDel31, chkDel32, chkDel33, chkDel34, chkDel35, chkDel36, chkDel37, chkDel38, chkDel39, chkDel40, chkDel41, chkDel42, chkDel43, chkDel45, chkDel46, chkDel47, chkDel48, chkDel49, chkDel50, chkDel54, chkDel55, chkDel56, chkDel57, chkDel58, chkDel59, chkDel60, chkDel61, chkDel62, chkDel63, chkDel65, chkDel71, chkDel72, chkDel73, chkDel74, chkDel76, chkDel77, chkDel78, chkDel79, chkDel80, chkDel81, chkDel82, chkDel83, chkDel84, chkDel85, chkDel86, chkDel87, chkDel88, chkDel89, chkDel90, chkDel91, chkDel92, chkDel93, chkDel94, chkDel95, chkDel96, chkDel97, chkDel98, chkDel99, chkDel51, chkDel52, chkDel53 }; EmployeeClass obj = new EmployeeClass(); SqlDataReader SqlDtr; string sql; try { #region Fetch User Name of Selected User string Userid = ""; sql = "select UserID,UserName from User_Master where LoginName='" + DropUserID.SelectedItem.Value + "'"; SqlDtr = obj.GetRecordSet(sql); while (SqlDtr.Read()) { Userid = SqlDtr.GetValue(0).ToString(); txtUserName.Text = SqlDtr.GetValue(1).ToString(); } SqlDtr.Close(); #endregion #region Fetch Privileges of the Selected User ClearCheckBox(); sql = "select * from privileges where User_ID='" + Userid + "'"; SqlDtr = obj.GetRecordSet(sql); while (SqlDtr.Read()) { a = 0; PanelAcc.Visible = true; PanelEmp.Visible = true; PanelMaster.Visible = true; PanelInventory.Visible = true; PanelAdmin.Visible = true; panelLogistics.Visible = true; for (int i = 1; i <= Modules; i++) { for (int j = 1; j <= SubModules[i - 1]; j++) { if ((i == System.Convert.ToInt32(SqlDtr.GetValue(1))) && (j == System.Convert.ToInt32(SqlDtr.GetValue(2)))) { if (SqlDtr.GetValue(3).ToString() == "1") { ChkView[a].Checked = true; } else { ChkView[a].Checked = false; } if (SqlDtr.GetValue(4).ToString() == "1") { ChkAdd[a].Checked = true; } else { ChkAdd[a].Checked = false; } if (SqlDtr.GetValue(5).ToString() == "1") { ChkEdit[a].Checked = true; } else { ChkEdit[a].Checked = false; } if (SqlDtr.GetValue(6).ToString() == "1") { ChkDel[a].Checked = true; } else { ChkDel[a].Checked = false; } } a++; } } } SqlDtr.Close(); #endregion } catch (Exception ex) { CreateLogFiles.ErrorLog("Form:Privileges.aspx,Method:DropUserID_SelectedIndexChanged EXCEPTION: " + ex.Message + " userid " + uid); } }