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