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..");
}
}
