/// <summary>
/// This method is return the total sales in liter of passing customer id in given period.
/// </summary>
public string GetSalesLtr(string Cust_ID)
{
double sale = 0;
InventoryClass obj = new InventoryClass();
//SqlDataReader rdr = obj.GetRecordSet("select sum(qty*total_qty) from sales_master sm,sales_details sd,products p where p.prod_id=sd.prod_id and sm.invoice_no=sd.invoice_no and cust_id='"+Cust_ID+"' and cast(floor(cast(cast(invoice_date as datetime) as float)) as datetime)>='"+GenUtil.str2MMDDYYYY(txtDateFrom.Text)+"' and cast(floor(cast(cast(invoice_date as datetime) as float)) as datetime)<='"+GenUtil.str2MMDDYYYY(txtDateTo.Text)+"'");
SqlDataReader rdr = obj.GetRecordSet("select sum(qty*total_qty) from sales_master sm,sales_details sd,products p where sm.invoice_no=sd.invoice_no and sd.prod_id=p.prod_id and cust_id in(select cust_id from customer where ssr='" + Cust_ID + "') and cast(floor(cast(cast(invoice_date as datetime) as float)) as datetime)>='" + GenUtil.str2MMDDYYYY(txtDateFrom.Text) + "' and cast(floor(cast(cast(invoice_date as datetime) as float)) as datetime)<='" + GenUtil.str2MMDDYYYY(txtDateTo.Text) + "'");
if (rdr.Read())
{
if (rdr.GetValue(0).ToString() != "")
{
sale = double.Parse(rdr.GetValue(0).ToString());
}
}
rdr.Close();
TotalAmount[0] += sale;
return(GenUtil.strNumericFormat(sale.ToString()));
}
/// <summary>
/// This method is return the total sales amount of passing customer id in given period.
/// </summary>
public string GetSalesRs(string Cust_ID)
{
double sale = 0;
InventoryClass obj = new InventoryClass();
//SqlDataReader rdr = obj.GetRecordSet("select sum(net_amount) from sales_master where cust_id='"+Cust_ID+"' and cast(floor(cast(cast(invoice_date as datetime) as float)) as datetime)>='"+GenUtil.str2MMDDYYYY(txtDateFrom.Text)+"' and cast(floor(cast(cast(invoice_date as datetime) as float)) as datetime)<='"+GenUtil.str2MMDDYYYY(txtDateTo.Text)+"'");
SqlDataReader rdr = obj.GetRecordSet("select sum(net_amount) from sales_master where cust_id in(select cust_id from customer where ssr='" + Cust_ID + "') and cast(floor(cast(cast(invoice_date as datetime) as float)) as datetime)>='" + GenUtil.str2MMDDYYYY(txtDateFrom.Text) + "' and cast(floor(cast(cast(invoice_date as datetime) as float)) as datetime)<='" + GenUtil.str2MMDDYYYY(txtDateTo.Text) + "'");
if (rdr.Read())
{
if (rdr.GetValue(0).ToString() != "")
{
sale = double.Parse(rdr.GetValue(0).ToString());
}
}
rdr.Close();
TotalAmount[1] += sale;
return(GenUtil.strNumericFormat(sale.ToString()));
}
public string GetBeat()
{
InventoryClass obj = new InventoryClass();
SqlDataReader sqldtr;
string sql;
string 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();
return(str);
}
public IHttpActionResult GetSelectedBeat(string BeatNo)
{
InventoryClass obj = new InventoryClass();
SqlDataReader SqlDtr;
string sql;
BeatMasterModel beat = new BeatMasterModel();
sql = "Select * from Beat_Master where Beat_No='" + BeatNo + "'";
SqlDtr = obj.GetRecordSet(sql);
while (SqlDtr.Read())
{
beat.City = SqlDtr.GetValue(1).ToString();
beat.State = SqlDtr.GetValue(2).ToString();
beat.Country = SqlDtr.GetValue(3).ToString();
}
SqlDtr.Close();
return(Ok(beat));
}
protected void Page_Load(object sender, System.EventArgs e)
{
try
{
uid = Session["User_Name"].ToString();
}
catch (Exception ex)
{
CreateLogFiles.ErrorLog("Form:GroupChild.aspx,Method:pageload" + ex.Message + " EXCEPTION " + uid);
Response.Redirect("../../Sysitem/ErrorPage.aspx", false);
return;
}
string childinfo = Request.Params.Get("chk");
str = childinfo.Split(new char[] { ':' }, childinfo.Length);
InventoryClass obj = new InventoryClass();
SqlDataReader dtr = null;
string tempinfo1 = "";
string st = str[0] + " : " + str[1] + " : " + str[2];
/*if(str[2]!="0")
* {
* if(str[1].ToString()=="Sales")
* {
* dtr=obj.GetRecordSet("select distinct Group_Name from oilscheme where sch_id='"+str[2]+"'");
* }
* else
* {
* dtr=obj.GetRecordSet("select distinct Group_Name from Per_Discount where sch_id='"+str[2]+"'");
* }
*
* while(dtr.Read())
* {
* if(dtr["Group_Name"].ToString().Trim()!=null)
* tempinfo1=dtr["Group_Name"].ToString();
* }
* scheme_group=tempinfo1.Split(new char[] {'.'},tempinfo1.Length);
* }*/
//MessageBox.Show(tempinfo1+" : "+scheme_group.Length);
//string st1=scheme_group[0]+" : "+scheme_group[1]+" : "+scheme_group[2]+" : "+scheme_group[3];
btnSubmit.Attributes.Add("OnClick", "getclose();");
}
//This is used to bind the grid.
public void displayReport()
{
try
{
PetrolPumpClass obj1 = new PetrolPumpClass();
TextBox1.Text = DropCustID.SelectedValue.ToString();
InventoryClass obj = new InventoryClass();
SqlDataReader SqlDtr;
string sql = "";
#region Bind DataGrid
if (DropVehicleNo.SelectedIndex == 0)
{
sql = "select sm.invoice_no, slip_no, invoice_date, vehicle_no, prod_Name+ ' ' +Pack_Type Prod_Name, qty, rate, amount from sales_master sm, sales_details sd, products p where sm.invoice_date between '" + ToMMddYYYY(txtDateFrom.Text) + "' and dateadd(day,1,'" + ToMMddYYYY(txtDateTO.Text) + "') and sm.cust_id in ( select cust_id from customer where cust_name=substring('" + DropCustID.SelectedItem.Value + "',1,charindex(':','" + DropCustID.SelectedItem.Value + "')-1) and city=substring('" + DropCustID.SelectedItem.Value + "',charindex(':','" + DropCustID.SelectedItem.Value + "')+1,len('" + DropCustID.SelectedItem.Value + "'))) and sm.sales_type = 'credit' and sm.invoice_no = sd.invoice_no and sd.prod_id = p.prod_id";
}
else
{
sql = "select sm.invoice_no, slip_no, invoice_date, vehicle_no, prod_Name+ ' ' +Pack_Type Prod_Name, qty, rate, amount from sales_master sm, sales_details sd, products p where sm.invoice_date between '" + ToMMddYYYY(txtDateFrom.Text) + "' and dateadd(day,1,'" + ToMMddYYYY(txtDateTO.Text) + "') and sm.cust_id in ( select cust_id from customer where cust_name=substring('" + DropCustID.SelectedItem.Value + "',1,charindex(':','" + DropCustID.SelectedItem.Value + "')-1) and city=substring('" + DropCustID.SelectedItem.Value + "',charindex(':','" + DropCustID.SelectedItem.Value + "')+1,len('" + DropCustID.SelectedItem.Value + "'))) and sm.sales_type = 'credit' and sm.invoice_no = sd.invoice_no and sd.prod_id = p.prod_id and Vehicle_No = '" + DropVehicleNo.SelectedItem.Text + "'";
}
SqlDtr = obj.GetRecordSet(sql);
GridCreditBill.DataSource = SqlDtr;
GridCreditBill.DataBind();
if (GridCreditBill.Items.Count == 0)
{
MessageBox.Show("Data not available");
GridCreditBill.Visible = false;
}
else
{
GridCreditBill.Visible = true;
}
SqlDtr.Close();
checkPrevileges();
#endregion
CreateLogFiles.ErrorLog("Form:Credit_Bill.aspx,Class:PetrolPumpClass.cs,Method:displayReport() Credit Bill Viewed for Bill NO " + lblBillNo.Text.ToString() + " Userid " + uid);
}
catch (Exception ex)
{
CreateLogFiles.ErrorLog("Form:Credit_Bill.aspx ,method :displayReport() " + " Coustmer :" + DropCustID.SelectedValue.ToString() + " is Selected " + ex.Message + " EXCEPTION " + " Userid " + uid);
}
}
/// <summary>
/// This function to retrieve the address from the organization table.
/// </summary>
/// <returns></returns>
public static string GetAddress()
{
InventoryClass obj = new InventoryClass();
SqlDataReader SqlDtr;
string sql, str = "";
sql = "select DealerName,DealerShip,Address,TinNo,PhoneNo,Message,city from organisation";
SqlDtr = obj.GetRecordSet(sql);
if (SqlDtr.Read())
{
str = SqlDtr.GetValue(0).ToString() + ':' + SqlDtr.GetValue(1).ToString() + ':' + SqlDtr.GetValue(2).ToString() + ':' + SqlDtr.GetValue(3).ToString() + ':' + SqlDtr.GetValue(4).ToString() + ':' + SqlDtr.GetValue(5).ToString() + ':' + SqlDtr.GetValue(6).ToString();
}
else
{
str = "";
}
SqlDtr.Close();
return(str);
}
public void GetInfo(string CustomerName)
{
string Cust_ID = "";
InventoryClass obj = new InventoryClass();
InventoryClass obj1 = new InventoryClass();
SqlDataReader rdr = obj.GetRecordSet("select Cust_ID from Customer where Cust_Name='" + CustomerName + "'");
if (rdr.Read())
{
Cust_ID = rdr["Cust_ID"].ToString();
}
rdr.Close();
object ob = null;
if (Cust_ID != "")
{
dbobj.ExecProc(DbOperations_LATEST.OprType.Insert, "ProInsertLedgerDetails", ref ob, "@Cust_ID", Cust_ID);
}
}
public string GetReceipt(string Cust_ID)
{
double sale = 0;
InventoryClass obj = new InventoryClass();
//SqlDataReader rdr = obj.GetRecordSet("select sum(creditAmount) from customerledgertable where particular like 'payment Received%' and custid='"+Cust_ID+"' and cast(floor(cast(cast(entrydate as datetime) as float)) as datetime)>='"+GenUtil.str2MMDDYYYY(txtDateFrom.Text)+"' and cast(floor(cast(cast(entrydate as datetime) as float)) as datetime)<='"+GenUtil.str2MMDDYYYY(txtDateTo.Text)+"'");
SqlDataReader rdr = obj.GetRecordSet("select sum(creditamount) from customerledgertable, customer where custid=cust_id and ssr='" + Cust_ID + "' and particular like 'Payment Received%' and cast(floor(cast(cast(entrydate as datetime) as float)) as datetime)>='" + GenUtil.str2MMDDYYYY(txtDateFrom.Text) + "' and cast(floor(cast(cast(entrydate as datetime) as float)) as datetime)<='" + GenUtil.str2MMDDYYYY(txtDateTo.Text) + "'");
if (rdr.Read())
{
if (rdr.GetValue(0).ToString() != "")
{
sale = double.Parse(rdr.GetValue(0).ToString());
}
}
rdr.Close();
TotalAmount[2] += sale;
TotReceipt = sale; // Add by vikas By vikas 6.3.2013
return(GenUtil.strNumericFormat(sale.ToString()));
}
/// <summary>
/// This method is used to fill the searchable combo box when according to select value from dropdownlist
/// with the help of java script.
/// </summary>
public void GetMultiValue()
{
try
{
InventoryClass obj = new InventoryClass();
SqlDataReader rdr = null;
string strState = "", strDistrict = "", strPlace = "", strSSR = "";
string strGroup = "", strSubGroup = ""; //Add by vikas 16.11.2012
strDistrict = "select distinct state from customer";
strState = "select distinct country from customer";
strPlace = "select distinct city from customer";
strGroup = "select distinct Cust_Name from Customer"; //Add by vikas 16.11.2012
strSubGroup = "select distinct Sub_Group_Name from customertype"; //Add by vikas 16.11.2012
strSSR = "select emp_name from employee where emp_id in(select ssr from customer) and status=1 order by emp_name";
string[] arrStr = { strDistrict, strPlace, strSSR, strGroup, strSubGroup };
HtmlInputHidden[] arrCust = { tempDistrict, tempPlace, tempSSR, tempGroup, tempSubGroup };
for (int i = 0; i < arrStr.Length; i++)
{
rdr = obj.GetRecordSet(arrStr[i].ToString());
if (rdr.HasRows)
{
arrCust[i].Value = "All,";
while (rdr.Read())
{
//DropValue.Items.Add(rdr.GetValue(0).ToString());
//tempCustName.Value+=rdr.GetValue(0).ToString()+",";
if (rdr.GetValue(0).ToString() != null && rdr.GetValue(0).ToString() != "")
{
arrCust[i].Value += rdr.GetValue(0).ToString() + ",";
}
}
}
rdr.Close();
}
}
catch (Exception ex)
{
CreateLogFiles.ErrorLog("Form : HSD_MS_Report,Class:PetrolPumpClass.cs,Method:getMultiValue() Customer Bill Ageing Report Viewed " + ex.Message + " EXCEPTION " + " userid " + uid);
}
}
public string GetLedgerID(string LedgerName)
{
InventoryClass obj = new InventoryClass();
SqlDataReader SqlDtr = null;
string Cust_ID = "";
string sql = "select Ledger_ID from Ledger_Master where Ledger_Name='" + LedgerName + "'";
SqlDtr = obj.GetRecordSet(sql);
if (SqlDtr.Read())
{
Cust_ID = SqlDtr.GetValue(0).ToString();
}
else
{
Cust_ID = "0";
}
SqlDtr.Close();
return(Cust_ID);
}
/// <summary>
/// This method is used to get sum of total spacial discount amount from Accountsledgertable in given date.
/// </summary>
public string GetSpacialDiscount(string Emp_ID)
{
double sd = 0;
InventoryClass obj = new InventoryClass();
//SqlDataReader rdr = obj.GetRecordSet("select sum(credit_amount) from Accountsledgertable where Ledger_id in(select Ledger_id from ledger_master,customer where ledger_name=cust_name and ssr='"+Emp_ID+"') and particulars like 'Receipt_sd%' and cast(floor(cast(cast(entry_date as datetime) as float)) as datetime)>=Convert(datetime,'" + GenUtil.str2DDMMYYYY(Request.Form["txtDateFrom"].ToString()) + "',103) and cast(floor(cast(cast(entry_date as datetime) as float)) as datetime)<=Convert(datetime,'" + GenUtil.str2DDMMYYYY(Request.Form["txtDateTo"].ToString()) + "',103)");
SqlDataReader rdr = obj.GetRecordSet("select sum(credit_amount) from Accountsledgertable where Ledger_id in(select Ledger_id from ledger_master,customer where ledger_name=cust_name and ssr='" + Emp_ID + "') and (particulars like 'Receipt_sd%' or particulars like 'Receipt_fd%' or particulars like 'Receipt_dd%') and cast(floor(cast(cast(entry_date as datetime) as float)) as datetime)>=Convert(datetime,'" + GenUtil.str2DDMMYYYY(Request.Form["txtDateFrom"].ToString()) + "',103) and cast(floor(cast(cast(entry_date as datetime) as float)) as datetime)<=Convert(datetime,'" + GenUtil.str2DDMMYYYY(Request.Form["txtDateTo"].ToString()) + "',103)");
if (rdr.Read())
{
if (rdr.GetValue(0).ToString() != "")
{
sd = double.Parse(rdr.GetValue(0).ToString());
}
}
rdr.Close();
TotalReceipt -= sd;
TotalAmount[2] += sd;
return(GenUtil.strNumericFormat(sd.ToString()));
}
public string GetLedgerIDByBank(string Bank)
{
InventoryClass obj = new InventoryClass();
SqlDataReader SqlDtr = null;
string bankName = "";
var sql = "Select Ledger_ID from Ledger_Master lm,Ledger_Master_sub_grp lmsg where lmsg.sub_grp_id = lm.sub_grp_id and lmsg.sub_grp_name like 'Bank%' and ledger_Name='" + Bank + "'";
SqlDtr = obj.GetRecordSet(sql);
if (SqlDtr.Read())
{
bankName = SqlDtr.GetValue(0).ToString();
}
else
{
bankName = "";
}
SqlDtr.Close();
return(bankName);
}
/// <summary>
/// this method return the total sales in liter of given period.
/// </summary>
public string GetSecSales1(string Month)
{
try
{
SqlDataReader rdr1 = null;
InventoryClass obj = new InventoryClass();
InventoryClass obj1 = new InventoryClass();
double Tot = 0;
string DT = GetDate(Month);
string[] FTDT = DT.Split(new char[] { ':' }, DT.Length);
SqlDataReader rdr = obj.GetRecordSet("select sum(sd.qty*p.Total_Qty) from products p,sales_master sm,sales_details sd where p.Prod_id=sd.prod_id and sm.invoice_no=sd.invoice_no and cast(floor(cast(cast(Invoice_date as datetime) as float)) as datetime)>='" + FTDT[0] + "' and cast(floor(cast(cast(invoice_date as datetime) as float)) as datetime)<='" + FTDT[1] + "'");
if (rdr.Read())
{
if (rdr.GetValue(0).ToString() != "")
{
Tot = double.Parse(rdr.GetValue(0).ToString());
}
else
{
//dbobj.SelectQuery("select total_sales from ly_ps_sale where ly_ps_sales='"+DropYearFrom.SelectedItem.Text+DropYearTo.SelectedItem.Text+"' and month='"+Month+"'",ref rdr1);
rdr1 = obj1.GetRecordSet("select total_sales from ly_ps_sale where ly_ps_sales='" + DropYearFrom.SelectedItem.Text + DropYearTo.SelectedItem.Text + "' and month='" + Month + "'");
if (rdr1.Read())
{
if (rdr1.GetValue(0).ToString() != "")
{
Tot = double.Parse(rdr1.GetValue(0).ToString());
}
}
rdr1.Close();
//InventoryClass obj=new InventoryClass ();
}
}
rdr.Close();
SecSales1 = Tot;
return(System.Convert.ToString(Math.Round(Tot)));
}
catch (Exception ex)
{
CreateLogFiles.ErrorLog("Form:PrimarySecSalesAnalysis.aspx,Method:GetSecLubeSales , EXCEPTION " + ex.Message + ", userid " + uid);
return("0");
}
}
public string FatchCancelReceiptNo1()
{
InventoryClass obj = new InventoryClass();
SqlDataReader rdr = null;
int max = 0, min = 0;
string deleted_invoice = "";
string str = "SELECT max(receipt_no) from Payment_Receipt where cast(floor(cast(cast(Receipt_date as datetime) as float)) as datetime)>=Convert(datetime,'" + GenUtil.str2DDMMYYYY(Request.Form["txtDateFrom"].ToString()) + "',103) and cast(floor(cast(cast(Receipt_date as datetime) as float)) as datetime)<=Convert(datetime,'" + GenUtil.str2DDMMYYYY(Request.Form["txtDateTo"].ToString()) + "',103) and subreceiptno<>'Deleted'";
rdr = obj.GetRecordSet(str);
if (rdr.Read())
{
max = Convert.ToInt32(rdr.GetValue(0));
}
rdr.Close();
str = "SELECT min(receipt_no) from Payment_Receipt where cast(floor(cast(cast(Receipt_date as datetime) as float)) as datetime)>=Convert(datetime,'" + GenUtil.str2DDMMYYYY(Request.Form["txtDateFrom"].ToString()) + "',103) and cast(floor(cast(cast(Receipt_date as datetime) as float)) as datetime)<=Convert(datetime,'" + GenUtil.str2DDMMYYYY(Request.Form["txtDateTo"].ToString()) + "',103) and subreceiptno<>'Deleted'";
rdr = obj.GetRecordSet(str);
if (rdr.Read())
{
min = Convert.ToInt32(rdr.GetValue(0));
}
rdr.Close();
for (int i = min; i <= max; i++)
{
int count = 0;
str = "SELECT count(receipt_no) from payment_receipt where receipt_no=" + i.ToString() + " and subreceiptno<>'deleted'";
rdr = obj.GetRecordSet(str);
if (rdr.Read())
{
count = Convert.ToInt32(rdr.GetValue(0));
}
rdr.Close();
if (count == 0)
{
deleted_invoice += i + ",";
}
}
return(deleted_invoice);
}
/// <summary>
/// This method is used to concating city,state,country for using javascript.
/// </summary>
public void getbeat()
{
try
{
InventoryClass obj = new InventoryClass();
//SqlDataReader sqldtr;
//string sql;
string str = "";
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(BaseUri);
client.DefaultRequestHeaders.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
var Res = client.GetAsync("api/EmployeeEntry/FetchData").Result;
if (Res.IsSuccessStatusCode)
{
var id = Res.Content.ReadAsStringAsync().Result;
str = JsonConvert.DeserializeObject <string>(id);
}
else
{
Res.EnsureSuccessStatusCode();
}
}
txtbeatname.Text = 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()+"#";
//}
//txtbeatname.Text=str;
}
catch (Exception ex)
{
CreateLogFiles.ErrorLog("Form:Employee_Entry.aspx,class:Inventoryclass.cs,method:getbeat()" + "Exception" + ex.Message + uid);
Response.Redirect("../../Sysitem/ErrorPage.aspx", false);
}
}
//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
}
/// <summary>
/// This method is used to get sum of total receipt amount from customerledgertable in given date.
/// </summary>
public string GetReceipt(string Emp_ID)
{
InventoryClass obj = new InventoryClass();
SqlDataReader rdr = obj.GetRecordSet("select sum(creditamount) from customerledgertable where custid in(select cust_id from customer where ssr='" + Emp_ID + "') and particular like 'Payment Received%' and cast(floor(cast(cast(entrydate as datetime) as float)) as datetime)>=Convert(datetime,'" + GenUtil.str2DDMMYYYY(Request.Form["txtDateFrom"].ToString()) + "',103) and cast(floor(cast(cast(entrydate as datetime) as float)) as datetime)<=Convert(datetime,'" + GenUtil.str2DDMMYYYY(Request.Form["txtDateTo"].ToString()) + "',103)");
if (rdr.Read())
{
if (rdr.GetValue(0).ToString() != "")
{
TotalReceipt = double.Parse(rdr.GetValue(0).ToString());
}
else
{
TotalReceipt = 0;
}
}
rdr.Close();
TotalAmount[0] += TotalReceipt;
return(GenUtil.strNumericFormat(TotalReceipt.ToString()));
}
/// <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 bool CheckInvoiceEnabled()
{
InventoryClass obj = new InventoryClass();
SqlDataReader sqldtr;
string sql;
bool enabled = false;
sql = "select * from Sales_Master";
sqldtr = obj.GetRecordSet(sql);
if (sqldtr.Read())
{
enabled = true;
}
else
{
enabled = false;
}
sqldtr.Close();
return(enabled);
}
/// <summary>
/// This method is used to fatch the all customer whose ssr is select from dropdownlist
/// and fill the data in both list.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void DropSSRName_SelectedIndexChanged(object sender, System.EventArgs e)
{
try
{
InventoryClass obj = new InventoryClass();
SqlDataReader rdr = obj.GetRecordSet("select Cust_Name from Customer where ssr=(select Emp_ID from Employee where Emp_Name='" + DropSSRName.SelectedItem.Text + "') order by Cust_Name");
ListassignCustomer.Items.Clear();
FillList();
while (rdr.Read())
{
ListassignCustomer.Items.Add(rdr["Cust_Name"].ToString());
ListCustomer.Items.Remove(rdr["Cust_Name"].ToString());
}
rdr.Close();
}
catch (Exception ex)
{
CreateLogFiles.ErrorLog("Form:CustomerMapping.aspx,Method:DropSSRName_SelectedIndexChanged, EXCEPTION " + ex.Message + " User " + uid);
}
}
/// <summary>
/// This method is not used.
/// </summary>
public void GetVat()
{
InventoryClass obj = new InventoryClass();
SqlDataReader rdr = obj.GetRecordSet("select * from organisation");
if (rdr.Read())
{
txtModVat.Text = rdr["Vat_Rate"].ToString();
//txtSalesVat.Text=rdr["Vat_Rate"].ToString();
//txtPurVat.Text=rdr["Vat_Rate"].ToString();
chkModVat.Checked = true;
//chkSalesVat.Checked=true;
//chkPurVat.Checked=true;
//CheckBoxCGST2.Checked = true;
//CheckBoxSGST2.Checked = true;
//CheckBoxcgst.Checked = true;
//CheckBoxsgst.Checked = true;
}
rdr.Close();
}
public string GetCustomerID(CustomerModels customer)
{
InventoryClass obj = new InventoryClass();
SqlDataReader SqlDtr, rdr;
string sql;
string Cust_ID = "";
sql = "select Cust_ID from Customer where Cust_Name='" + customer.CustomerName + "' and City = '" + customer.City + "'";
SqlDtr = obj.GetRecordSet(sql);
if (SqlDtr.Read())
{
Cust_ID = SqlDtr.GetValue(0).ToString();
}
else
{
Cust_ID = "0";
}
SqlDtr.Close();
return(Cust_ID);
}
public frmImages(Guid siteID, Guid inventoryID, InventoryClass ic, string bredPackageFileName)
{
this.DragEnter += new DragEventHandler(this.frmImages_DragEnter);
this.DragDrop += new DragEventHandler(this.frmImages_DragDrop);
this._existingIsSelected = false;
this.InitializeComponent();
this._siteGuid = siteID;
this._invGuid = inventoryID;
this._inventoryClass = ic;
this._bredPackageFileName = bredPackageFileName;
if (this._bredPackage == null)
{
this._bredPackage = new ZipBredPackage(this._bredPackageFileName, false);
this._bredPackage.LoadManifest();
}
this._pendingList = new List <IAttachmentInfo>();
this.lbPending.DataSource = (object)this._pendingList;
this.lbPending.DisplayMember = "FileName";
this.RefreshControls();
}
protected void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
try
{
uid = Session["User_Name"].ToString();
}
catch (Exception ex)
{
CreateLogFiles.ErrorLog("Form:SchemeDiscount.aspx,Method:pageload" + ex.Message + " EXCEPTION " + uid);
Response.Redirect("../../Sysitem/ErrorPage.aspx", false);
return;
}
string s = Request.Params.Get("chk");
str = s.Split(new char[] { ':' }, s.Length);
InventoryClass obj = new InventoryClass();
chkinfo.Value = str[0];
btnSubmit.Attributes.Add("OnClick", "check();");
}
/// <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);
}
}
// 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
}
//public double BasicSalary = 0;
//public double[] TotalSalary = new double[7];
/// <summary>
/// This method is used to get sum of total receipt amount from customerledgertable in given date.
/// </summary>
public string GetBasicSalary(string Emp_ID)
{
double BasicSalary = 0;
InventoryClass obj = new InventoryClass();
SqlDataReader rdr = obj.GetRecordSet("select salary from employee where emp_id=" + Emp_ID);
if (rdr.Read())
{
if (rdr.GetValue(0).ToString() != "")
{
BasicSalary = double.Parse(rdr.GetValue(0).ToString());
}
else
{
BasicSalary = 0;
}
}
rdr.Close();
TotalAmount[7] += BasicSalary;
return(GenUtil.strNumericFormat(BasicSalary.ToString()));
}
public IHttpActionResult GetNextID()
{
InventoryClass obj = new InventoryClass();
SqlDataReader SqlDtr;
string customerID = "";
#region Fetch Next Customer ID
string sql = "select max(Cust_ID)+1 from Customer";
SqlDtr = obj.GetRecordSet(sql);
while (SqlDtr.Read())
{
customerID = SqlDtr.GetSqlValue(0).ToString();
if (customerID == "Null")
{
customerID = "1001";
}
}
SqlDtr.Close();
#endregion
return(Ok(customerID));
}
/// <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);
}
}
