private void button1_Click(object sender, EventArgs e) { if (Datalayer.ShowQuestMsg("Are you sure? Do you want to Send SMS? ")) { int iSend = 0, iNotSend = 0; for (int i = 0; i < dgDisplayData.Rows.Count; i++) { if (Convert.ToString(dgDisplayData.Rows[i].Cells[0].Value) == "True") { string sMobileNo = dgDisplayData.Rows[i].Cells["MobileNo"].Value.ToString(); string sMSG = dgDisplayData.Rows[i].Cells["Msg"].Value.ToString(); string SMSID = dgDisplayData.Rows[i].Cells["SMSID"].Value.ToString(); int iD = 0; int.TryParse(SMSID, out iD); bool IsSend = SendSMS(sMobileNo, sMSG); if (IsSend) { iSend = iSend + 1; } else { iNotSend = iNotSend + 1; } int?Iout = 0; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_ADDSMS(iD, DateTime.Now, sMobileNo, sMSG, IsSend, Datalayer.iT001_COMPANYID, ref Iout); } } Datalayer.InformationMessageBox("SMS Send successfully."); } }
void PopualteData() { DAL dl = new DAL(); DataTable dt = new DataTable(); dt = dl.SelectMethod("exec USP_VP_GET_STOCK_REPORT '" + dtpFromDate.Value.ToString("yyyy-MM-dd") + "','" + dtpTodate.Value.ToString("yyyy-MM-dd") + "','" + Datalayer.iT001_COMPANYID + "' "); if (dt.Rows.Count > 0) { DataView db = dt.DefaultView; db.Sort = "T007_DATE ASC"; DataTable sort = db.ToTable(); ReportDocument RptDoc = new ReportDocument(); RptDoc.Load(Application.StartupPath + @"\Report\rptStockReportListing.rpt"); RptDoc.SetDataSource(sort); Datalayer.RptReport = RptDoc; Datalayer.sReportName = "GST Report"; Report.frmReportViwer fmReport = new Report.frmReportViwer(); fmReport.Show(); } else { Datalayer.InformationMessageBox("No Record.."); } }
void PrintData() { int ID = 0; int.TryParse(dgDisplayData.CurrentRow.Cells["T010_PACKINGSLIPID"].Value.ToString(), out ID); DAL dl = new DAL(); DataTable dt = new DataTable(); dt = dl.SelectMethod("exec USP_VP_GET_PRINT_PACKING_SLIP_ONID '" + ID + "'"); if (dt.Rows.Count > 0) { ReportDocument RptDoc = new ReportDocument(); RptDoc.Load(Application.StartupPath + @"\Report\rptPackingSlip.rpt"); RptDoc.SetDataSource(dt); Datalayer.RptReport = RptDoc; Datalayer.sReportName = "Packing Slip Bill"; Report.frmReportViwer fmReport = new Report.frmReportViwer(); fmReport.Show(); } else { Datalayer.InformationMessageBox("No Record.."); } }
void PopualteData() { string sType = ""; if (!string.IsNullOrEmpty(cmbType.Text.Trim())) { sType = Convert.ToString(cmbType.Text.Trim()); } DAL dl = new DAL(); DataTable dt = new DataTable(); dt = dl.SelectMethod("exec USP_VP_GET_ACCOUNT '','" + txtName.Text.Trim() + "','','" + sType + "' ,'" + txtCity.Text.Trim() + "','" + txtMobileNo.Text.Trim() + "','" + Datalayer.iT001_COMPANYID + "' "); if (dt.Rows.Count > 0) { ReportDocument RptDoc = new ReportDocument(); RptDoc.Load(Application.StartupPath + @"\Report\rptAccount.rpt"); RptDoc.SetDataSource(dt); Datalayer.RptReport = RptDoc; Datalayer.sReportName = "Account Listing Report"; Report.frmReportViwer fmReport = new Report.frmReportViwer(); fmReport.Show(); } else { Datalayer.InformationMessageBox("No Record.."); } }
void CheckUser() { try { ep1.Clear(); if (string.IsNullOrEmpty(txtUserPassword.Text.Trim())) { ep1.SetError(txtUserPassword, "Password is required.."); txtUserPassword.Focus(); return; } DateTime myDateTime = DateTime.Now; DateTime checkDate1 = DateTime.Parse("2018-05-05"); DateTime checkDate2 = DateTime.Parse("2018-08-25"); //if ((myDateTime >= checkDate1 && myDateTime <= checkDate2) == false) //{ // Datalayer.InformationMessageBox("Demo is expried."); // return; //} MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); var list = (from TL01_USER in MyDa.GetTable <TL01_USER>() where TL01_USER.TL01_PASSWORD == txtUserPassword.Text.Trim() select TL01_USER).ToList(); if (list.Count > 0 && list != null) { //if (DateTime.Now.Month >= 3) //{ // Datalayer.InformationMessageBox("Your Demo is Expire. Please contact to admin."); // this.Close(); //} //if (DateTime.Now.Month <= 2) //{ // Datalayer.InformationMessageBox("Your Demo is Expire. Please contact to admin."); // this.Close(); //} Datalayer.iTL01_USERID = list[0].TL01_USERID; Datalayer.UserType = list[0].TL01_ROLE.ToString(); frmCompanySelection fmMain = new frmCompanySelection(); fmMain.Show(); this.Hide(); // } } else { Datalayer.InformationMessageBox("User name or Password is wrong. please try agin.."); txtUserPassword.Text = ""; txtUserPassword.Focus(); } } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void PrintData() { if (dgDisplayData.SelectedRows.Count > 0) { int ID = 0; int.TryParse(dgDisplayData.CurrentRow.Cells["T012_CHALLENID"].Value.ToString(), out ID); Datalayer.iPrintableChallenId = ID; DAL dl = new DAL(); DataTable dt = new DataTable(); dt = dl.SelectMethod("exec USP_VP_PRINT_CHALLEN_BILL '" + Datalayer.iPrintableChallenId + "'"); if (dt.Rows.Count > 0) { dt.Rows[0]["BILLTYPE"] = "Orignal"; ReportDocument RptDoc = new ReportDocument(); RptDoc.Load(Application.StartupPath + @"\Report\rptChallen.rpt"); RptDoc.SetDataSource(dt); Datalayer.RptReport = RptDoc; Datalayer.sReportName = "Challen Bill"; Report.frmReportViwer fmReport = new Report.frmReportViwer(); fmReport.Show(); } else { Datalayer.InformationMessageBox("No Record.."); } //frmPrintBill fmPrnt = new frmPrintBill(); //fmPrnt.Show(); } }
private void btnPackingSlip_Click(object sender, EventArgs e) { if (dgDisplayData.SelectedRows.Count > 0) { int ID = 0; int.TryParse(dgDisplayData.CurrentRow.Cells["T012_CHALLENID"].Value.ToString(), out ID); DAL dl = new DAL(); DataTable dt = new DataTable(); dt = dl.SelectMethod("exec USP_VP_PRINT_CHALLEN_BILL '" + ID + "'"); if (dt.Rows.Count > 0) { ReportDocument RptDoc = new ReportDocument(); RptDoc.Load(Application.StartupPath + @"\Report\rptPackingSlipsOnInvoice.rpt"); RptDoc.SetDataSource(dt); Datalayer.RptReport = RptDoc; Datalayer.sReportName = "Packing Slip"; Report.frmReportViwer fmReport = new Report.frmReportViwer(); fmReport.Show(); } else { Datalayer.InformationMessageBox("No Record.."); } } }
void PopualteData() { string TM02_PARTYID = ""; int iTM02_PARTYID = 0; if (!string.IsNullOrEmpty(cmbName.Text.Trim())) int.TryParse(cmbName.SelectedValue.ToString(), out iTM02_PARTYID); if (iTM02_PARTYID > 0) TM02_PARTYID = iTM02_PARTYID.ToString(); DAL dl = new DAL(); DataTable dt = new DataTable(); dt = dl.SelectMethod("exec USP_VP_GET_STOCK_IN_REPORT '" + TM02_PARTYID + "','" + dtpFromDate.Value.ToString("yyyy-MM-dd") + "','" + dtpTodate.Value.ToString("yyyy-MM-dd") + "','" + Datalayer.iT001_COMPANYID + "' "); if (dt.Rows.Count > 0) { ReportDocument RptDoc = new ReportDocument(); RptDoc.Load(Application.StartupPath + @"\Report\rptStockInListing.rpt"); RptDoc.SetDataSource(dt); Datalayer.RptReport = RptDoc; Datalayer.sReportName = "Stock In Listing Report"; Report.frmReportViwer fmReport = new Report.frmReportViwer(); fmReport.Show(); } else { Datalayer.InformationMessageBox("No Record.."); } }
void ResetPassword() { try { ep1.Clear(); if (string.IsNullOrEmpty(cmbUserName.Text.Trim())) { ep1.SetError(cmbUserName, "User Name is required."); cmbUserName.Focus(); return; } if (string.IsNullOrEmpty(txtResetPassword.Text.Trim())) { ep1.SetError(txtResetPassword, "Reset password is required."); txtResetPassword.Focus(); return; } db = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); TL01_USER tblUser = db.TL01_USERs.Single(TL01_USER => TL01_USER.TL01_USERID.ToString() == cmbUserName.SelectedValue.ToString()); tblUser.TL01_PASSWORD = txtResetPassword.Text.Trim(); db.SubmitChanges(); cmbUserName.SelectedIndex = 0; txtResetPassword.Text = ""; Datalayer.InformationMessageBox("Password reset sucesfully."); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
public bool SendSMS(string sMobileNumber, string sMsg) { // sMobileNumber = "9374045413"; string result = ""; WebRequest request = null; HttpWebResponse response = null; bool bSMSsent = false; try { if (CheckForInternetConnection()) { string url = "http://login.arihantsms.com/vendorsms/pushsms.aspx?user=PENAMT&password=PENAMT&msisdn=91" + sMobileNumber.Trim() + "&sid=PENAMT&msg=" + sMsg.Trim() + "&fl=0&gwid=2"; request = WebRequest.Create(url); // Send the 'HttpWebRequest' and wait for response. response = (HttpWebResponse)request.GetResponse(); Stream stream = response.GetResponseStream(); Encoding ec = System.Text.Encoding.GetEncoding("utf-8"); StreamReader reader = new System.IO.StreamReader(stream, ec); result = reader.ReadToEnd(); int iT025_SMSLOGID_OUT = 0; bSMSsent = (result.ToLower().IndexOf("success") >= 0); //S reader.Close(); stream.Close(); } else { Datalayer.InformationMessageBox("Please check the internet connection.."); return(false); } } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } finally { if (response != null) { response.Close(); } } return(bSMSsent); }
void EditData() { if (dgDisplayData.SelectedRows.Count > 0) { int ID = 0; int.TryParse(dgDisplayData.CurrentRow.Cells["TM01_PRODUCTID"].Value.ToString(), out ID); Datalayer.iTM01_PRODUCTID = ID; PopauteEditData(); } else { Datalayer.InformationMessageBox(Datalayer.sMeessgeSelection); } }
void AddUser() { try { ep1.Clear(); if (string.IsNullOrEmpty(txtOldPassword.Text.Trim())) { ep1.SetError(txtOldPassword, "Old Password is requied."); txtOldPassword.Focus(); return; } if (string.IsNullOrEmpty(txtPassword.Text.Trim())) { ep1.SetError(txtPassword, "Password is requied."); txtPassword.Focus(); return; } db = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); var lst = (from u in db.TL01_USERs select u).Where(s => s.TL01_USERID == Datalayer.iTL01_USERID).ToList(); if (lst != null && lst.Count > 0) { if (lst[0].TL01_PASSWORD.ToString() != txtOldPassword.Text.Trim()) { Datalayer.InformationMessageBox("Old password is not correct.."); txtOldPassword.Focus(); return; } } db = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); TL01_USER tlUser = new TL01_USER(); tlUser.TL01_PASSWORD = txtPassword.Text.Trim(); tlUser.TL01_ROLE = "User"; db.TL01_USERs.InsertOnSubmit(tlUser); db.SubmitChanges(); txtPassword.Text = ""; txtPassword.Focus(); Datalayer.InsertMessageBox(sPageName); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
private void btnAdd_Click(object sender, EventArgs e) { if (dgDisplayData.Rows.Count == 0) { Datalayer.InformationMessageBox("Please select customer "); return; } if (Datalayer.ShowQuestMsg("Are you sure? Do you want to Send SMS? ")) { int iSend = 0, iNotSend = 0; for (int i = 0; i < dgDisplayData.Rows.Count; i++) { if (Convert.ToString(dgDisplayData.Rows[i].Cells[0].Value) == "True") { string sMobileNo = dgDisplayData.Rows[i].Cells["T001_MOBILE1"].Value.ToString(); string sName = dgDisplayData.Rows[i].Cells["T001_NAME"].Value.ToString(); string sAmount = dgDisplayData.Rows[i].Cells["TOTALPENDING"].Value.ToString(); string sCompanyName = dgDisplayData.Rows[i].Cells["TM_NAME"].Value.ToString(); string sPhoneNo = dgDisplayData.Rows[i].Cells["TM_PHONENO"].Value.ToString(); string sMSG = "Dear, " + sName + " your pending amount payable to " + sCompanyName + " is Rs." + sAmount + " and it is now overdue. Please Contact us on " + sPhoneNo + " urgently to discuss our policy."; bool IsSend = SendSMS(sMobileNo, sMSG); if (IsSend) { iSend = iSend + 1; } else { iNotSend = iNotSend + 1; } int?Iout = 0; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_ADDSMS(0, DateTime.Now, sMobileNo, sMSG, IsSend, Datalayer.iT001_COMPANYID, ref Iout); } } Datalayer.InformationMessageBox("SMS Send successfully."); lblTotalSend.Text = "Total Send SMS:" + iSend.ToString(); lblNotSend.Text = "Total Not Send SMS:" + iNotSend.ToString(); } }
void Filldata() { if (dgDisplayData.SelectedRows.Count > 0) { int iTL01_SCHOOLID = 0; int.TryParse(dgDisplayData.CurrentRow.Cells["TM_COMPAYID"].Value.ToString(), out iTL01_SCHOOLID); Datalayer.iT001_COMPANYID = iTL01_SCHOOLID; MDIMaster fmMain = new MDIMaster(); fmMain.Show(); this.Hide(); } else { Datalayer.InformationMessageBox(Datalayer.sMeessgeSelection); } }
void PopualteData() { int iPartyID = 0, TM02_MAIN_PRODUCTSIZEID = 0; string sPartyID = "", sTM02_MAIN_PRODUCTSIZEID = ""; if (!string.IsNullOrEmpty(cmbName.Text.Trim())) { int.TryParse(cmbName.SelectedValue.ToString(), out iPartyID); } //if (!string.IsNullOrEmpty(cmbMainItemSize.Text.Trim())) // int.TryParse(cmbMainItemSize.SelectedValue.ToString(), out TM02_MAIN_PRODUCTSIZEID); if (iPartyID > 0) { sPartyID = iPartyID.ToString(); } if (TM02_MAIN_PRODUCTSIZEID > 0) { sTM02_MAIN_PRODUCTSIZEID = TM02_MAIN_PRODUCTSIZEID.ToString(); } DAL dl = new DAL(); DataTable dt = new DataTable(); dt = dl.SelectMethod("exec USP_VP_GET_STOCK '" + sPartyID + "','" + sTM02_MAIN_PRODUCTSIZEID + "','" + Datalayer.iT001_COMPANYID + "' "); if (dt.Rows.Count > 0) { ReportDocument RptDoc = new ReportDocument(); RptDoc.Load(Application.StartupPath + @"\Report\rptStock.rpt"); RptDoc.SetDataSource(dt); Datalayer.RptReport = RptDoc; Datalayer.sReportName = "Stock Listing Report"; Report.frmReportViwer fmReport = new Report.frmReportViwer(); fmReport.Show(); } else { Datalayer.InformationMessageBox("No Record.."); } }
void EditData() { if (dgDisplayData.SelectedRows.Count > 0) { int ID = 0; int.TryParse(dgDisplayData.CurrentRow.Cells["TM03_PRODUCTITEMID"].Value.ToString(), out ID); Datalayer.iTM03_PRODUCTITEMID = ID; frmAddUpdateProductItem frmAddSTD = new frmAddUpdateProductItem(); frmAddSTD.MdiParent = this.MdiParent; frmAddSTD.Show(); this.Close(); } else { Datalayer.InformationMessageBox(Datalayer.sMeessgeSelection); } }
void EditData() { if (dgDisplayData.SelectedRows.Count > 0) { int ID = 0; int.TryParse(dgDisplayData.CurrentRow.Cells["T013_EXPENSETRANSACATIONID"].Value.ToString(), out ID); Datalayer.iT013_EXPENSETRANSACATIONID = ID; frmAddUpdateExpenseTransaction frmAddSTD = new frmAddUpdateExpenseTransaction(); frmAddSTD.MdiParent = this.MdiParent; frmAddSTD.Show(); this.Close(); } else { Datalayer.InformationMessageBox(Datalayer.sMeessgeSelection); } }
void EditData() { if (dgDisplayData.SelectedRows.Count > 0) { int ID = 0; int.TryParse(dgDisplayData.CurrentRow.Cells["T001_ACCOUNTID"].Value.ToString(), out ID); Datalayer.iT001_ACCOUNTID = ID; frmAddUpdateAccount frmAddSTD = new frmAddUpdateAccount(); frmAddSTD.MdiParent = this.MdiParent; frmAddSTD.Show(); this.Close(); } else { Datalayer.InformationMessageBox(Datalayer.sMeessgeSelection); } }
void EditData() { if (dgDisplayData.SelectedRows.Count > 0) { int ID = 0; int.TryParse(dgDisplayData.CurrentRow.Cells["T007_STOCKINMASTERID"].Value.ToString(), out ID); Datalayer.iT005_STOCKINID = ID; frmStockIn frmAddSTD = new frmStockIn(); frmAddSTD.MdiParent = this.MdiParent; frmAddSTD.Show(); this.Close(); } else { Datalayer.InformationMessageBox(Datalayer.sMeessgeSelection); } }
void EditData() { if (dgDisplayData.SelectedRows.Count > 0) { int ID = 0; int.TryParse(dgDisplayData.CurrentRow.Cells["T010_PACKINGSLIPID"].Value.ToString(), out ID); Datalayer.T010_PACKINGSLIPID = ID; frmPackingSlip frmAddSTD = new frmPackingSlip(); frmAddSTD.MdiParent = this.MdiParent; frmAddSTD.Show(); this.Close(); } else { Datalayer.InformationMessageBox(Datalayer.sMeessgeSelection); } }
void DelelteData() { if (dgDisplayData.SelectedRows.Count > 0) { if (Datalayer.ShowQuestMsg(Datalayer.sMessageConfirmation)) { try { int ID = 0; int.TryParse(dgDisplayData.CurrentRow.Cells["T007_SALEID"].Value.ToString(), out ID); int?Iout = 0; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_DELETE_SALEITEM(ID, ref Iout); MyDa.USP_VP_DELETE_SALE(ID, ref Iout); if (Iout > 0) { Datalayer.DeleteMessageBox("Sale Details"); PopualteData(); } else { Datalayer.DosenotDeleteMessageBox("Sale Details"); } } catch (Exception) { Datalayer.InformationMessageBox(Datalayer.sMessageForainKey); return; } } } else { Datalayer.InformationMessageBox(Datalayer.sMeessgeSelection); } }
void DelelteData() { if (dgDisplayData.SelectedRows.Count > 0) { if (Datalayer.ShowQuestMsg(Datalayer.sMessageConfirmation)) { try { int ID = 0; int.TryParse(dgDisplayData.CurrentRow.Cells["T010_PACKINGSLIPID"].Value.ToString(), out ID); int?Iout = 0; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_DELETE_ALL_PACKINGSLIPORDER(ID, ref Iout); string sQuery = "DELETE FROM T010_PACKINGSLIP WHERE T010_PACKINGSLIPID=" + ID; DAL dl = new DAL(); if (dl.ExecuteMethod(sQuery)) { Datalayer.DeleteMessageBox("Packing Slip Details"); PopualteData(); } else { Datalayer.DosenotDeleteMessageBox("Packing Slip Details"); } } catch (Exception) { Datalayer.InformationMessageBox(Datalayer.sMessageForainKey); return; } } } else { Datalayer.InformationMessageBox(Datalayer.sMeessgeSelection); } }
void DelelteData() { if (dgDisplayData.SelectedRows.Count > 0) { if (Datalayer.ShowQuestMsg(Datalayer.sMessageConfirmation)) { try { int ID = 0; int.TryParse(dgDisplayData.CurrentRow.Cells["T009_PAYMENTID"].Value.ToString(), out ID); int?Iout = 0; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); string Sq = "DELETE FROM T009_PAYMENT WHERE T009_PAYMENTID=" + ID; DAL dl = new DAL(); if (dl.ExecuteMethod(Sq)) { PopualteData(); } else { Datalayer.DosenotDeleteMessageBox("Payment Details"); } } catch (Exception) { Datalayer.InformationMessageBox(Datalayer.sMessageForainKey); return; } } } else { Datalayer.InformationMessageBox(Datalayer.sMeessgeSelection); } }
private void productListingToolStripMenuItem_Click(object sender, EventArgs e) { DAL dl = new DAL(); DataTable dt = new DataTable(); dt = dl.SelectMethod("exec USP_VP_RPT_GETPRODUCT '" + Datalayer.iT001_COMPANYID.ToString() + "' "); if (dt.Rows.Count > 0) { ReportDocument RptDoc = new ReportDocument(); RptDoc.Load(Application.StartupPath + @"\Report\rptProduct.rpt"); RptDoc.SetDataSource(dt); Datalayer.RptReport = RptDoc; Datalayer.sReportName = "Product Listing Report"; Report.frmReportViwer fmReport = new Report.frmReportViwer(); fmReport.Show(); } else { Datalayer.InformationMessageBox("No Record.."); } }
void PopualteData() { DAL dl = new DAL(); DataTable dt = new DataTable(); dt = dl.SelectMethod("exec USP_RP_PRODUCTION_REPORT_WITH_GROUP '','" + dtpFromDate.Value.ToString("yyyy-MM-dd") + "','" + dtpTodate.Value.ToString("yyyy-MM-dd") + "','" + Datalayer.iT001_COMPANYID + "' "); if (dt.Rows.Count > 0) { ReportDocument RptDoc = new ReportDocument(); RptDoc.Load(Application.StartupPath + @"\Report\rptProduction.rpt"); RptDoc.SetDataSource(dt); Datalayer.RptReport = RptDoc; Datalayer.sReportName = "Production Report"; Report.frmReportViwer fmReport = new Report.frmReportViwer(); fmReport.Show(); } else { Datalayer.InformationMessageBox("No Record.."); } }
void PrintData() { int ID = 0; int.TryParse(dgDisplayData.CurrentRow.Cells["T007_SALEID"].Value.ToString(), out ID); DAL dl = new DAL(); DataTable dt = new DataTable(); dt = dl.SelectMethod("exec USP_VP_PRINT_SALE_BILL '" + ID + "'"); if (dt.Rows.Count > 0) { //DataTable dtQTY = new DataTable(); //dtQTY = dl.SelectMethod("SELECT TM01_HSNCODE,SUM(T008_QTY)AS QTY FROM T008_SALEITEM T008 INNER JOIN TM01_PRODUCT TM01 ON TM01.TM01_PRODUCTID = T008.TM01_PRODUCTID WHERE T007_SALEID=" + Datalayer.iPrintableBillId + " GROUP BY TM01.TM01_HSNCODE "); //if (dtQTY.Rows.Count > 0) //{ // for (int i = 0; i < dt.Rows.Count; i++) // { // if (dtQTY.Rows.Count == 1) // { // dt.Rows[i]["HSNCODE1"] = dtQTY.Rows[0][0].ToString(); // dt.Rows[i]["HSNCODEQTY1"] = dtQTY.Rows[0][1].ToString(); // } // if (dtQTY.Rows.Count == 2) // { // dt.Rows[i]["HSNCODE1"] = dtQTY.Rows[0][0].ToString(); // dt.Rows[i]["HSNCODEQTY1"] = dtQTY.Rows[0][1].ToString(); // dt.Rows[i]["HSNCODE2"] = dtQTY.Rows[1][0].ToString(); // dt.Rows[i]["HSNCODEQTY2"] = dtQTY.Rows[1][1].ToString(); // } // if (dtQTY.Rows.Count == 3) // { // dt.Rows[i]["HSNCODE1"] = dtQTY.Rows[0][0].ToString(); // dt.Rows[i]["HSNCODEQTY1"] = dtQTY.Rows[0][1].ToString(); // dt.Rows[i]["HSNCODE2"] = dtQTY.Rows[1][0].ToString(); // dt.Rows[i]["HSNCODEQTY2"] = dtQTY.Rows[1][1].ToString(); // dt.Rows[i]["HSNCODE2"] = dtQTY.Rows[2][0].ToString(); // dt.Rows[i]["HSNCODEQTY2"] = dtQTY.Rows[2][1].ToString(); // } // } //} ReportDocument RptDoc = new ReportDocument(); RptDoc.Load(Application.StartupPath + @"\Report\rptInvoice.rpt"); //RptDoc.Load(Application.StartupPath + @"\Report\rptInvoice.rpt"); RptDoc.SetDataSource(dt); Datalayer.RptReport = RptDoc; Datalayer.sReportName = "Invoice Bill"; Report.frmReportViwer fmReport = new Report.frmReportViwer(); fmReport.Show(); } else { Datalayer.InformationMessageBox("No Record.."); } }
void PrintReport(int no) { if (Datalayer.iPrintableBillId > 0) { DAL dl = new DAL(); DataTable dt = new DataTable(); dt = dl.SelectMethod("exec USP_VP_PRINT_SALE_BILL '" + Datalayer.iPrintableBillId + "'"); if (dt.Rows.Count > 0) { DataTable dtQTY = new DataTable(); dtQTY = dl.SelectMethod("SELECT TM01_HSNCODE,SUM(T008_QTY)AS QTY FROM T008_SALEITEM T008 INNER JOIN TM01_PRODUCT TM01 ON TM01.TM01_PRODUCTID = T008.TM01_PRODUCTID WHERE T007_SALEID=" + Datalayer.iPrintableBillId + " GROUP BY TM01.TM01_HSNCODE "); if (dtQTY.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { if (dtQTY.Rows.Count == 1) { dt.Rows[i]["HSNCODE1"] = dtQTY.Rows[0][0].ToString(); dt.Rows[i]["HSNCODEQTY1"] = dtQTY.Rows[0][1].ToString(); } if (dtQTY.Rows.Count == 2) { dt.Rows[i]["HSNCODE1"] = dtQTY.Rows[0][0].ToString(); dt.Rows[i]["HSNCODEQTY1"] = dtQTY.Rows[0][1].ToString(); dt.Rows[i]["HSNCODE2"] = dtQTY.Rows[1][0].ToString(); dt.Rows[i]["HSNCODEQTY2"] = dtQTY.Rows[1][1].ToString(); } if (dtQTY.Rows.Count == 3) { dt.Rows[i]["HSNCODE1"] = dtQTY.Rows[0][0].ToString(); dt.Rows[i]["HSNCODEQTY1"] = dtQTY.Rows[0][1].ToString(); dt.Rows[i]["HSNCODE2"] = dtQTY.Rows[1][0].ToString(); dt.Rows[i]["HSNCODEQTY2"] = dtQTY.Rows[1][1].ToString(); dt.Rows[i]["HSNCODE2"] = dtQTY.Rows[2][0].ToString(); dt.Rows[i]["HSNCODEQTY2"] = dtQTY.Rows[2][1].ToString(); } } } if (no == 1) { dt.Rows[0]["BILLTYPE"] = "ORIGNAL"; } else if (no == 2) { dt.Rows[0]["BILLTYPE"] = "DUPLICATE"; } else if (no == 3) { dt.Rows[0]["BILLTYPE"] = "TRIPLICATE"; } ReportDocument RptDoc = new ReportDocument(); if (dt.Rows[0]["TM_STATEID"].ToString() != "24") { RptDoc.Load(Application.StartupPath + @"\Report\rptOutGujInvoice.rpt"); } else { RptDoc.Load(Application.StartupPath + @"\Report\rptGujInvoice.rpt"); } //RptDoc.Load(Application.StartupPath + @"\Report\rptInvoice.rpt"); RptDoc.SetDataSource(dt); Datalayer.RptReport = RptDoc; Datalayer.sReportName = "Tax Invoice Bill"; Report.frmReportViwer fmReport = new Report.frmReportViwer(); fmReport.Show(); } else { Datalayer.InformationMessageBox("No Record.."); } } if (Datalayer.iPrintableChallenId > 0) { DAL dl = new DAL(); DataTable dt = new DataTable(); dt = dl.SelectMethod("exec USP_VP_PRINT_CHALLEN_BILL '" + Datalayer.iPrintableChallenId + "'"); if (dt.Rows.Count > 0) { if (no == 1) { dt.Rows[0]["BILLTYPE"] = "Orignal"; } else if (no == 2) { dt.Rows[0]["BILLTYPE"] = "Duplicate"; } else if (no == 3) { dt.Rows[0]["BILLTYPE"] = "Triplicate"; } ReportDocument RptDoc = new ReportDocument(); RptDoc.Load(Application.StartupPath + @"\Report\rptChallen.rpt"); RptDoc.SetDataSource(dt); Datalayer.RptReport = RptDoc; Datalayer.sReportName = "Challen Bill"; Report.frmReportViwer fmReport = new Report.frmReportViwer(); fmReport.Show(); } else { Datalayer.InformationMessageBox("No Record.."); } } }
void PopulateItems() { string sItemNo = txtItemNo.Text.Trim(); int iTM01_PRODUCTID = 0; if (!string.IsNullOrEmpty(cmbItemName.Text.Trim())) { int.TryParse(cmbItemName.SelectedValue.ToString(), out iTM01_PRODUCTID); if (iTM01_PRODUCTID > 0) { MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); List <USP_VP_GET_PRODUCT_FOR_CHALLEN_ON_IDResult> lst = new List <USP_VP_GET_PRODUCT_FOR_CHALLEN_ON_IDResult>(); lst = MyDa.USP_VP_GET_PRODUCT_FOR_CHALLEN_ON_ID(iTM01_PRODUCTID.ToString()).ToList(); if (lst != null && lst.Count > 0) { dgItems.DataSource = lst; //lblItemName.Text = lst[0].TM01_NAME.ToString(); dgItems.Columns["TM01_NAME"].Visible = false; dgItems.Columns["TM01_TAX_RATE"].Visible = false; dgItems.Columns["T006_STOCK"].HeaderText = "Stock"; dgItems.Columns["TM01_NAME"].HeaderText = "Item"; dgItems.Columns["TM02_SIZE"].HeaderText = "Finish"; dgItems.Columns["TM02_PRICE"].HeaderText = "Price"; dgItems.Columns["QTY"].HeaderText = "Qty"; dgItems.Columns["TM02_SIZE"].DisplayIndex = 1; dgItems.Columns["T006_STOCK"].DisplayIndex = 2; dgItems.Columns["TM02_PRICE"].DisplayIndex = 3; dgItems.Columns["QTY"].DisplayIndex = 4; dgItems.Columns["TM02_SIZE"].ReadOnly = true; dgItems.Columns["T006_STOCK"].ReadOnly = true; dgItems.Columns["TM01_PRODUCTID"].Visible = false; dgItems.Columns["TM02_PRODUCTSIZEID"].Visible = false; this.dgItems.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgItems.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(Datalayer.sGridHeaderColor1, Datalayer.sGridHeaderColor2, Datalayer.sGridHeaderColor3); dgItems.EnableHeadersVisualStyles = false; this.dgItems.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft; dgItems.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing; dgItems.ColumnHeadersHeight = 30; dgItems.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("Tahoma", 12F, FontStyle.Bold, GraphicsUnit.Pixel); dgItems.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; dgItems.Columns["TM01_NAME"].Width = 350; dgItems.Columns["TM02_SIZE"].Width = 120; dgItems.Columns["T006_STOCK"].Width = 120; dgItems.Columns["QTY"].Width = 150; } else { cmbItemName.Text = ""; Datalayer.InformationMessageBox(sItemNo + " not exist"); } } else { dgItems.DataSource = null; } } else { dgItems.DataSource = null; } }
void AddUpdatePurchase(bool IsPrint, bool IsPackingSlip) { try { ep1.Clear(); if (string.IsNullOrEmpty(cmbName.Text.Trim())) { ep1.SetError(cmbName, "This field is required."); cmbName.Focus(); return; } if (string.IsNullOrEmpty(txtNetAmount.Text.Trim())) { ep1.SetError(txtNetAmount, "This field is required."); txtNetAmount.Focus(); return; } int T007_SALEID = Datalayer.iT012_CHALLENID; // int TM01_CUSTOMERID = 0; string T007_NO = "", T007_DETAILS = ""; int T001_ACCOUNTID = 0; decimal T007_TOTAL_AMT = 0, T007_DISCOUNT = 0, T007_TAX1RATE = 0, T007_TAX1AMOUNT = 0, T007_TAX2RATE = 0, T007_TAX2AMOUNT = 0, T007_NETAMOUNT = 0, T007_TAX; DateTime T003_DATE = dtpDate.Value; // int.TryParse(cmbCustomerName.SelectedValue.ToString(), out TM01_CUSTOMERID); T007_NO = txtBillNo.Text.Trim(); int.TryParse(cmbName.SelectedValue.ToString(), out T001_ACCOUNTID); decimal.TryParse(txtTotalAmt.Text.Trim(), out T007_TOTAL_AMT); decimal.TryParse(txtDiscount.Text.Trim(), out T007_DISCOUNT); decimal.TryParse(txtTotalTaxAmount.Text.Trim(), out T007_TAX); decimal.TryParse(txtNetAmount.Text.Trim(), out T007_NETAMOUNT); T007_DETAILS = txtDetails.Text.Trim(); if (T007_SALEID > 0) { int?Iout = 0; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_DELETE_CHALLENITEM(T007_SALEID, ref Iout); //MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); //string sSql = "DELETE FROM T003_PURCHASEITEM WHERE T002_PURCHASEID =" + T007_SALEID; //dl.ExecuteMethod(sSql); } decimal dT007_PACKING = 0, dT007_FREIGHT = 0, dT007_OTHER_EXPENSE = 0; decimal.TryParse(txtPacking.Text.Trim(), out dT007_PACKING); decimal.TryParse(txtFreight.Text.Trim(), out dT007_FREIGHT); decimal.TryParse(txtExpense.Text.Trim(), out dT007_OTHER_EXPENSE); int?T007_SALEID_out = 0; Cursor.Current = Cursors.WaitCursor; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_ADDUPATE_CHALLEN(T007_SALEID, T001_ACCOUNTID, T007_NO, T003_DATE, txtTransport1.Text.Trim(), txtLR1.Text.Trim(), txtTransport2.Text.Trim(), txtLR2.Text.Trim(), T007_TOTAL_AMT, dT007_PACKING, dT007_FREIGHT, dT007_OTHER_EXPENSE, T007_DISCOUNT, T007_TAX, T007_NETAMOUNT, T007_DETAILS, Datalayer.iT001_COMPANYID, ref T007_SALEID_out); if (T007_SALEID_out > 0) { T007_SALEID = int.Parse(T007_SALEID_out.Value.ToString()); int?T002_PURCHASEITEMID_OUT = 0; for (int i = 0; i < dgDisplayData.Rows.Count; i++) { if (!string.IsNullOrEmpty(Convert.ToString(dgDisplayData.Rows[i].Cells["TM01_NAME"].Value))) { int TM01_PRODUCTID = 0, TM02_PRODUCTSIZEID = 0, T008_QTY = 0; decimal T008_RATE = 0, T008_NET_AMOUNT = 0; int.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["TM01_PRODUCTID"].Value), out TM01_PRODUCTID); int.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["TM02_PRODUCTSIZEID"].Value), out TM02_PRODUCTSIZEID); int.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T008_QTY"].Value), out T008_QTY); decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T008_RATE"].Value), out T008_RATE); decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T008_NET_AMOUNT"].Value), out T008_NET_AMOUNT); decimal T008_TOTAL_AMT = 0, T008_DISCOUNT_PER = 0, T008_DISCOUNT_AMT = 0, T008_TAX_RATE = 0, T008_TAX_AMT = 0; decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T008_TOTAL_AMT"].Value), out T008_TOTAL_AMT); decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T008_DISCOUNT_PER"].Value), out T008_DISCOUNT_PER); decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T008_DISCOUNT_AMT"].Value), out T008_DISCOUNT_AMT); decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T008_TAX_RATE"].Value), out T008_TAX_RATE); decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T008_TAX_AMT"].Value), out T008_TAX_AMT); int?T008_SALEITEMID_Out = 0; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_ADDUPDATE_CHALLEN_ITEM(0, T007_SALEID, TM01_PRODUCTID, TM02_PRODUCTSIZEID, T008_QTY, T008_RATE, T008_TOTAL_AMT, T008_DISCOUNT_PER, T008_DISCOUNT_AMT, T008_TAX_RATE, T008_TAX_AMT, T008_NET_AMOUNT, Datalayer.iT001_COMPANYID, ref T008_SALEITEMID_Out); } } if (Datalayer.iT012_CHALLENID == 0) { Datalayer.InsertMessageBox(sPageName); ResteData(); if (IsPrint) { Datalayer.iPrintableChallenId = T007_SALEID; frmPrintBill fmPrnt = new frmPrintBill(); fmPrnt.Show(); } if (IsPackingSlip) { DAL dl = new DAL(); DataTable dt = new DataTable(); dt = dl.SelectMethod("exec USP_VP_PRINT_CHALLEN_BILL '" + T007_SALEID + "'"); if (dt.Rows.Count > 0) { ReportDocument RptDoc = new ReportDocument(); RptDoc.Load(Application.StartupPath + @"\Report\rptPackingSlipsOnInvoice.rpt"); RptDoc.SetDataSource(dt); crystalReportViewer1.ReportSource = RptDoc; crystalReportViewer1.Refresh(); crystalReportViewer1.PrintReport(); //Datalayer.RptReport = RptDoc; //Datalayer.sReportName = "Packing Slip"; //Report.frmReportViwer fmReport = new Report.frmReportViwer(); //fmReport.Show(); } else { Datalayer.InformationMessageBox("No Record.."); } } //DataTable dt = new DataTable(); //dt = dl.SelectMethod("exec USP_VP_GET_FULLSALEBILL '" + T003_SALEID + "'"); //if (dt.Rows.Count > 0) //{ // ReportDocument RptDoc = new ReportDocument(); // RptDoc.Load(Application.StartupPath + @"\Report\rptRetailInvoice.rpt"); // RptDoc.SetDataSource(dt); // Datalayer.RptReport = RptDoc; // Datalayer.sReportName = "Invoice"; // frmReportViewer fmReport = new frmReportViewer(); // fmReport.Show(); //} } else { Datalayer.UpdateMessageBox(sPageName); if (IsPrint) { Datalayer.iPrintableChallenId = T007_SALEID; frmPrintBill fmPrnt = new frmPrintBill(); fmPrnt.Show(); } if (IsPackingSlip) { DAL dl = new DAL(); DataTable dt = new DataTable(); dt = dl.SelectMethod("exec USP_VP_PRINT_CHALLEN_BILL '" + T007_SALEID + "'"); if (dt.Rows.Count > 0) { ReportDocument RptDoc = new ReportDocument(); RptDoc.Load(Application.StartupPath + @"\Report\rptPackingSlipsOnInvoice.rpt"); RptDoc.SetDataSource(dt); crystalReportViewer1.ReportSource = RptDoc; crystalReportViewer1.Refresh(); crystalReportViewer1.PrintReport(); //Datalayer.RptReport = RptDoc; //Datalayer.sReportName = "Packing Slip"; //Report.frmReportViwer fmReport = new Report.frmReportViwer(); //fmReport.Show(); } else { Datalayer.InformationMessageBox("No Record.."); } } } } else { if (Datalayer.iT012_CHALLENID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } return; } ResteData(); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void PopualteData() { string TM02_PARTYID = ""; int iTM02_PARTYID = 0; if (!string.IsNullOrEmpty(cmbName.Text.Trim())) { int.TryParse(cmbName.SelectedValue.ToString(), out iTM02_PARTYID); } if (iTM02_PARTYID > 0) { TM02_PARTYID = iTM02_PARTYID.ToString(); } DAL dl = new DAL(); DataTable dt = new DataTable(); dt = dl.SelectMethod("exec USP_VP_GET_PARTY_STATEMENT '" + TM02_PARTYID + "','" + dtpFromDate.Value.ToString("yyyy-MM-dd") + "','" + dtpTodate.Value.ToString("yyyy-MM-dd") + "','" + Datalayer.iT001_COMPANYID + "' "); if (dt.Rows.Count > 0) { var orderedRows = from row in dt.AsEnumerable() orderby row.Field <DateTime?>("Invoice_Date") select row; DataTable tblOrdered = orderedRows.CopyToDataTable(); decimal dBal = 0; decimal dTotalSale = 0, dTotalPayment = 0; for (int i = 0; i < tblOrdered.Rows.Count; i++) { decimal dSale_Amount = 0, Recive_Amount = 0; decimal.TryParse(tblOrdered.Rows[i]["Sale_Amount"].ToString(), out dSale_Amount); decimal.TryParse(tblOrdered.Rows[i]["Recive_Amount"].ToString(), out Recive_Amount); dSale_Amount = Math.Abs(dSale_Amount); dTotalSale = dTotalSale + Math.Abs(dSale_Amount); dTotalPayment = dTotalPayment + Math.Abs(Recive_Amount); dBal = dBal + dSale_Amount; dBal = dBal - Recive_Amount; //if (dSale_Amount > 0) //{ // if (dBal > 0) // dBal = dBal + dSale_Amount; // else // dBal = dBal - dSale_Amount; //} //else //{ // if (dBal > 0) // dBal = dBal - dSale_Amount; // else // dBal = dBal + dSale_Amount; //} //if (Recive_Amount > 0) //{ // if (dBal > 0) // dBal = dBal - Recive_Amount; // else // dBal = dBal + Recive_Amount; //} //if (dBal > 0) //{ // dBal = dBal + dSale_Amount; // dBal = dBal - Recive_Amount; //} //else //{ // dBal = dBal + dSale_Amount; // dBal = dBal - Recive_Amount; // dBal = (dBal * -1); //} tblOrdered.Rows[i]["FromDate"] = dtpFromDate.Value.ToString("dd-MM-yyyy"); tblOrdered.Rows[i]["ToDate"] = dtpTodate.Value.ToString("dd-MM-yyyy"); if (i == 0) { tblOrdered.Rows[i]["Sale_Amount"] = 0; } else { tblOrdered.Rows[i]["Sale_Amount"] = System.Math.Abs(dSale_Amount); } tblOrdered.Rows[i]["Balance"] = decimal.Round(dBal, 2); //tblOrdered.Rows[0]["T001_NAME"] = tblOrdered.Rows[1]["T001_NAME"].ToString(); } tblOrdered.Rows[dt.Rows.Count - 1]["TOTALSALE"] = dTotalSale; tblOrdered.Rows[dt.Rows.Count - 1]["TOTALPAYMENT"] = dTotalPayment; ReportDocument RptDoc = new ReportDocument(); RptDoc.Load(Application.StartupPath + @"\Report\rptPartyStatement.rpt"); RptDoc.SetDataSource(tblOrdered); Datalayer.RptReport = RptDoc; Datalayer.sReportName = "Account Statement Report"; Report.frmReportViwer fmReport = new Report.frmReportViwer(); fmReport.Show(); } else { Datalayer.InformationMessageBox("No Record.."); } }