private void HelpGrid_DoubleClick(object sender, EventArgs e)
{
DataRow row = HelpGridView.GetDataRow(HelpGridView.FocusedRowHandle);
if (HelpGrid.Text == "txtAccCode")
{
txtAccCode.Text = row["AccCode"].ToString();
txtAccName.Text = row["AccName"].ToString();
HelpGrid.Visible = false;
txtAccCode.Focus();
}
if (HelpGrid.Text == "Load")
{
DataSet ds = ProjectFunctions.GetDataSet("sp_LoadEANData '" + row[0].ToString() + "'");
if (ds.Tables[0].Rows.Count > 0)
{
AddRowsToDatatable();
dt = ds.Tables[0];
InfoGrid.DataSource = dt;
InfoGridView.BestFitColumns();
HelpGrid.Visible = false;
}
else
{
InfoGrid.DataSource = null;
}
}
}
private void ApprovaLReturn_Load(object sender, EventArgs e)
{
try
{
ProjectFunctions.TextBoxVisualize(this);
ProjectFunctions.ToolStripVisualize(Menu_ToolStrip);
if (S1 == "&Add")
{
txtReturnDate.EditValue = DateTime.Now.ToString("dd-MM-yyyy");
txtCustMobileNo.Focus();
}
if (S1 == "Edit")
{
DataSet ds = ProjectFunctions.GetDataSet("[sp_LoadArticleApprovalMstFEdit] '" + ImDate.Date.ToString("yyyy-MM-dd") + "','" + ImNo + "','" + ImSeries + "','" + GlobalVariables.CUnitID + "'");
txtReturnDate.Text = Convert.ToDateTime(ds.Tables[0].Rows[0]["BillDate"]).ToString("yyyy-MM-dd");
txtReturnNo.Text = ds.Tables[0].Rows[0]["BillNo"].ToString();
txtCustMobileNo.Text = ds.Tables[0].Rows[0]["CAFMOBILE"].ToString();
txtCustCode.Text = ds.Tables[0].Rows[0]["CustCode"].ToString();
txtCustName.Text = ds.Tables[0].Rows[0]["CAFFNAME"].ToString();
txtCustDetails.Text = ds.Tables[0].Rows[0]["CAFADD"].ToString();
txtRemarks.Text = ds.Tables[0].Rows[0]["SIMRemarks"].ToString();
dt = ds.Tables[1];
InfoGrid.DataSource = dt;
InfoGridView.BestFitColumns();
txtCustMobileNo.Focus();
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message);
}
}
private void InfoGrid_DoubleClick(object sender, EventArgs e)
{
#pragma warning disable CS0618 // 'GridControl.KeyboardFocusView' is obsolete: 'Use the FocusedView property instead.'
var MaxRow = ((InfoGrid.KeyboardFocusView as GridView).RowCount);
#pragma warning restore CS0618 // 'GridControl.KeyboardFocusView' is obsolete: 'Use the FocusedView property instead.'
if (MaxRow == 0)
{
ProjectFunctions.SpeakError("Invalid Operation");
}
else
{
BtnOK.Text = "&Update";
rowindex = InfoGridView.FocusedRowHandle;
var row = InfoGridView.GetDataRow(InfoGridView.FocusedRowHandle);
txtDealerCode.Text = row["IdDealerCode"].ToString();
txtDealerName.Text = row["dealerName"].ToString();
txtPrdAsgnCode.Text = row["IdPrdAsgnCode"].ToString();
txtProductName.Text = row["PrdName"].ToString();
txtFor.Text = row["IdPrdQty"].ToString();
txtFree.Text = row["IdPrdQtyF"].ToString();
DtFrom.EditValue = Convert.ToDateTime(row["IdDtFrom"]);
DtTo.EditValue = Convert.ToDateTime(row["IdDtUpto"]);
txtPrdCode.Text = row["IdPrdCode"].ToString();
txtPrdAsgnCode.Focus();
}
}
private void InfoGrid_DoubleClick(object sender, EventArgs e)
{
var MaxRow = ((InfoGrid.FocusedView as GridView).RowCount);
if (MaxRow == 0)
{
ProjectFunctions.SpeakError("Invalid Operation");
}
else
{
BtnOK.Text = "&Update";
DataRow currentrow = InfoGridView.GetDataRow(InfoGridView.FocusedRowHandle);
TransID = currentrow["TransId"].ToString();
DataSet ds = ProjectFunctions.GetDataSet("sp_LoadDelAddress '" + TransID + "'");
if (ds.Tables[0].Rows.Count > 0)
{
txtDelAccName.Text = ds.Tables[0].Rows[0]["DelAccName"].ToString();
txtDelZipCode.Text = ds.Tables[0].Rows[0]["DelZipCode"].ToString();
txtDelAddress1.Text = ds.Tables[0].Rows[0]["AccAddress1"].ToString();
txtDelAddress2.Text = ds.Tables[0].Rows[0]["AccAddress2"].ToString();
txtDelAddress3.Text = ds.Tables[0].Rows[0]["AccAddress3"].ToString();
txtDelCitycode.Text = ds.Tables[0].Rows[0]["CityCode"].ToString();
txtDelCityName.Text = ds.Tables[0].Rows[0]["CTNAME"].ToString();
txtDelGSTNo.Text = ds.Tables[0].Rows[0]["AccGSTNo"].ToString();
txtDelAddress1.Focus();
}
}
}
private void BtnOK_Click(object sender, EventArgs e)
{
if (ValidateData())
{
if (BtnOK.Text.Trim().ToUpper() == "&OK")
{
DataRow NewRow = dt.NewRow();
NewRow["PrdCode"] = Convert.ToDecimal(txtPrdCode.Text);
NewRow["PrdAsgnCode"] = txtPrdAsgnCode.Text.Trim();
NewRow["PrdName"] = txtProductName.Text.Trim();
NewRow["Quantity"] = Convert.ToDecimal(txtQty.Text);
dt.Rows.Add(NewRow);
if (dt.Rows.Count > 0)
{
InfoGrid.DataSource = dt;
InfoGridView.BestFitColumns();
}
else
{
InfoGrid.DataSource = null;
}
BtnUndo.PerformClick();
}
if (BtnOK.Text.Trim().ToUpper() == "&UPDATE")
{
InfoGridView.SetRowCellValue(rowindex, InfoGridView.Columns["PrdCode"], Convert.ToDecimal(txtPrdCode.Text));
InfoGridView.SetRowCellValue(rowindex, InfoGridView.Columns["PrdAsgnCode"], txtPrdAsgnCode.Text.Trim());
InfoGridView.SetRowCellValue(rowindex, InfoGridView.Columns["PrdName"], txtProductName.Text.Trim());
InfoGridView.SetRowCellValue(rowindex, InfoGridView.Columns["Quantity"], Convert.ToDecimal(txtQty.Text));
InfoGridView.RefreshData();
BtnUndo.PerformClick();
}
}
}
private void FrmProformaMst_Load(object sender, EventArgs e)
{
SetMyControls();
if (S1 == "&Add")
{
txtPIDate.EditValue = DateTime.Now;
txtPINo.Text = GetNewInvoiceDocumentNo().PadLeft(6, '0');
}
if (S1 == "Edit")
{
txtPIDate.Enabled = false;
DataSet ds = ProjectFunctions.GetDataSet("sp_LoadPIMstFEDit '" + DocNo + "','" + Convert.ToDateTime(DocDate).ToString("yyyy-MM-dd") + "'");
if (ds.Tables[0].Rows.Count > 0)
{
txtPIDate.EditValue = Convert.ToDateTime(ds.Tables[0].Rows[0]["PIDate"]);
txtPINo.Text = ds.Tables[0].Rows[0]["PINo"].ToString();
txtAccCode.Text = ds.Tables[0].Rows[0]["PIPartyCode"].ToString();
txtAccName.Text = ds.Tables[0].Rows[0]["AccName"].ToString();
dt = ds.Tables[1];
InvoiceGrid.DataSource = dt;
InvoiceGridView.BestFitColumns();
InfoGrid.DataSource = dt;
InfoGridView.BestFitColumns();
}
}
}
private void frmGeneralInvoiceMst_Load(object sender, EventArgs e)
{
SetMyControls();
if (s1 == "&Add")
{
txtDebitPartyCode.Focus();
txtserial.Text = "S";
txtSerialNo.Text = getNewInvoiceDocumentNo().PadLeft(6, '0');
dtInvoiceDate.EditValue = DateTime.Now;
}
if (s1 == "Edit")
{
DataSet ds = ProjectFunctions.GetDataSet("[sp_LoadInvoiceDataForEditing] '" + ImDate.Date.ToString("yyyy-MM-dd") + "','" + ImNo + "'");
dtInvoiceDate.Text = ds.Tables[0].Rows[0]["ImDate"].ToString();
txtNetAmount.Text = ds.Tables[0].Rows[0]["ImNetAmt"].ToString();
txtRNetAmount.Text = ds.Tables[0].Rows[0]["ImNetAmtRO"].ToString();
txtTaxableAmount.Text = ds.Tables[0].Rows[0]["ImTxbAmt"].ToString();
txtTaxAmount.Text = ds.Tables[0].Rows[0]["ImTaxAmt"].ToString();
txtSurcharge.Text = ds.Tables[0].Rows[0]["ImSTaxAmt"].ToString();
txtValueOfGoods.Text = ds.Tables[0].Rows[0]["ImTxbAmt"].ToString();
txtDebitPartyCode.Text = ds.Tables[0].Rows[0]["ImPartyCode"].ToString();
txtDebitPartyName.Text = ds.Tables[0].Rows[0]["AccName"].ToString();
txtserial.Text = ds.Tables[0].Rows[0]["ImType"].ToString();
txtSerialNo.Text = ds.Tables[0].Rows[0]["ImNo"].ToString();
txtLCTag.Text = ds.Tables[0].Rows[0]["ImLC"].ToString();
txtCForm.Text = ds.Tables[0].Rows[0]["ImCForm"].ToString();
txtVatInvoice.Text = ds.Tables[0].Rows[0]["ImVRTag"].ToString();
dt = ds.Tables[1];
InfoGrid.DataSource = dt;
InfoGridView.BestFitColumns();
}
}
private void LoadSheet()
{
dt.Rows.Clear();
DevExpress.Spreadsheet.Workbook workbook = new DevExpress.Spreadsheet.Workbook();
workbook.LoadDocument(openFileDialog1.FileName);
DevExpress.Spreadsheet.Worksheet worksheet = workbook.Worksheets[i];
if (i <= workbook.Sheets.Count)
{
txtStoreCode.Text = worksheet.Name;
DataTable TempTable = new DataTable();
string xlConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + txtAddress.Text + ";Extended Properties=\"Excel 12.0;\";";
using (var myCommand = new OleDbDataAdapter("SELECT [EAN Code],[PI Qty] as [PI Qty] FROM [" + txtStoreCode.Text + "$]", xlConn))
{
myCommand.Fill(TempTable);
if (TempTable.Rows.Count > 0)
{
foreach (DataRow dr in TempTable.Rows)
{
DataSet ds = ProjectFunctions.GetDataSet("sp_LoadEANDataNew '" + dr["EAN Code"].ToString() + "'");
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dataRow = dt.NewRow();
dataRow["ARTNO"] = ds.Tables[0].Rows[0]["ARTNO"].ToString();
dataRow["ARTALIAS"] = ds.Tables[0].Rows[0]["ARTALIAS"].ToString();
dataRow["VARIANTART"] = ds.Tables[0].Rows[0]["VARIANT ART"].ToString();
dataRow["ARTMRP"] = ds.Tables[0].Rows[0]["ARTMRP"].ToString();
dataRow["SIZE"] = ds.Tables[0].Rows[0]["SIZE"].ToString();
dataRow["COLOR"] = ds.Tables[0].Rows[0]["COLOR"].ToString();
dataRow["COLSYSID"] = ds.Tables[0].Rows[0]["COLSYSID"].ToString();
dataRow["SZSYSID"] = ds.Tables[0].Rows[0]["SZSYSID"].ToString();
dataRow["ARTSYSID"] = ds.Tables[0].Rows[0]["ARTSYSID"].ToString();
dataRow["GrpDesc"] = ds.Tables[0].Rows[0]["GrpDesc"].ToString();
dataRow["GrpSubDesc"] = ds.Tables[0].Rows[0]["GrpSubDesc"].ToString();
if (dr["PI Qty"].ToString().Trim().Length == 0)
{
dr["PI Qty"] = 0;
}
dataRow["PIQty"] = Convert.ToDecimal(dr["PI Qty"]);
dataRow["EANNo"] = Convert.ToDecimal(dr["EAN Code"]);
dataRow["GrpHSNCode"] = ds.Tables[0].Rows[0]["GrpHSNCode"].ToString();
dt.Rows.Add(dataRow);
}
}
InfoGrid.DataSource = dt;
InfoGridView.BestFitColumns();
}
}
}
else
{
XtraMessageBox.Show("PIS Created Successfully");
}
}
private void FrmImportSaleGSTDiffData_Load(object sender, EventArgs e)
{
ProjectFunctions.ToolStripVisualize(Menu_ToolStrip);
if (S1 == "&Add")
{
txtDocNo.Text = GetNewDocCode().PadLeft(10, '0');
txtDocDate.EditValue = DateTime.Now;
}
if (S1 == "Edit")
{
DataSet ds = ProjectFunctions.GetDataSet("sp_LoadGSTSaleDiffMstFEdit '" + DocNo + "','" + Convert.ToDateTime(DocDate).ToString("yyyy-MM-dd") + "'");
if (ds.Tables[0].Rows.Count > 0)
{
txtDocDate.EditValue = Convert.ToDateTime(ds.Tables[0].Rows[0]["DocDate"]);
txtDocNo.Text = ds.Tables[0].Rows[0]["DocNo"].ToString();
txtDebitPartyCode.Text = ds.Tables[0].Rows[0]["AccCode"].ToString();
txtDebitPartyName.Text = ds.Tables[0].Rows[0]["AccName"].ToString();
txtFromDate.EditValue = Convert.ToDateTime(ds.Tables[1].Rows[0]["FromDate"]);
txtToDate.EditValue = Convert.ToDateTime(ds.Tables[1].Rows[0]["ToDate"]);
dt = ds.Tables[0];
InfoGrid.DataSource = dt;
InfoGridView.BestFitColumns();
SimpleButton4_Click(null, e);
}
}
}
private void HelpGrid_DoubleClick(object sender, EventArgs e)
{
DataRow currentrow = HelpGridView.GetDataRow(HelpGridView.FocusedRowHandle);
if (HelpGrid.Text == "SKU")
{
DataSet ds = ProjectFunctions.GetDataSet("sp_LoadSKUForPI '" + currentrow["SKUVOUCHNO"].ToString() + "' ,'" + currentrow["SKUFNYR"].ToString() + "'");
if (ds.Tables[0].Rows.Count > 0)
{
dt = ds.Tables[0];
InfoGrid.DataSource = ds.Tables[0];
InfoGridView.BestFitColumns();
HelpGrid.Visible = false;
}
else
{
InfoGrid.DataSource = null;
InfoGridView.BestFitColumns();
}
}
if (HelpGrid.Text == "STORE")
{
txtStoreCode.Text = currentrow["AccDCCode"].ToString();
HelpGrid.Visible = false;
}
}
private void OpenFileDialog1_FileOk(object sender, System.ComponentModel.CancelEventArgs e)
{
dt.Rows.Clear();
var path = openFileDialog1.FileName;
StreamReader sr = new StreamReader(path);
int j = 0;
while (sr.Peek() > 0)
{
int i = 0;
string[] cols = sr.ReadLine().Split('\t');
if (j > 0)
{
DataRow newrow = dt.NewRow();
foreach (string str in cols)
{
newrow[i] = str.Trim();
i++;
}
dt.Rows.Add(newrow);
}
j++;
}
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
String AccCode = string.Empty;
DataSet dsActMst = ProjectFunctions.GetDataSet(" Select AccCode from ActMst where upper(AccName)='" + dr["Account"].ToString().Trim().ToUpper().Replace("'", string.Empty) + "'");
if (dsActMst.Tables[0].Rows.Count > 0)
{
dr["AccCode"] = dsActMst.Tables[0].Rows[0][0].ToString();
}
}
InfoGrid.DataSource = dt;
InfoGridView.BestFitColumns();
}
else
{
InfoGrid.DataSource = null;
}
}
private void OpenFileDialog1_FileOk(object sender, CancelEventArgs e)
{
dt.Rows.Clear();
var xlConn = string.Empty;
xlConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + openFileDialog1.FileName + ";Extended Properties=\"Excel 12.0;\";";
using (var myCommand = new OleDbDataAdapter("SELECT '' as AccCode,[BILL DATE],[NET SALE VALUE] ,[NET SALE AFTER ADJ],[DISCOUNT],[USER ITEM CODE] FROM Sheet1$", xlConn))
{
myCommand.Fill(dt);
InfoGrid.DataSource = dt;
InfoGridView.BestFitColumns();
}
}
private void calculation()
{
BeginInvoke(new MethodInvoker(delegate
{
InfoGridView.PostEditor();
InfoGridView.UpdateCurrentRow();
}));
txtValueOfGoods.Text = Convert.ToDecimal(gridColumn18.SummaryItem.SummaryValue).ToString("0.00");
txtTaxableAmount.Text = Convert.ToDecimal(gridColumn18.SummaryItem.SummaryValue).ToString("0.00");
txtTaxAmount.Text = Convert.ToDecimal(gridColumn19.SummaryItem.SummaryValue).ToString("0.00");
txtSurcharge.Text = Convert.ToDecimal(gridColumn21.SummaryItem.SummaryValue).ToString("0.00");
txtNetAmount.Text = (Convert.ToDecimal(txtTaxableAmount.Text) + Convert.ToDecimal(txtTaxAmount.Text) + Convert.ToDecimal(txtSurcharge.Text)).ToString("0.00");
txtRNetAmount.Text = Math.Round(Convert.ToDecimal(txtNetAmount.Text), 2).ToString("0.00");
}
private void BtnDelete_Click(object sender, EventArgs e)
{
var MaxRow = (InfoGrid.FocusedView as GridView).RowCount;
if (MaxRow == 0)
{
ProjectFunctions.SpeakError("Invalid Operation");
}
else
{
InfoGridView.DeleteRow(rowindex);
InfoGridView.RefreshData();
dt.AcceptChanges();
Clear();
}
}
private void BtnLoad_Click(object sender, EventArgs e)
{
foreach (DevExpress.XtraEditors.Controls.CheckedListBoxItem item in txtSize.Properties.Items)
{
if (item.CheckState == CheckState.Checked)
{
foreach (DevExpress.XtraGrid.Columns.GridColumn col in InfoGridView.Columns)
{
if (item.Value.ToString().ToUpper() == col.FieldName.ToString().ToUpper())
{
col.Visible = true;
col.OptionsColumn.AllowEdit = true;
}
}
}
}
DataTable dt = new DataTable();
foreach (DevExpress.XtraGrid.Columns.GridColumn col in InfoGridView.Columns)
{
if (col.Visible)
{
dt.Columns.Add(col.FieldName, typeof(string));
}
}
foreach (DevExpress.XtraEditors.Controls.CheckedListBoxItem item in txtMeasurement.Properties.Items)
{
if (item.CheckState == CheckState.Checked)
{
DataRow dr = dt.NewRow();
dr["MCode"] = item.Value;
dr["MDesc"] = item.Description;
dt.Rows.Add(dr);
}
}
if (dt.Rows.Count > 0)
{
InfoGrid.DataSource = dt;
InfoGridView.BestFitColumns();
}
else
{
InfoGrid.DataSource = null;
}
}
private void BtnDelete_Click(object sender, EventArgs e)
{
#pragma warning disable CS0618 // 'GridControl.KeyboardFocusView' is obsolete: 'Use the FocusedView property instead.'
var MaxRow = ((InfoGrid.KeyboardFocusView as GridView).RowCount);
#pragma warning restore CS0618 // 'GridControl.KeyboardFocusView' is obsolete: 'Use the FocusedView property instead.'
if (MaxRow == 0)
{
ProjectFunctions.SpeakError("Invalid Operation");
}
else
{
InfoGridView.DeleteRow(rowindex);
InfoGridView.RefreshData();
dt.AcceptChanges();
clear();
}
}
private void FrmVoucherMstAddEdit_Load(object sender, EventArgs e)
{
SetMyControls();
if (S1 == "&Add")
{
dtInvoiceDate.EditValue = DateTime.Now;
txtVuType.Focus();
}
else
{
dtInvoiceDate.Enabled = false;
txtVuType.Enabled = false;
var str = "[sp_LoadVouDataFEditing] @VumNo='" + VoucherNo + "',@VumDate='" + Convert.ToDateTime(VoucherDate).ToString("yyyy-MM-dd") + "'";
DataSet ds = ProjectFunctions.GetDataSet(str);
dtInvoiceDate.Text = Convert.ToDateTime(ds.Tables[0].Rows[0]["VumDate"]).ToString("yyyy-MM-dd");
txtVuType.Text = ds.Tables[0].Rows[0]["VumType"].ToString();
txtVuDesc.Text = ds.Tables[0].Rows[0]["VouDesc"].ToString();
ds.Tables[1].Columns.Add("Credit", typeof(decimal));
ds.Tables[1].Columns.Add("Debit", typeof(decimal));
foreach (DataRow dr in ds.Tables[1].Rows)
{
if (Convert.ToDecimal(dr["Amount"]) < 0)
{
dr["Credit"] = -Convert.ToDecimal(dr["Amount"]);
dr["CrDr"] = "CR";
dr["Debit"] = Convert.ToDecimal("0");
}
if (Convert.ToDecimal(dr["Amount"]) > 0)
{
dr["Debit"] = Convert.ToDecimal(dr["Amount"]);
dr["CrDr"] = "DR";
dr["Credit"] = Convert.ToDecimal("0");
}
}
dt = ds.Tables[1];
InfoGrid.DataSource = dt;
InfoGridView.BestFitColumns();
txtAccCode.Focus();
}
}
private void frmUnsoldMstAdd_Load(object sender, EventArgs e)
{
if (s1 == "&Add")
{
txtAgainstInvNo.Focus();
txtserial.Text = "S";
txtSerialNo.Text = getNewInvoiceDocumentNo().PadLeft(6, '0');
}
if (s1 == "Edit")
{
DataSet ds = ProjectFunctions.GetDataSet("[LoadUnSoldDataForEditing] @InvDate='" + ImDate.Date.ToString("yyyy-MM-dd") + "',@Imno='" + ImNo + "'");
txtInvoiceType.Text = ds.Tables[0].Rows[0]["ImInvTypeHead"].ToString();
dtInvoiceDate.Text = ds.Tables[0].Rows[0]["ImDate"].ToString();
txtSmCode.Text = ds.Tables[0].Rows[0]["ImSalesManCode"].ToString();
txtSMName.Text = ds.Tables[0].Rows[0]["SMName"].ToString();
txtRouteCode.Text = ds.Tables[0].Rows[0]["ImRouteCode"].ToString();
txtRouteName.Text = ds.Tables[0].Rows[0]["RouteDesc"].ToString();
txtNetAmount.Text = ds.Tables[0].Rows[0]["ImNetAmt"].ToString();
txtRNetAmount.Text = ds.Tables[0].Rows[0]["ImNetAmtRO"].ToString();
txtTaxableAmount.Text = ds.Tables[0].Rows[0]["ImTxbAmt"].ToString();
txtTaxAmount.Text = ds.Tables[0].Rows[0]["ImTaxAmt"].ToString();
txtSurcharge.Text = ds.Tables[0].Rows[0]["ImSTaxAmt"].ToString();
txtValueOfGoods.Text = ds.Tables[0].Rows[0]["ImTxbAmt"].ToString();
txtDebitPartyCode.Text = ds.Tables[0].Rows[0]["ImPartyCode"].ToString();
txtDebitPartyName.Text = ds.Tables[0].Rows[0]["PartyName"].ToString();
txtSUSType.Text = ds.Tables[0].Rows[0]["ImType"].ToString();
txtserial.Text = ds.Tables[0].Rows[0]["ImNoSeries"].ToString();
txtSerialNo.Text = ds.Tables[0].Rows[0]["ImNo"].ToString();
txtLCTag.Text = ds.Tables[0].Rows[0]["ImLC"].ToString();
txtCForm.Text = ds.Tables[0].Rows[0]["ImCForm"].ToString();
txtRouteCode.Text = ds.Tables[0].Rows[0]["ImRouteCode"].ToString();
txtRouteName.Text = ds.Tables[0].Rows[0]["RouteDesc"].ToString();
txtVatInvoice.Text = ds.Tables[0].Rows[0]["ImVRTag"].ToString();
txtAgainstInvNo.Text = ds.Tables[0].Rows[0]["IminNo"].ToString();
txtAgainstInvDate.Text = ds.Tables[0].Rows[0]["IminDate"].ToString();
OldAgainstInvDate = Convert.ToDateTime(ds.Tables[0].Rows[0]["IminDate"]);
OldAgainstInvNo = ds.Tables[0].Rows[0]["IminNo"].ToString();
dt = ds.Tables[1];
InfoGrid.DataSource = dt;
InfoGridView.BestFitColumns();
}
}
private void FrmDealerOrderMaster_Load(object sender, EventArgs e)
{
SetMyControls();
if (S1 == "&Add")
{
dtOrderDate.EditValue = DateTime.Now;
dtOrderForDate.EditValue = DateTime.Now;
dtOrderForDate.Focus();
txtOrderNo.Text = GetNewInvoiceDocumentNo().PadLeft(8, '0');
DataSet ds = ProjectFunctions.GetDataSet("SP_LoadPrdForOrder");
if (ds.Tables[0].Rows.Count > 0)
{
dt = ds.Tables[0];
InfoGrid.DataSource = dt;
InfoGridView.BestFitColumns();
}
else
{
InfoGrid.DataSource = null;
}
}
if (S1 == "Edit")
{
txtDealerCode.Enabled = false;
dtOrderForDate.Focus();
DataSet ds = ProjectFunctions.GetDataSet("sp_LoadOrderDataFEditing '" + OrderNo + "'");
if (ds.Tables[0].Rows.Count > 0)
{
dtOrderDate.EditValue = Convert.ToDateTime(ds.Tables[0].Rows[0]["OrdDate"]);
dtOrderForDate.EditValue = Convert.ToDateTime(ds.Tables[0].Rows[0]["OrdForDate"]);
txtOrderNo.Text = ds.Tables[0].Rows[0]["OrdNo"].ToString();
txtDealerCode.Text = ds.Tables[0].Rows[0]["OrdDealerCode"].ToString();
txtDealerName.Text = ds.Tables[0].Rows[0]["AccName"].ToString();
dt = ds.Tables[1];
InfoGrid.DataSource = dt;
InfoGridView.BestFitColumns();
}
}
}
private void InfoGrid_DoubleClick(object sender, EventArgs e)
{
#pragma warning disable CS0618 // 'GridControl.KeyboardFocusView' is obsolete: 'Use the FocusedView property instead.'
var MaxRow = ((InfoGrid.KeyboardFocusView as GridView).RowCount);
#pragma warning restore CS0618 // 'GridControl.KeyboardFocusView' is obsolete: 'Use the FocusedView property instead.'
if (MaxRow == 0)
{
ProjectFunctions.SpeakError("Invalid Operation");
}
else
{
BtnOK.Text = "&Update";
rowindex = InfoGridView.FocusedRowHandle;
var row = InfoGridView.GetDataRow(InfoGridView.FocusedRowHandle);
txtPrdAsgnCode.Text = row["PrdAsgnCode"].ToString();
txtPrdCode.Text = row["PrdCode"].ToString();
txtProductName.Text = row["PrdName"].ToString();
txtQty.Text = row["Quantity"].ToString();
txtPrdAsgnCode.Focus();
}
}
private void BtnOK_Click(object sender, EventArgs e)
{
if (ValidateData())
{
InfoGrid.RefreshDataSource();
if (BtnOK.Text.ToUpper() == "&OK")
{
InfoGrid.RefreshDataSource();
var dr = dt.NewRow();
dr["PrdCode"] = Convert.ToDecimal(txtProductCode.Text);
dr["PrdAsgnCode"] = txtProductACode.Text;
dr["PrdName"] = txtProductName.Text;
dr["Qty"] = Convert.ToDecimal(txtProductQty.Text);
dr["Amount"] = Convert.ToDecimal(txtAmount.Text);
dt.Rows.Add(dr);
if (dt.Rows.Count > 0)
{
InfoGrid.DataSource = dt;
InfoGridView.BestFitColumns();
}
BtnUndo.PerformClick();
}
if (BtnOK.Text.ToUpper() == "&UPDATE")
{
InfoGridView.SetRowCellValue(rowindex, InfoGridView.Columns["PrdCode"], Convert.ToDecimal(txtProductCode.Text));
InfoGridView.SetRowCellValue(rowindex, InfoGridView.Columns["PrdAsgnCode"], txtProductACode.Text);
InfoGridView.SetRowCellValue(rowindex, InfoGridView.Columns["PrdName"], txtProductName.Text);
InfoGridView.SetRowCellValue(rowindex, InfoGridView.Columns["Qty"], Convert.ToDecimal(txtProductQty.Text));
InfoGridView.SetRowCellValue(rowindex, InfoGridView.Columns["Amount"], Convert.ToDecimal(txtAmount.Text));
InfoGridView.RefreshData();
BtnUndo.PerformClick();
}
}
}
private void InfoGrid_DoubleClick(object sender, EventArgs e)
{
#pragma warning disable CS0618 // 'GridControl.KeyboardFocusView' is obsolete: 'Use the FocusedView property instead.'
var MaxRow = ((InfoGrid.KeyboardFocusView as GridView).RowCount);
#pragma warning restore CS0618 // 'GridControl.KeyboardFocusView' is obsolete: 'Use the FocusedView property instead.'
if (MaxRow == 0)
{
ProjectFunctions.SpeakError("Invalid Operation");
}
else
{
BtnOK.Text = "&Update";
rowindex = InfoGridView.FocusedRowHandle;
var row = InfoGridView.GetDataRow(InfoGridView.FocusedRowHandle);
txtAccCode.Text = row["AccCode"].ToString();
txtAccName.Text = row["AccName"].ToString();
if (Convert.ToDecimal(row["Debit"]) > Convert.ToDecimal(row["Credit"]))
{
txtAmount.Text = row["Debit"].ToString();
}
else
{
txtAmount.Text = row["Credit"].ToString();
}
txtNarration.Text = row["Narration"].ToString();
txtChqNo.Text = row["VutChequeNo"].ToString();
if (row["VutChequeDate"].ToString().Trim().Length > 0)
{
txtChqDate.EditValue = Convert.ToDateTime(row["VutChequeDate"]);
}
txtDrCr.Text = row["CrDr"].ToString();
txtAccCode.Focus();
}
}
private void InfoGrid_DoubleClick(object sender, EventArgs e)
{
// var MaxRow = ((InfoGrid.FocusedView as GridView).RowCount);
var MaxRow = ((InfoGrid.FocusedView as GridView).RowCount);
if (MaxRow == 0)
{
ProjectFunctions.SpeakError("Invalid Operation");
}
else
{
BtnOK.Text = "&Update";
rowindex = InfoGridView.FocusedRowHandle;
var row = InfoGridView.GetDataRow(InfoGridView.FocusedRowHandle);
txtProductACode.Text = row["PrdAsgnCode"].ToString();
txtProductName.Text = row["PrdName"].ToString();
txtProductQty.Text = row["Qty"].ToString();
txtAmount.Text = row["Amount"].ToString();
txtProductCode.Text = row["PrdCode"].ToString();
txtProductACode.Focus();
}
}
private void LoadDelAddresses()
{
DataSet ds = ProjectFunctions.GetDataSet("sp_LoadActDelAddresses '" + txtAcCode.Text + "'");
if (ds.Tables[0].Rows.Count > 0)
{
InfoGrid.DataSource = ds.Tables[0];
InfoGridView.BestFitColumns();
}
else
{
InfoGrid.DataSource = null;
InfoGridView.BestFitColumns();
}
txtDelAddress1.Text = string.Empty;
txtDelAddress2.Text = string.Empty;
txtDelAddress3.Text = string.Empty;
txtDelCitycode.Text = string.Empty;
txtDelCityName.Text = string.Empty;
txtDelGSTNo.Text = string.Empty;
txtDelAccName.Text = string.Empty;
txtDelZipCode.Text = string.Empty;
}
private void HOSale()
{
dt.Clear();
DataRow row1 = dt.NewRow();
row1["Name"] = "CashAmount";
row1["Amount"] = 0.00;
dt.Rows.Add(row1);
DataRow row2 = dt.NewRow();
row2["Name"] = "CardAmount";
row2["Amount"] = 0.00;
dt.Rows.Add(row2);
DataRow row3 = dt.NewRow();
row3["Name"] = "PG. Amount";
row3["Amount"] = 0.00;
dt.Rows.Add(row3);
DataSet dsSale = ProjectFunctions.GetDataSet("sp_ShowRoomDashBoard '" + WorkingTag + "','" + GlobalVariables.CUnitID + "'");
//DataSet dsSale = ProjectFunctions.GetDataSet("sp_ShowRoomDashBoard '" + WorkingTag + "','" + ('0' + (GlobalVariables.CUnitID)) + GlobalVariables.FinancialYear + "'");
if (dsSale.Tables[0].Rows.Count > 0)
{
lblTotalSale.Text = Convert.ToDecimal(dsSale.Tables[2].Rows[0][0]).ToString("0.00");
lblTotalSaleQty.Text = Convert.ToDecimal(dsSale.Tables[0].Rows[0][0]).ToString("0.00");
lblNoOfBills.Text = Convert.ToDecimal(dsSale.Tables[1].Rows[0][0]).ToString("0.00");
if ((Convert.ToDecimal(lblTotalSale.Text) > 0) && (Convert.ToDecimal(lblTotalSaleQty.Text) > 0))
{
lblAverageBillSale.Text = (Convert.ToDecimal(lblTotalSale.Text) / Convert.ToDecimal(lblTotalSaleQty.Text)).ToString("0.00");
}
else
{
lblAverageBillSale.Text = "0.00";
}
int j = 0;
if (dsSale.Tables[3].Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
if (j == 0)
{
if (dr["Name"].ToString() == "CashAmount")
{
dr["Amount"] = Convert.ToDecimal(dsSale.Tables[3].Rows[0][0]);
j++;
}
}
if (j == 1)
{
if (dr["Name"].ToString() == "CardAmount")
{
dr["Amount"] = Convert.ToDecimal(dsSale.Tables[3].Rows[0][1]);
j++;
}
}
if (j == 2)
{
if (dr["Name"].ToString() == "PG. Amount")
{
dr["Amount"] = Convert.ToDecimal(dsSale.Tables[3].Rows[0][2]);
j++;
}
}
}
InfoGrid.DataSource = dt;
InfoGridView.BestFitColumns();
}
else
{
InfoGrid.DataSource = dt;
InfoGridView.BestFitColumns();
}
}
}
private void SaveInvoice()
{
try
{
if (ValidateDataForSaving())
{
using (var sqlcon = new SqlConnection(ProjectFunctions.GetConnection()))
{
var MaxRow = ((InfoGrid.FocusedView as GridView).RowCount);
sqlcon.Open();
var sqlcom = sqlcon.CreateCommand();
sqlcom.Connection = sqlcon;
sqlcom.CommandType = CommandType.Text;
try
{
if (S1 == "&Add")
{
string BillNo = string.Empty;
BillNo = ProjectFunctions.GetDataSet("select isnull(max(SIMNO),0)+1 from SALEINVMAIN where SIMSERIES='AP' And SIMFNYR='" + GlobalVariables.FinancialYear + "' And UnitCode='" + GlobalVariables.CUnitID + "'").Tables[0].Rows[0][0].ToString();
txtApprovalNo.Text = BillNo;
sqlcom.CommandText = "Insert into SALEINVMAIN(SIMSYSDATE,SIMFNYR,SIMDATE,SIMNO,SIMSERIES,CustCode,SIMRemarks,SIMRETURNDATE ,UnitCode,SIMGRANDTOT,SIMApprovedBy )values(" +
"@SIMSYSDATE,@SIMFNYR,@SIMDATE,@SIMNO,@SIMSERIES,@CustCode,@SIMRemarks,@SIMRETURNDATE,@UnitCode,@SIMGRANDTOT,@SIMApprovedBy)";
sqlcom.Parameters.Add("@SIMSYSDATE", SqlDbType.NVarChar).Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
sqlcom.Parameters.Add("@SIMFNYR", SqlDbType.NVarChar).Value = GlobalVariables.FinancialYear;
sqlcom.Parameters.Add("@SIMDATE", SqlDbType.NVarChar).Value = Convert.ToDateTime(txtApprovalDate.Text).ToString("yyyy-MM-dd");
sqlcom.Parameters.Add("@SIMNO", SqlDbType.NVarChar).Value = txtApprovalNo.Text;
sqlcom.Parameters.Add("@SIMSERIES", SqlDbType.NVarChar).Value = "AP";
sqlcom.Parameters.Add("@CustCode", SqlDbType.NVarChar).Value = txtCustCode.Text;
sqlcom.Parameters.Add("@SIMRemarks", SqlDbType.NVarChar).Value = txtRemarks.Text;
sqlcom.Parameters.Add("@SIMRETURNDATE", SqlDbType.NVarChar).Value = Convert.ToDateTime(txtReturnedUpTo.Text).ToString("yyyy-MM-dd");
sqlcom.Parameters.Add("@UnitCode", SqlDbType.NVarChar).Value = GlobalVariables.CUnitID;
sqlcom.Parameters.Add("@SIMGRANDTOT", SqlDbType.NVarChar).Value = gridColumn7.SummaryItem.SummaryValue.ToString();
sqlcom.Parameters.Add("@SIMApprovedBy", SqlDbType.NVarChar).Value = txtApprovedBy.Text;
sqlcom.ExecuteNonQuery();
sqlcom.Parameters.Clear();
}
if (S1 == "Edit")
{
sqlcom.CommandText = "Update SALEINVMAIN Set SIMSYSDATE=@SIMSYSDATE,SIMFNYR=@SIMFNYR,SIMDATE=@SIMDATE,SIMNO=@SIMNO," +
" SIMSERIES=@SIMSERIES,CustCode=@CustCode,SIMRemarks=@SIMRemarks,SIMRETURNDATE=@SIMRETURNDATE,SIMGRANDTOT=@SIMGRANDTOT,SIMApprovedBy=@SIMApprovedBy Where SIMDATE='" + Convert.ToDateTime(ImDate).ToString("yyyy-MM-dd") + "' And SIMNO='" + ImNo + "' And SIMSERIES='" + ImSeries + "' And UnitCode='" + GlobalVariables.CUnitID + "'";
sqlcom.Parameters.Add("@SIMSYSDATE", SqlDbType.NVarChar).Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
sqlcom.Parameters.Add("@SIMFNYR", SqlDbType.NVarChar).Value = GlobalVariables.FinancialYear;
sqlcom.Parameters.Add("@SIMDATE", SqlDbType.NVarChar).Value = Convert.ToDateTime(txtApprovalDate.Text).ToString("yyyy-MM-dd");
sqlcom.Parameters.Add("@SIMNO", SqlDbType.NVarChar).Value = txtApprovalNo.Text;
sqlcom.Parameters.Add("@SIMSERIES", SqlDbType.NVarChar).Value = "AP";
sqlcom.Parameters.Add("@CustCode", SqlDbType.NVarChar).Value = txtCustCode.Text;
sqlcom.Parameters.Add("@SIMRemarks", SqlDbType.NVarChar).Value = txtRemarks.Text;
sqlcom.Parameters.Add("@SIMRETURNDATE", SqlDbType.NVarChar).Value = Convert.ToDateTime(txtReturnedUpTo.Text).ToString("yyyy-MM-dd");
sqlcom.Parameters.Add("@SIMGRANDTOT", SqlDbType.NVarChar).Value = gridColumn7.SummaryItem.SummaryValue.ToString();
sqlcom.Parameters.Add("@SIMApprovedBy", SqlDbType.NVarChar).Value = txtApprovedBy.Text;
sqlcom.ExecuteNonQuery();
sqlcom.Parameters.Clear();
sqlcom.CommandType = System.Data.CommandType.Text;
sqlcom.CommandText = "update SFDET set Used='N' Where SFDBARCODE in (Select SIDBARCODE from SALEINVDET Where SIDSERIES=@SIDSERIES And SIDNO=@SIDNO And SIDDATE=@SIDDATE And UnitCode='" + GlobalVariables.CUnitID + "') AND UnitCode='" + GlobalVariables.CUnitID + "'";
sqlcom.Parameters.Add("@SIDSERIES", SqlDbType.NVarChar).Value = ImSeries;
sqlcom.Parameters.Add("@SIDNO", SqlDbType.NVarChar).Value = ImNo;
sqlcom.Parameters.Add("@SIDDATE", SqlDbType.NVarChar).Value = Convert.ToDateTime(ImDate).ToString("yyyy-MM-dd");
sqlcom.ExecuteNonQuery();
sqlcom.Parameters.Clear();
sqlcom.CommandType = CommandType.Text;
sqlcom.CommandText = "Delete from SALEINVDET Where SIDSERIES=@SIDSERIES And SIDNO=@SIDNO And SIDDATE=@SIDDATE And UnitCode ='" + GlobalVariables.CUnitID + "'";
sqlcom.Parameters.Add("@SIDSERIES", SqlDbType.NVarChar).Value = ImSeries;
sqlcom.Parameters.Add("@SIDNO", SqlDbType.NVarChar).Value = ImNo;
sqlcom.Parameters.Add("@SIDDATE", SqlDbType.NVarChar).Value = Convert.ToDateTime(ImDate).ToString("yyyy-MM-dd");
sqlcom.ExecuteNonQuery();
sqlcom.Parameters.Clear();
}
for (var i = 0; i < MaxRow; i++)
{
sqlcom.CommandType = CommandType.Text;
var currentrow = InfoGridView.GetDataRow(i);
sqlcom.CommandText = " Insert into SALEINVDET "
+ " (SIDSYSDATE,SIDFNYR,SIDDATE,SIDNO,SIDSERIES,"
+ " SIDBARCODE,SIDARTNO,SIDARTID,SIDCOLID,"
+ " SIDSIZID,SIDSCANQTY,SIDARTMRP,SIDARTWSP,CustCode,SIDRETURNDATE,UnitCode )"
+ " values(@SIDSYSDATE,@SIDFNYR,@SIDDATE,@SIDNO,@SIDSERIES,@SIDBARCODE,@SIDARTNO,@SIDARTID,@SIDCOLID,"
+ " @SIDSIZID,@SIDSCANQTY,@SIDARTMRP,@SIDARTWSP,@CustCode,@SIDRETURNDATE,@UnitCode)";
sqlcom.Parameters.Add("@SIDSYSDATE", SqlDbType.NVarChar).Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
sqlcom.Parameters.Add("@SIDFNYR", SqlDbType.NVarChar).Value = GlobalVariables.FinancialYear;
sqlcom.Parameters.Add("@SIDDATE", SqlDbType.NVarChar).Value = Convert.ToDateTime(txtApprovalDate.Text).ToString("yyyy-MM-dd");
sqlcom.Parameters.Add("@SIDNO", SqlDbType.NVarChar).Value = txtApprovalNo.Text.Trim();;
sqlcom.Parameters.Add("@SIDSERIES", SqlDbType.NVarChar).Value = "AP";
sqlcom.Parameters.Add("@SIDBARCODE", SqlDbType.NVarChar).Value = currentrow["SIDBARCODE"].ToString();
sqlcom.Parameters.Add("@SIDARTNO", SqlDbType.NVarChar).Value = currentrow["SIDARTNO"].ToString();
sqlcom.Parameters.Add("@SIDARTID", SqlDbType.NVarChar).Value = currentrow["SIDARTID"].ToString();
sqlcom.Parameters.Add("@SIDCOLID", SqlDbType.NVarChar).Value = currentrow["SIDCOLID"].ToString();
sqlcom.Parameters.Add("@SIDSIZID", SqlDbType.NVarChar).Value = currentrow["SIDSIZID"].ToString();
sqlcom.Parameters.Add("@SIDSCANQTY", SqlDbType.NVarChar).Value = Convert.ToDecimal(currentrow["SIDSCANQTY"]);
sqlcom.Parameters.Add("@SIDARTMRP", SqlDbType.NVarChar).Value = Convert.ToDecimal(currentrow["SIDARTMRP"]);
sqlcom.Parameters.Add("@SIDARTWSP", SqlDbType.NVarChar).Value = Convert.ToDecimal(currentrow["SIDARTWSP"]);
sqlcom.Parameters.Add("@CustCode", SqlDbType.NVarChar).Value = txtCustCode.Text;
sqlcom.Parameters.Add("@SIDRETURNDATE", SqlDbType.NVarChar).Value = Convert.ToDateTime(txtReturnedUpTo.Text).ToString("yyyy-MM-dd");
sqlcom.Parameters.Add("@UnitCode", SqlDbType.NVarChar).Value = GlobalVariables.CUnitID;
sqlcom.ExecuteNonQuery();
sqlcom.Parameters.Clear();
ProjectFunctions.GetDataSet("update SFDET set Used='Y' Where SFDBARCODE='" + currentrow["SIDBARCODE"].ToString() + "' And UnitCode='" + GlobalVariables.CUnitID + "'");
}
ProjectFunctions.SpeakError("Article Approval Saved Successfully");
sqlcon.Close();
Close();
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message);
}
}
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message);
}
}
private void TxtBarCode_KeyDown(object sender, KeyEventArgs e)
{
try
{
if (e.KeyCode == Keys.F3)
{
HelpGridView.Columns.Clear();
HelpGrid.Text = "Load";
DataTable dtNew = new DataTable();
DataSet ds = ProjectFunctions.GetDataSet("sp_LoadDataFromSFDet_F3 '" + GlobalVariables.CUnitID + "'");
if (ds.Tables[0].Rows.Count > 0)
{
ds.Tables[0].Columns.Add("Select", typeof(bool));
foreach (DataRow dr in ds.Tables[0].Rows)
{
dr["Select"] = false;
foreach (DataRow drdt in dt.Rows)
{
if (dr["SIDBARCODE"].ToString() == drdt["SIDBARCODE"].ToString())
{
dr["Select"] = true;
continue;
}
}
}
dtNew = ds.Tables[0].Clone();
foreach (DataRow drNewRow in ds.Tables[0].Select("Select=False"))
{
dtNew.ImportRow(drNewRow);
}
HelpGrid.DataSource = dtNew;
HelpGrid.Show();
HelpGrid.Focus();
HelpGridView.BestFitColumns();
HelpGridView.OptionsBehavior.Editable = true;
foreach (DevExpress.XtraGrid.Columns.GridColumn col in HelpGridView.Columns)
{
if (col.FieldName == "Select")
{
col.VisibleIndex = 0;
col.OptionsColumn.AllowEdit = true;
}
else
{
col.OptionsColumn.AllowEdit = false;
}
}
}
}
if (e.KeyCode == Keys.Enter)
{
DataSet ds = ProjectFunctions.GetDataSet("sp_LoadDataFromSKUdetUsingBarCode '" + txtBarCode.Text + "','" + GlobalVariables.CUnitID + "'");
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Used"].ToString().ToUpper() == "Y")
{
ProjectFunctions.SpeakError("BarCode Already Used In Some Other Document");
txtBarCode.Focus();
txtBarCode.SelectAll();
e.Handled = true;
return;
}
foreach (DataRow dr in dt.Rows)
{
if (dr["SIDBARCODE"].ToString().ToUpper() == txtBarCode.Text.Trim())
{
ProjectFunctions.SpeakError("BarCode Already Loaded In This Document");
txtBarCode.Focus();
txtBarCode.SelectAll();
e.Handled = true;
return;
}
}
if (Convert.ToDecimal(ds.Tables[0].Rows[0]["SIDARTMRP"]) != Convert.ToDecimal(ds.Tables[0].Rows[0]["ARTMRP"]))
{
ProjectFunctions.SpeakError("Difference In MRP( MRP In Article is - " + ds.Tables[0].Rows[0]["ARTMRP"].ToString() + ")");
txtBarCode.Focus();
txtBarCode.SelectAll();
e.Handled = true;
return;
}
if (dt.Rows.Count == 0)
{
dt = ds.Tables[0];
}
else
{
dt.Merge(ds.Tables[0]);
}
ShowImage(Convert.ToDecimal(ds.Tables[0].Rows[0]["SIDARTID"]).ToString());
}
else
{
ProjectFunctions.SpeakError("NO BarCode Found");
return;
}
if (dt.Rows.Count > 0)
{
InfoGrid.DataSource = dt;
InfoGridView.BestFitColumns();
}
else
{
InfoGrid.DataSource = null;
}
txtBarCode.Text = string.Empty;
txtBarCode.Focus();
}
}
catch (Exception ex)
{
ProjectFunctions.SpeakError(ex.Message);
}
e.Handled = true;
}
private void HelpGrid_DoubleClick(object sender, EventArgs e)
{
try
{
DataRow row = HelpGridView.GetDataRow(HelpGridView.FocusedRowHandle);
if (HelpGrid.Text == "txtCustMobileNo")
{
txtCustMobileNo.Text = row["CAFMOBILE"].ToString();
txtCustCode.Text = row["CAFSYSID"].ToString();
txtCustName.Text = row["CAFFNAME"].ToString();
txtCustDetails.Text = row["CAFADD"].ToString();
HelpGrid.Visible = false;
txtBarCode.Focus();
}
if (HelpGrid.Text == "Load")
{
foreach (DataRow dr in (HelpGrid.DataSource as DataTable).Rows)
{
if (dr["Select"].ToString().ToUpper() == "TRUE")
{
DataSet ds = ProjectFunctions.GetDataSet("sp_LoadDataFromSKUdetUsingBarCode '" + dr["SIDBARCODE"].ToString() + "','" + GlobalVariables.CUnitID + "'");
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Used"].ToString().ToUpper() == "Y")
{
ProjectFunctions.SpeakError("BarCode Already Used In Some Other Document");
txtBarCode.Focus();
txtBarCode.SelectAll();
return;
}
foreach (DataRow drNew in dt.Rows)
{
if (drNew["SIDBARCODE"].ToString().ToUpper() == dr["SIDBARCODE"].ToString())
{
ProjectFunctions.SpeakError("BarCode Already Loaded In This Document");
txtBarCode.Focus();
txtBarCode.SelectAll();
return;
}
}
if (Convert.ToDecimal(ds.Tables[0].Rows[0]["SIDARTMRP"]) != Convert.ToDecimal(ds.Tables[0].Rows[0]["ARTMRP"]))
{
ProjectFunctions.SpeakError("Difference In MRP( MRP In Article is - " + ds.Tables[0].Rows[0]["ARTMRP"].ToString() + ")");
txtBarCode.Focus();
txtBarCode.SelectAll();
return;
}
if (dt.Rows.Count == 0)
{
dt = ds.Tables[0];
}
else
{
dt.Merge(ds.Tables[0]);
}
}
else
{
ProjectFunctions.SpeakError("NO BarCode Found");
return;
}
}
}
if (dt.Rows.Count > 0)
{
InfoGrid.DataSource = dt;
InfoGridView.BestFitColumns();
}
else
{
InfoGrid.DataSource = null;
}
txtBarCode.Text = string.Empty;
HelpGrid.Visible = false;
txtBarCode.Focus();
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message);
}
}
private void FrmPIGeneration2_Load(object sender, EventArgs e)
{
SetMyControls();
if (S1 == "&Add")
{
txtPIDate.EditValue = DateTime.Now;
txtPINo.Text = GetNewInvoiceDocumentNo().PadLeft(6, '0');
}
if (S1 == "Edit")
{
txtPIDate.Enabled = false;
DataSet ds = ProjectFunctions.GetDataSet("sp_LoadPIMstNewFEDit '" + DocNo + "','" + Convert.ToDateTime(DocDate).ToString("yyyy-MM-dd") + "'");
if (ds.Tables[0].Rows.Count > 0)
{
txtPIDate.EditValue = Convert.ToDateTime(ds.Tables[0].Rows[0]["PIDate"]);
txtPINo.Text = ds.Tables[0].Rows[0]["PINo"].ToString();
txtStoreCode.Text = ds.Tables[0].Rows[0]["PIStoreCode"].ToString();
// DataTable TempTable = new DataTable();
//TempTable = ds.Tables[1];
//foreach (DataRow dr in TempTable.Rows)
//{
// DataSet dsInner = ProjectFunctions.GetDataSet("sp_LoadEANDataNew '" + dr["EANNo"].ToString() + "'");
// if (dsInner.Tables[0].Rows.Count > 0)
// {
// DataRow = dt.NewRow();
// dataRow["ARTNO"] = dsInner.Tables[0].Rows[0]["ARTNO"].ToString();
// dataRow["ARTALIAS"] = dsInner.Tables[0].Rows[0]["ARTALIAS"].ToString();
// dataRow["VARIANTART"] = dsInner.Tables[0].Rows[0]["VARIANT ART"].ToString();
// dataRow["ARTMRP"] = dsInner.Tables[0].Rows[0]["ARTMRP"].ToString();
// dataRow["SIZE"] = dsInner.Tables[0].Rows[0]["SIZE"].ToString();
// dataRow["COLOR"] = dsInner.Tables[0].Rows[0]["COLOR"].ToString();
// dataRow["COLSYSID"] = dsInner.Tables[0].Rows[0]["COLSYSID"].ToString();
// dataRow["SZSYSID"] = dsInner.Tables[0].Rows[0]["SZSYSID"].ToString();
// dataRow["ARTSYSID"] = dsInner.Tables[0].Rows[0]["ARTSYSID"].ToString();
// dataRow["GrpDesc"] = dsInner.Tables[0].Rows[0]["GrpDesc"].ToString();
// dataRow["GrpSubDesc"] = dsInner.Tables[0].Rows[0]["GrpSubDesc"].ToString();
// dataRow["PIQty"] = Convert.ToDecimal(dr["PIQty"]);
// dataRow["EANNo"] = Convert.ToDecimal(dr["EANNo"]);
// dataRow["GrpHSNCode"] = dsInner.Tables[0].Rows[0]["GrpHSNCode"].ToString();
// dt.Rows.Add(dataRow);
// }
//}
//foreach (DataRow dr in TempTable.Rows)
//{
// foreach (DataRow dr2 in ds.Tables[2].Rows)
// {
// if (dr["EANNo"].ToString().ToUpper() == dr2["EAN NUMBER"].ToString().ToUpper())
// {
// DataRow = dt.NewRow();
// dataRow["ARTNO"] = dr2["ARTNO"].ToString();
// dataRow["ARTALIAS"] = dr2["ARTALIAS"].ToString();
// dataRow["VARIANTART"] = dr2["VARIANT ART"].ToString();
// dataRow["ARTMRP"] = dr2["ARTMRP"].ToString();
// dataRow["SIZE"] = dr2["SIZE"].ToString();
// dataRow["COLOR"] = dr2["COLOR"].ToString();
// dataRow["COLSYSID"] = dr2["COLSYSID"].ToString();
// dataRow["SZSYSID"] = dr2["SZSYSID"].ToString();
// dataRow["ARTSYSID"] = dr2["ARTSYSID"].ToString();
// dataRow["GrpDesc"] = dr2["GrpDesc"].ToString();
// dataRow["GrpSubDesc"] = dr2["GrpSubDesc"].ToString();
// dataRow["PIQty"] = Convert.ToDecimal(dr["PIQty"]);
// dataRow["EANNo"] = Convert.ToDecimal(dr["EANNo"]);
// dataRow["GrpHSNCode"] = dr2["GrpHSNCode"].ToString();
// dt.Rows.Add(dataRow);
// break;
// }
// }
//}
dt = ds.Tables[1];
if (dt.Rows.Count > 0)
{
InfoGrid.DataSource = dt;
InfoGridView.BestFitColumns();
}
else
{
InfoGrid.DataSource = null;
InfoGridView.BestFitColumns();
}
}
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false);
SplashScreenManager.Default.SetWaitFormDescription("Loading Data ");
if (ValidateData())
{
InfoGridView.CloseEditor();
InfoGridView.UpdateCurrentRow();
using (var sqlcon = new SqlConnection(ProjectFunctions.GetConnection()))
{
sqlcon.Open();
var sqlcom = sqlcon.CreateCommand();
var transaction = sqlcon.BeginTransaction("SaveTransaction");
sqlcom.Connection = sqlcon;
sqlcom.Transaction = transaction;
sqlcom.CommandType = CommandType.Text;
try
{
if (S1 == "&Add")
{
txtPINo.Text = GetNewInvoiceDocumentNo().PadLeft(6, '0');
sqlcom.CommandText = "Insert into PIMstNew(PINo,PIDate,PIStoreCode)values(@PINo,@PIDate,@PIStoreCode)";
sqlcom.Parameters.AddWithValue("@PINo", txtPINo.Text.Trim());
sqlcom.Parameters.AddWithValue("@PIDate", Convert.ToDateTime(txtPIDate.Text));
sqlcom.Parameters.AddWithValue("@PIStoreCode", txtStoreCode.Text.Trim());
sqlcom.ExecuteNonQuery();
sqlcom.Parameters.Clear();
}
if (S1 == "Edit")
{
sqlcom.CommandType = CommandType.Text;
sqlcom.CommandText = "Update PIMstNew Set PIStoreCode=@PIStoreCode Where PINo = @PINo And PIDate=@PIDate ";
sqlcom.Parameters.AddWithValue("@PINo", txtPINo.Text.Trim());
sqlcom.Parameters.AddWithValue("@PIDate", Convert.ToDateTime(txtPIDate.Text));
sqlcom.Parameters.AddWithValue("@PIStoreCode", txtStoreCode.Text.Trim());
sqlcom.Parameters.Clear();
sqlcom.CommandType = CommandType.Text;
sqlcom.CommandText = " Delete from PIDataNew Where PINo = @PINo And PIDate=@PIDate ";
sqlcom.Parameters.AddWithValue("@PINo", txtPINo.Text.Trim());
sqlcom.Parameters.AddWithValue("@PIDate", Convert.ToDateTime(txtPIDate.Text));
sqlcom.ExecuteNonQuery();
sqlcom.Parameters.Clear();
}
SplashScreenManager.Default.SetWaitFormDescription("Saving Data ");
//foreach (DataRow dr in dt.Rows)
//{
// sqlcom.CommandType = CommandType.Text;
// sqlcom.CommandText = " Insert into PIDataNew"
// + " (PINo,PIDate,PIQty,EANNo)"
// + " values(@PINo,@PIDate,@PIQty,@EANNo)";
// sqlcom.Parameters.AddWithValue("@PINo", txtPINo.Text.Trim());
// sqlcom.Parameters.AddWithValue("@PIDate", Convert.ToDateTime(txtPIDate.Text));
// sqlcom.Parameters.AddWithValue("@PIQty", Convert.ToDecimal(dr["PIQty"]));
// sqlcom.Parameters.AddWithValue("@EANNo", dr["EANNo"].ToString());
// sqlcom.ExecuteNonQuery();
// sqlcom.Parameters.Clear();
//}
DataTable dtFinal = new DataTable();
dtFinal.Columns.Add("PINo", typeof(string));
dtFinal.Columns.Add("PIDate", typeof(string));
dtFinal.Columns.Add("PIQty", typeof(string));
dtFinal.Columns.Add("EANNo", typeof(string));
dtFinal.Rows.Clear();
foreach (DataRow dr in (InfoGrid.DataSource as DataTable).Rows)
{
DataRow drRow = dtFinal.NewRow();
drRow["PINo"] = txtPINo.Text.Trim();
drRow["PIDate"] = Convert.ToDateTime(txtPIDate.Text).ToString("yyyy-MM-dd");
drRow["PIQty"] = dr["PIQty"].ToString();
drRow["EANNo"] = dr["EANNo"].ToString();
dtFinal.Rows.Add(drRow);
}
dtFinal.AcceptChanges();
sqlcom.CommandType = CommandType.StoredProcedure;
sqlcom.CommandText = "sp_InsertPINew";
sqlcom.CommandTimeout = 600000;
SqlParameter param = new SqlParameter
{
ParameterName = "@PerformaInv",
Value = dtFinal
};
sqlcom.Parameters.Add(param);
sqlcom.ExecuteNonQuery();
sqlcom.Parameters.Clear();
transaction.Commit();
//ProjectFunctions.SpeakError("PI Data Saved Successfully");
sqlcon.Close();
if (FromExcel == "Y")
{
// SplashScreenManager.Default.SetWaitFormDescription("Saving PI " + i.ToString());
i++;
LoadSheet();
DevExpress.Spreadsheet.Workbook workbook = new DevExpress.Spreadsheet.Workbook();
workbook.LoadDocument(openFileDialog1.FileName);
DevExpress.Spreadsheet.Worksheet worksheet = workbook.Worksheets[i];
if (i <= workbook.Sheets.Count)
{
BtnSave_Click(null, e);
}
else
{
SplashScreenManager.CloseForm(false);
Close();
}
}
else
{
SplashScreenManager.CloseForm(false);
}
Close();
FromExcel = "N";
}
catch (Exception ex)
{
ProjectFunctions.SpeakError("Something Wrong. \n I am going to Roll Back." + ex.Message);
try
{
transaction.Rollback();
}
catch (Exception ex2)
{
ProjectFunctions.SpeakError("Something Wrong. \n Roll Back Failed." + ex2.Message);
}
}
}
}
}
