private void CancelOrderById(int id) { DS = new DataSet(); billdata = new BillData(); int flag = 1; int CancelBy = GlobalInfo.Userid; int result = billdata.CancelOrderById(id, flag, CancelBy, string.Empty); if (result > 0) { divDanger.Visible = false; divwarning.Visible = false; divSusccess.Visible = true; lblSuccess.Text = "Order Cancelled Successfully"; pnlError.Update(); bindList(); uprouteList.Update(); } else { divDanger.Visible = false; divwarning.Visible = true; divSusccess.Visible = false; lblwarning.Text = "Please Contact to Site Admin"; pnlError.Update(); } }
private static void AddTitle(Document document, BillData bill) { document.Add(string.Format("Счет на оплату № {0} от {1}", bill.Number, bill.SaveDate.ToString("dd MMMM yyyy")).Phrase(TitleFont)); Line(document); }
public ActionResult ExportToExcel() { var model = new BillData().ExportExcel(); //var excel = model.Select(x => new { x.billID,x.name,x.createDate,x.totalMoney,x.billStatus,x.address,x.creditCard}); foreach (var item in model) { switch (item.status) { case 0: item.billStatus = "Chờ xác nhận"; break; case 1: item.billStatus = "Chờ lấy hàng"; break; case 2: item.billStatus = "Đang giao"; break; case 3: item.billStatus = "Đã giao"; break; case 4: item.billStatus = "Đã hủy"; break; case 5: item.billStatus = "Trả hàng/Hoàn tiền"; break; } } DataTable dt = ToDataTable(model); dt.Columns.RemoveAt(1); dt.Columns.RemoveAt(4); dt.Columns[0].ColumnName = "Mã hóa đơn"; dt.Columns[1].ColumnName = "Tên khách hàng"; dt.Columns[2].ColumnName = "Ngày mua"; dt.Columns[3].ColumnName = "Tổng tiền"; dt.Columns[4].ColumnName = "Tình trạng"; dt.Columns[5].ColumnName = "Địa chỉ"; dt.Columns[6].ColumnName = "Số thẻ tín dụng"; //Name of File string fileName = "HoaDon.xlsx"; using (XLWorkbook wb = new XLWorkbook()) { //Add DataTable in worksheet wb.Worksheets.Add(dt); using (MemoryStream stream = new MemoryStream()) { wb.SaveAs(stream); //Return xlsx Excel File return(File(stream.ToArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName)); } } }
private static void AddMoney(Document document, BillData bill) { var table = new PdfPTable(2) { WidthPercentage = 100 }; table.SetWidths(new[] { 600, 120 }); table.DefaultCell.Border = Rectangle.NO_BORDER; var price = (bill.Price * bill.EuroToRuble); var priceVat = GetPriceVAT(bill.VAT, price).ToString("N2"); table.AddCell("Итого:".Phrase(BoldFont).RightCell().NoBorder()); table.AddCell(price.ToString("N2").Phrase(BoldFont).RightCell().NoBorder()); table.AddCell("В том числе НДС:".Phrase(BoldFont).RightCell().NoBorder()); table.AddCell(priceVat.Phrase(BoldFont).RightCell().NoBorder()); table.AddCell("Всего к оплате:".Phrase(BoldFont).RightCell().NoBorder()); table.AddCell(price.ToString("N2").Phrase(BoldFont).RightCell().NoBorder()); document.Add(table); document.Add(string.Format( "Всего наименований {0}, на сумму {1} руб." + Environment.NewLine, bill.Count, price.ToString("N2")) .Phrase(DefaultFont)); document.Add((NumByWords.RurPhrase(price) + Environment.NewLine).Phrase(BoldFont)); Line(document); }
private static void AddGoods(Document document, BillData bill) { var table = new PdfPTable(6) { WidthPercentage = 100 }; table.SetWidths(new[] { 30, 370, 60, 60, 100, 100 }); table.AddCell("№".Phrase(BoldFont).CenterCell()); table.AddCell("Товары (работы, услуги)".Phrase(BoldFont).CenterCell()); table.AddCell("Кол-во".Phrase(BoldFont).CenterCell()); table.AddCell("Ед.".Phrase(BoldFont).CenterCell()); table.AddCell("Цена".Phrase(BoldFont).CenterCell()); table.AddCell("Сумма".Phrase(BoldFont).CenterCell()); table.AddCell("1".Phrase(DefaultFont).CenterCell()); table.AddCell(bill.Goods.Phrase(DefaultFont)); table.AddCell(bill.Count.ToString(CultureInfo.InvariantCulture).Phrase(DefaultFont)); table.AddCell("шт.".Phrase(DefaultFont).CenterCell()); var price = (bill.Price * bill.EuroToRuble).ToString("N2"); table.AddCell(price.Phrase(DefaultFont).RightCell()); table.AddCell(price.Phrase(DefaultFont).RightCell()); document.Add(table); }
private static void AddHeadAndAccountant(Document document, BillData bill) { var table = new PdfPTable(4) { WidthPercentage = 100 }; table.SetWidths(new[] { 120, 240, 120, 240 }); table.DefaultCell.Border = Rectangle.NO_BORDER; table.AddCell("Руководитель".Phrase(BoldFont)); var headCell = bill.Head.Phrase(BoldFont).RightCell(); headCell.Border = Rectangle.BOTTOM_BORDER; table.AddCell(headCell); table.AddCell("Бухгалтер".Phrase(BoldFont)); var accountantCell = bill.Accountant.Phrase(BoldFont).RightCell(); accountantCell.Border = Rectangle.BOTTOM_BORDER; table.AddCell(accountantCell); document.Add(table); }
// GET: Admin/Export public ActionResult Index() { var model = new BillData().ListAll(); ViewBag.Name = new UserData().ListAll(); return(View(model)); }
public void AddOrReplace(long applicationId, BillData data) { _executor.Execute("[dbo].[Bill_AddOrReplace]", new { applicationId, data.Accountant, data.Bank, data.BIC, data.Client, data.CorrespondentAccount, data.Count, data.CurrentAccount, data.Goods, data.Head, data.HeaderText, data.Payee, data.Price, data.Shipper, data.TaxRegistrationReasonCode, data.TIN, data.VAT, data.EuroToRuble, data.Number, data.SaveDate, data.SendDate }); }
protected void lblCancelBooth_Click(object sender, EventArgs e) { DS = new DataSet(); billdata = new BillData(); int flag = 11; int id = Convert.ToInt32(hfBoothOrderId.Value); //Convert.ToInt32(dpBillType.SelectedItem.Value); int CancelBy = GlobalInfo.Userid; int result = billdata.CancelOrderById(id, flag, CancelBy, dpBillType.SelectedItem.Text); if (result > 0) { divDanger.Visible = false; divwarning.Visible = false; divSusccess.Visible = true; lblSuccess.Text = "Order Cancelled Successfully"; pnlError.Update(); uprouteList.Update(); } else { divDanger.Visible = false; divwarning.Visible = true; divSusccess.Visible = false; lblwarning.Text = "Please Contact to Site Admin"; pnlError.Update(); } }
private void ChangeBillDataAmounts(BillData data, decimal baseprice) { decimal newprice = baseprice * Convert.ToDecimal(1.5); decimal newAmount = newprice * Convert.ToDecimal(data.Quantity); decimal newVatPercent = Convert.ToDecimal(data.VatPercent.Replace("%", "")); // надо перепроверить тут строка "0.2"!! decimal newAmountOfVat = newAmount * newVatPercent; decimal newTotalamount = newAmount + newAmountOfVat; string resprice = null; string resAmount = null; string resAmountOfVat = null; string resTotalamount = null; if (separator == ",") { resprice = Convert.ToString(newprice).Replace(".", ","); resAmount = Convert.ToString(newAmount).Replace(".", ",");; resAmountOfVat = Convert.ToString(newAmountOfVat).Replace(".", ",");; resTotalamount = Convert.ToString(newTotalamount).Replace(".", ",");; } else if (separator == ".") { resprice = Convert.ToString(newprice).Replace(",", "."); resAmount = Convert.ToString(newAmount).Replace(",", ".");; resAmountOfVat = Convert.ToString(newAmountOfVat).Replace(",", ".");; resTotalamount = Convert.ToString(newTotalamount).Replace(",", ".");; } data.Price = resprice; data.Amount = resAmount; data.AmountOfVat = resAmountOfVat; data.TotalAmount = resTotalamount; // надо провести округления !!!! }
//Action public void MakeTheCheckedBill(string path, string course, string pathtosave) { DeepCopier copier = new DeepCopier(); GetDataFromBill(path); GammaMod.GetAll(); foreach (var billposition in bills) { FurcomMod.GetByName(billposition.Name.GeneralName); FurcomIdReceiver IdReceiver = new FurcomIdReceiver(); FurcomModel loc = (FurcomModel)FurcomMod; string id = IdReceiver.GetIdFromFurcomProductDescr(loc.SelectedData[0].Description); CheckerGammaList GetterFromGamma = new CheckerGammaList(); GammaModel loc2 = (GammaModel)GammaMod; GetterFromGamma.FindOfferInGammaBase(id, loc2.SelectedData); offer result = GetterFromGamma.FoundOffer; BillData newbilldata = copier.DeepClone <BillData>(billposition); // это надо проверить decimal targetprice = ConvertRURintoBYN(course, result.Price); ChangeBillDataAmounts(newbilldata, targetprice); OutputBills.Add(newbilldata); } BillFormer former = new BillFormer(); former.FormBill(pathtosave, OutputBills, Raredata); }
public GenerateTokenRequest SetBill(BillData billData) { AddAdditionalData(nameof(billData.BillId), billData.BillId); AddAdditionalData(nameof(billData.PayId), billData.PayId); AddAdditionalData(nameof(billData.PhoneNumber), billData.PhoneNumber); return(SetServiceType(ServiceType.Bill)); }
public JsonResult ChangeStatus(long id) { var result = new BillData().ChangeStatus(id); return(Json(new { status = result })); }
// GET: Admin/Bill public ActionResult Index(string searchString, int page = 1, int pageSize = 4) { var data = new BillData(); var model = data.ListAllBill(searchString, page, pageSize); ViewBag.Bill = data.ListAll(); ViewBag.User = new UserData().ListAll(); ViewBag.SearchString = searchString; return(View(model)); }
/// <summary> /// Гүйлгээний мэдээллийг JSON форматанд хөрвүүлэн /// сугалаа,баримтын дугаар, QR код г.м мэдээллийг үүсгэнэ /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void buttonCreateBill_Click(object sender, EventArgs e) { var data = new BillData(); data.posNo = textBoxPosNo.Text; data.amount = textBoxAmount.Text; data.vat = textBoxVat.Text; data.cashAmount = textBoxCash.Text; data.nonCashAmount = textBoxNonCash.Text; data.billIdSuffix = textBoxNumber.Text; var lstBillStock = new List <BillDetail>(); foreach (DataGridViewRow row in dataGridViewStocks.Rows) { if (!row.IsNewRow) { var stock = new BillDetail(); stock.code = row.Cells["Code"].Value.ToString(); stock.name = row.Cells["ItemName"].Value.ToString(); stock.measureUnit = row.Cells["MeasureUnit"].Value.ToString(); stock.qty = row.Cells["Qty"].Value.ToString(); stock.unitPrice = row.Cells["UnitPriceNonVat"].Value.ToString(); stock.totalAmount = row.Cells["Amount"].Value.ToString(); stock.vat = row.Cells["Vat"].Value.ToString(); stock.barCode = row.Cells["BarCode"].Value.ToString(); stock.cityTax = row.Cells["CityTax"].Value.ToString(); lstBillStock.Add(stock); } } data.cityTax = textBoxCityTax.Text; data.bankTransactions = this.ListBankTranscation; if (lstBillStock.Count == 0) { lstBillStock = null; } data.stocks = lstBillStock; data.districtCode = textBoxDistrict.Text; var json = new JavaScriptSerializer().Serialize(data); var result = Program.put(json); this.resultData = new JavaScriptSerializer().Deserialize <Result>(result); if ("True".Equals(this.resultData.success.ToString())) { print(); } else { MessageBox.Show(resultData.message); } }
private static void AddHeader(Document document, BillData bill) { var header = new Paragraph(bill.HeaderText.Phrase(SmallFont)) { SpacingAfter = 30, Alignment = Element.ALIGN_CENTER, IndentationLeft = 50, IndentationRight = 50 }; document.Add(header); }
private void bindList() { string result = string.Empty; billdata = new BillData(); DS = new DataSet(); DS = billdata.GetOrdersForEdit((Convert.ToDateTime(txtDate.Text)).ToString("dd-MM-yyyy"), Convert.ToInt32(dpRoute.SelectedItem.Value), Convert.ToInt32(dpBrand.SelectedValue)); rpOrderList.DataSource = DS; rpOrderList.DataBind(); }
public ActionResult Success(long id) { var session = (UserLogin)Session[CommonConstants.USER_SESSION]; if (session == null) { return(RedirectToAction("Login", "Login")); } var model = new BillData().ListBillByID(session.userID, id); ViewBag.UserName = session.name; return(View(model)); }
private void bindList() { string result = string.Empty; billdata = new BillData(); DS = new DataSet(); int flag = 0; DS = billdata.GetEditReturnSchemeDetails((Convert.ToDateTime(txtDate.Text)).ToString("dd-MM-yyyy"), Convert.ToInt32(dpRoute.SelectedItem.Value), flag); rpOrderList.DataSource = DS; rpOrderList.DataBind(); }
protected void btnSearch_Click(object sender, EventArgs e) { billdata = new BillData(); DS = new DataSet(); DS = billdata.GetOrdersForCancel(txtBillNo.Text.ToString(), Convert.ToInt32(dpBillType.SelectedItem.Value), 10); if (!Comman.Comman.IsDataSetEmpty(DS)) { lblBoothName.Text = DS.Tables[0].Rows[0]["Bname"].ToString(); lblCreatedBy.Text = DS.Tables[0].Rows[0]["ename"].ToString(); lblTotalBill.Text = Convert.ToDecimal(DS.Tables[0].Rows[0]["TotalBill"]).ToString("#0.00"); hfBoothOrderId.Value = DS.Tables[0].Rows[0]["OrderId"].ToString(); lblCancelBooth.Text = "Cancel"; string empname; string agencyname; try { empname = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["EmployeeName"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["EmployeeName"].ToString(); } catch (Exception) { empname = string.Empty; } try { agencyname = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["AgentName"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["AgentName"].ToString(); } catch (Exception) { agencyname = string.Empty; } if (empname == string.Empty && agencyname == string.Empty) { lblName.Text = "Local Sale"; } else if (!(empname == string.Empty) && agencyname == string.Empty) { lblName.Text = DS.Tables[0].Rows[0]["EmployeeCode"].ToString() + ' ' + DS.Tables[0].Rows[0]["EmployeeName"].ToString(); } else if (empname == string.Empty && !(agencyname == string.Empty)) { lblName.Text = DS.Tables[0].Rows[0]["AgentCode"].ToString() + ' ' + DS.Tables[0].Rows[0]["AgentName"].ToString(); } } else { lblBoothName.Text = "No Order Found"; lblName.Text = string.Empty; lblCreatedBy.Text = string.Empty; lblTotalBill.Text = string.Empty; lblCancelBooth.Text = string.Empty; } }
private static void AddBankDetails(Document document, BillData bill) { var table = new PdfPTable(4) { WidthPercentage = 100 }; table.SetWidths(new[] { 220, 220, 60, 220 }); var bankPhrase = (bill.Bank + Environment.NewLine + Environment.NewLine).Phrase(DefaultFont); bankPhrase.Add("Банк получателя".Phrase(SmallFont)); table.AddCell(new PdfPCell(bankPhrase) { Colspan = 2, Rowspan = 2 }); table.AddCell("БИК".Phrase(DefaultFont)); table.AddCell(bill.BIC.Phrase(DefaultFont)); table.AddCell("Сч. №".Phrase(DefaultFont)); table.AddCell(bill.CorrespondentAccount.Phrase(DefaultFont)); table.AddCell(("ИНН " + bill.TIN).Phrase(DefaultFont)); table.AddCell(("КПП " + bill.TaxRegistrationReasonCode).Phrase(DefaultFont)); table.AddCell(new PdfPCell("Сч. №".Phrase(DefaultFont)) { Rowspan = 2 }); table.AddCell(new PdfPCell(bill.CurrentAccount.Phrase(DefaultFont)) { Rowspan = 2 }); var payeePhrase = (bill.Payee + Environment.NewLine + Environment.NewLine).Phrase(DefaultFont); payeePhrase.Add("Получатель".Phrase(SmallFont)); table.AddCell(new PdfPCell(payeePhrase) { Colspan = 2 }); document.Add(table); document.Add(Environment.NewLine.Phrase(DefaultFont)); }
protected void btnPrint_Click(object sender, EventArgs e) { try { DataSet DS3 = new DataSet(); BillData printbilldata = new BillData(); DS3 = printbilldata.UpdatePrintedBillByDate((Convert.ToDateTime(txtDate.Text)).ToString("dd-MM-yyyy"), Convert.ToInt32(dpRoute.SelectedItem.Value), Convert.ToInt32(dpAgentSelasEMployee.SelectedItem.Value)); } catch { txtDate.Focus(); dpAgentSelasEMployee.Focus(); dpRoute.Focus(); } }
private static void Fill(Document document, BillData bill) { AddHeader(document, bill); AddBankDetails(document, bill); AddTitle(document, bill); AddParticipants(document, bill); AddGoods(document, bill); AddMoney(document, bill); AddHeadAndAccountant(document, bill); }
public async Task <IActionResult> PayBill(PayBillViewModel data) { try { var billData = new BillData(data.BillId, data.PayId, data.PhoneNumber); var tokenModel = await _services.GenerateBillToken(data.Amount, GenerateCallbackUrl(Request), billData, data.Mobile); return(View("Pay", tokenModel)); } catch (Exception exc) { return(View("Error", new ErrorViewModel { Message = exc.Message })); } }
private void GetDetails(int id) { DS = new DataSet(); billdata = new BillData(); int flag = 1; double qty = 0; DS = billdata.GetOrdersbyOrderDetailsId(id, flag, qty); if (!Comman.Comman.IsDataSetEmpty(DS)) { if (!string.IsNullOrEmpty(DS.Tables[0].Rows[0]["ProductName"].ToString())) { txtName.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["EmployeeName"].ToString()) ? DS.Tables[0].Rows[0]["AgentName"].ToString() : DS.Tables[0].Rows[0]["EmployeeName"].ToString(); txtProductName.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["ProductName"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["ProductName"].ToString(); txtPrvQuantity.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Qty"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Qty"].ToString(); txtNewQuantity.Text = string.Empty; //txtIfsc.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["IFSCcode"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["IFSCcode"].ToString(); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true); } else { flag = 3; int result = billdata.EditOrders(id, flag, qty); if (result > 0) { divDanger.Visible = false; divwarning.Visible = false; divSusccess.Visible = true; lblSuccess.Text = "Edited Successfully"; pnlError.Update(); bindList(); uprouteList.Update(); } else { divDanger.Visible = false; divwarning.Visible = true; divSusccess.Visible = false; lblwarning.Text = "Please Contact to Site Admin"; pnlError.Update(); } } } }
private static void AddParticipants(Document document, BillData bill) { var table = new PdfPTable(2) { WidthPercentage = 100 }; table.SetWidths(new[] { 100, 620 }); table.DefaultCell.Border = Rectangle.NO_BORDER; table.SpacingAfter = 6; table.AddCell("Поставщик:".Phrase(DefaultFont)); table.AddCell(bill.Shipper.Phrase(BoldFont)); table.AddCell("Покупатель:".Phrase(DefaultFont)); table.AddCell(bill.Client.Phrase(BoldFont)); document.Add(table); }
protected void btnSubmit_Click(object sender, EventArgs e) { DS = new DataSet(); billdata = new BillData(); int id = Convert.ToInt32(hbankId.Value); int result = 0; double qty = string.IsNullOrEmpty(txtNewQuantity.Text)? 0: Convert.ToDouble(txtNewQuantity.Text); if (qty != 0) { int flag = 2; result = billdata.EditOrders(id, flag, qty); } else { int flag = 4; result = billdata.EditOrders(id, flag, qty); } if (result > 0) { divDanger.Visible = false; divwarning.Visible = false; divSusccess.Visible = true; lblSuccess.Text = "Edited Successfully"; pnlError.Update(); bindList(); uprouteList.Update(); } else { divDanger.Visible = false; divwarning.Visible = true; divSusccess.Visible = false; lblwarning.Text = "Please Contact to Site Admin"; pnlError.Update(); } }
public BillModel GetBillModel(BillData bill) { return(new BillModel { BankDetails = new BankDetails { Bank = bill.Bank, BIC = bill.BIC, CorrespondentAccount = bill.CorrespondentAccount, CurrentAccount = bill.CurrentAccount, Payee = bill.Payee, TaxRegistrationReasonCode = bill.TaxRegistrationReasonCode, TIN = bill.TIN }, Accountant = bill.Accountant, Head = bill.Head, HeaderText = bill.HeaderText, Shipper = bill.Shipper, Client = bill.Client, Count = bill.Count, Goods = bill.Goods, PriceRuble = bill.Price * bill.EuroToRuble }); }
private void GetDataFromBill(string path) { int beginrow = 0; int endrow = 0; bool beginflag = false; bool endflag = false; bills = new List <BillData>(); FileInfo file = new FileInfo(path); Raredata = new RareMutableData(); using (ExcelPackage exc = new ExcelPackage(file)) { ExcelWorksheet worksheet = exc.Workbook.Worksheets[1]; ExcelRange Dimension = worksheet.Cells; for (int i = 1; i < Dimension.End.Row; i++) { if (worksheet.Cells[i, 1].Value.ToString() == "Продавец:") { Raredata.User = worksheet.Cells[i, 3].Value.ToString(); } else if (worksheet.Cells[i, 1].Value.ToString().Contains("Пред-счет")) { Raredata.Date = worksheet.Cells[i, 1].Value.ToString().Replace("Пред-счет №б/н от ", "").Replace(" года", "").Trim(); } else if (worksheet.Cells[i, 1].Value.ToString() == "Покупатель:") { Raredata.Buyer = worksheet.Cells[i, 3].Value.ToString(); } if (worksheet.Cells[i, 1].Value.ToString() == "№") { beginrow = i; beginflag = true; } else if (worksheet.Cells[i, 1].Value.ToString() == "Итого") { endrow = i; endflag = true; } else if (beginflag & endflag) { break; } } if (beginflag && endflag) { for (int i = beginrow + 1; i < endrow; i++) { BillData loc = new BillData(); loc.Position = i; loc.BillPosition = Convert.ToInt32(worksheet.Cells[i, 1].Value); loc.Name = new BillPositionName(worksheet.Cells[i, 2].Value.ToString()); loc.Quantity = worksheet.Cells[i, 3].Value.ToString(); loc.Package = worksheet.Cells[i, 4].Value.ToString(); loc.Price = worksheet.Cells[i, 5].Value.ToString(); loc.Amount = worksheet.Cells[i, 6].Value.ToString(); loc.VatPercent = worksheet.Cells[i, 7].Value.ToString(); loc.AmountOfVat = worksheet.Cells[i, 8].Value.ToString(); loc.TotalAmount = worksheet.Cells[i, 9].Value.ToString(); bills.Add(loc); } } } }
protected void btnemployeeOrdersubmit_click(object sender, EventArgs e) { if (dpEmployee.SelectedItem.Value != "0") { int result = 0; Invoice inovice = new Invoice(); InvoiceData invoiceData = new InvoiceData(); inovice.orderDate = (Convert.ToDateTime(txtEmployeeOrderDate.Text)).ToString("dd-MM-yyyy"); inovice.AgencyID = 0; inovice.ShecemeApplied = true; //salesEmployee DataSet ds = new DataSet(); BillData billData = new BillData(); ds = billData.getEmployeeByUserId(GlobalInfo.Userid); inovice.SaleEmployeeId = string.IsNullOrEmpty(ds.Tables[0].Rows[0]["EmployeeID"].ToString()) ? 0 : Convert.ToInt32(ds.Tables[0].Rows[0]["EmployeeID"]); inovice.EmployeeID = Convert.ToInt32(dpEmployee.SelectedItem.Value); inovice.totalCoast = string.IsNullOrEmpty(hfemployeeTotalBill.Value) ? 0 : Comman.Comman.IsValidInteger(hfemployeeTotalBill.Value) ? Convert.ToDouble(hfemployeeTotalBill.Value) : 0; inovice.CreatedBy = GlobalInfo.Userid; inovice.CreatedDate = DateTime.Now.ToString("dd/MM/yyyy"); inovice.TokanId = hftokanno.Value; inovice.orderType = 2;// employeeORder inovice.CurrentBoothID = GlobalInfo.CurrentbothID; inovice.PaymentMode = "Employee"; DataSet chkds = new DataSet(); chkds = invoiceData.CheckBoothTemp(inovice, 1); if (!Comman.Comman.IsDataSetEmpty(chkds)) { result = invoiceData.BoothInserOrder(inovice); } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Please Add Items')", true); } if (result > 0) { //ScriptManager.RegisterStartupScript(pnlBill2, pnlBill2.GetType(), "PrintPanel2", "PrintPanel2()", true)) updateStock(); btnPrintEmp.Visible = true; Button1.Visible = false; btnAddEmployeeOrderItem.Visible = false; btnEmployeeNewOrder.Visible = false; btnRemoveOrder.Visible = false; pnlBill2.Visible = false; pnlBills.Visible = true; divDanger.Visible = false; divwarning.Visible = false; divSusccess.Visible = true; pnlError.Update(); upMain.Update(); pnlBill2.Enabled = false; } else { divDanger.Visible = false; divwarning.Visible = true; divSusccess.Visible = false; lblwarning.Text = "Please Contact to Site Admin"; pnlError.Update(); } } else { // ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Please Select Employee')", true); } }