private void btnPost_Click(object sender, EventArgs e)
{
if (clsFormRights.HasFormRight(clsFormRights.Forms.Posting_Delivery, clsFormRights.Operation.Save) || clsUtility.IsAdmin)
{
if (validateform())
{
bool b = clsUtility.ShowQuestionMessage("Are you sure want to post for " + txtSupplierBillNo.Text + " ?", clsUtility.strProjectTitle);
if (b)
{
string para = txtPurchaseInvoiceID.Text + "," + cmbStore.SelectedValue + "," + txtTotalQTY.Text + "," + cmbEntryType.SelectedIndex + "," + txtSupplierBillNo.Text + "," + clsUtility.LoginID;
DataTable dt = ObjDAL.ExecuteSelectStatement("EXEC " + clsUtility.DBName + ".dbo.Insert_PurchaseInvoice_BulkPrint_Color_Size " + para);
if (ObjUtil.ValidateTable(dt))
{
int flag = Convert.ToInt32(dt.Rows[0]["Flag"]);
string Msg = dt.Rows[0]["Msg"].ToString();
clsUtility.ShowInfoMessage(Msg, clsUtility.strProjectTitle);
ClearAll();
}
else
{
clsUtility.ShowInfoMessage("Posting Delivery Entry for '" + txtSupplierBillNo.Text + "' is not Saved Successfully..", clsUtility.strProjectTitle);
}
}
}
}
else
{
clsUtility.ShowInfoMessage("You have no rights to perform this task", clsUtility.strProjectTitle);
}
}
private void ShowReplaceWindow()
{
if (txtOldInvoiceNumber.Text.Trim().Length == 0)
{
clsUtility.ShowInfoMessage("Please Enter Old Invoice Number.", clsUtility.strProjectTitle);
return;
}
DataTable dataTable = ObjCon.ExecuteSelectStatement("SELECT ID FROM " + clsUtility.DBName + ".dbo.SalesInvoiceDetails WITH(NOLOCK) WHERE InvoiceNumber='" + txtOldInvoiceNumber.Text + "'");
if (dataTable.Rows.Count == 0)
{
clsUtility.ShowInfoMessage("No Invoice found for Invoice Number: " + txtOldInvoiceNumber.Text, clsUtility.strProjectTitle);
return;
}
else
{
Sales.Sales_Invoice sales_Invoice = new Sales_Invoice();
sales_Invoice.txtInvoiceNumber.Text = this.txtOldInvoiceNumber.Text;
sales_Invoice.Text = "Replace/Return";
sales_Invoice.lblActiveStatus.ForeColor = Color.Maroon;
sales_Invoice.IsReplaceReturnMode = true;
sales_Invoice.Show();
this.Close();
}
}
private void LoadStore()
{
DataTable dt = ObjDAL.ExecuteSelectStatement("SELECT StoreID, StoreName FROM " + clsUtility.DBName + ".[dbo].[StoreMaster] WITH(NOLOCK) WHERE ISNULL(ActiveStatus,1)=1");
if (ObjUtil.ValidateTable(dt))
{
cmbStoreName.DataSource = dt;
cmbStoreName.DisplayMember = "StoreName";
cmbStoreName.ValueMember = "StoreID";
cmbStoreName.SelectedIndex = -1;
}
}
private void LoadData()
{
//DataTable dt = ObjDAL.GetDataCol(clsUtility.DBName + ".dbo.PurchaseInvoice", "PurchaseInvoiceID,SupplierBillNo,SupplierID,ShipmentNo,BillDate,BillValue,TotalQTY,LocalValue,LocalExp,LocalBillValue", " ISNULL(IsInvoiceDone,0) = 0 AND PurchaseInvoiceID = " + txtPurchaseInvoiceID.Text + "", "BillDate");
DataTable dt = ObjDAL.ExecuteSelectStatement("EXEC " + clsUtility.DBName + ".dbo.Get_PurchaseInvoice_BillDetails " + txtPurchaseInvoiceID.Text);
if (ObjUtil.ValidateTable(dt))
{
double TotalValueBill = 0, TotalQTYBill = 0, LocalValue = 0;
dtpBillDate.Value = dt.Rows[0]["BillDate"] != DBNull.Value ? Convert.ToDateTime(dt.Rows[0]["BillDate"]) : DateTime.Now;
cmbSupplier.SelectedValue = Convert.ToInt32(dt.Rows[0]["SupplierID"]);
TotalValueBill = Convert.ToDouble(dt.Rows[0]["BillValue"]);
TotalQTYBill = Convert.ToDouble(dt.Rows[0]["TotalQTY"]);
LocalValue = Convert.ToDouble(dt.Rows[0]["LocalValue"]);
LocalBillValue = Convert.ToDouble(dt.Rows[0]["LocalBillValue"]);
txtTotalValueBill.Text = TotalValueBill.ToString();
txtTotalQTYBill.Text = TotalQTYBill.ToString();
PurchaseInvoiceID = Convert.ToInt32(dt.Rows[0]["PurchaseInvoiceID"]);
txtDiffQty.Text = (Convert.ToInt32(txtTotalQTYBill.Text) - pTotalQTY).ToString();
txtDiffValue.Text = (Convert.ToDouble(txtTotalValueBill.Text) - pTotalAmt).ToString();
txtCurrencyRate.Text = Math.Round((LocalValue / TotalValueBill), 3).ToString();
txtNewRate.Text = Math.Round((LocalBillValue / TotalValueBill), 3).ToString();
txtProductName.Focus();
if (Convert.ToInt32(dt.Rows[0]["ProductID"]) > 0)
{
grpPurchaseBillDetail.Enabled = false;
dataGridView1.DataSource = null;
dataGridView1.DataSource = dt;
CalculateSubTotal();
}
else
{
grpPurchaseBillDetail.Enabled = true;
if (ObjUtil.ValidateTable((DataTable)dataGridView1.DataSource))
{
//dataGridView1.Rows.Clear();
dataGridView1.DataSource = dtDefaultBillDetails;
}
//dataGridView1.DataSource = null;
}
}
else
{
clsUtility.ShowInfoMessage("Purchase Invoice is already billed OR not available for Bill No. " + txtSupplierBillNo.Text, clsUtility.strProjectTitle);
grpPurchaseBillDetail.Enabled = false;
}
}
private string GetBarCodeSettings()
{
string strBarCodeSettings = null;
DataTable dataTable = ObjDAL.ExecuteSelectStatement("SELECT BarCodeSetting FROM " + clsUtility.DBName + ".dbo.tblBarCodeSettings WITH(NOLOCK)");
if (ObjUtil.ValidateTable(dataTable))
{
if (dataTable.Rows[0]["BarCodeSetting"] != DBNull.Value)
{
strBarCodeSettings = dataTable.Rows[0]["BarCodeSetting"].ToString();
}
}
return(strBarCodeSettings);
}
private void LoadData(string strCondition)
{
if (strCondition == string.Empty)
{
string strQ = "select * from " + clsUtility.DBName + ".dbo.View_SalesBillDetails";
dgvProductDetails.DataSource = ObjDAL.ExecuteSelectStatement(strQ);
lblCOunt.Text = dgvProductDetails.Rows.Count.ToString();
}
else
{
string strQ = "select * from " + clsUtility.DBName + ".dbo.View_SalesBillDetails where " + strCondition;
dgvProductDetails.DataSource = ObjDAL.ExecuteSelectStatement(strQ);
lblCOunt.Text = dgvProductDetails.Rows.Count.ToString();
}
}
private void LoadData()
{
ObjUtil.SetDataGridProperty(dataGridView1, DataGridViewAutoSizeColumnsMode.Fill);
DataTable dt = null;
dt = ObjDAL.ExecuteSelectStatement("EXEC " + clsUtility.DBName + ".dbo.Get_Brand_Master");
if (ObjUtil.ValidateTable(dt))
{
dataGridView1.DataSource = dt;
}
else
{
dataGridView1.DataSource = null;
}
}
private void LoadData()
{
DataTable dt = ObjDAL.ExecuteSelectStatement("EXEC " + clsUtility.DBName + ".dbo.Get_DiffPurchase_Received " + txtPurchaseInvoiceID.Text);
if (ObjUtil.ValidateTable(dt))
{
btnViewDetails.Enabled = true;
dataGridView1.DataSource = dt;
}
else
{
btnViewDetails.Enabled = false;
dataGridView1.DataSource = null;
}
}
void LoadConnection()
{
try
{
for (int i = 0; i < 100; i++)
{
ObjThread.SetLoadingProgressPercent(i, 100);
}
DataTable dt = ObjDAL.ExecuteSelectStatement("SELECT * FROM sys.databases WHERE name NOT IN('master','model','msdb','tempdb','ReportServer','ReportServerTempDB')");
string str = string.Empty;
if (ObjUtil.ValidateTable(dt))
{
for (int i = 0; i < dt.Rows.Count; i++)
{
str = dt.Rows[i][0].ToString();
AddItem(str.Trim());
}
}
ObjThread.CloseLoadingDialog();
}
catch (Exception ex)
{
ObjThread.CloseLoadingDialog();
clsUtility.ShowErrorMessage(ex.ToString(), clsUtility.strProjectTitle);
}
}
private void LoadCashStatus()
{
int pStoreID = Home_StoreID;
DataTable dtCashMaster = ObjDAL.ExecuteSelectStatement("SELECT TOP 1 * FROM " + clsUtility.DBName + ".[dbo].[tblMasterCashClosing] WITH(NOLOCK) WHERE StoreID=" + pStoreID + " ORDER BY CashBoxDate DESC");
if (ObjUtil.ValidateTable(dtCashMaster))
{
Home_MasterCashClosingID = Convert.ToInt32(dtCashMaster.Rows[0]["MasterCashClosingID"]);
if (Convert.ToBoolean(dtCashMaster.Rows[0]["CashStatus"]))
{
if (DateTime.Now.ToString("yyyy-MM-dd") == Convert.ToDateTime(dtCashMaster.Rows[0]["CashBoxDate"]).ToString("yyyy-MM-dd"))
{
btnOpenCash.Text = "View Details";
}
IsForceCloseCash = false;
label7.Text = "CLOSED";
}
else
{
label7.Text = "OPEN";
btnOpenCash.Text = "View Details";
if (DateTime.Now.ToString("yyyy-MM-dd") != Convert.ToDateTime(dtCashMaster.Rows[0]["CashBoxDate"]).ToString("yyyy-MM-dd"))
{
IsForceCloseCash = true;
clsUtility.ShowInfoMessage("Please close your previous day cash box and Open a new cash box for today.", clsUtility.strProjectTitle);
return;
}
IsForceCloseCash = false;
}
}
else
{
label7.Text = "NA";
}
}
private void txtSupplierBillNo_TextChanged(object sender, EventArgs e)
{
try
{
if (txtSupplierBillNo.Text.Length > 0)
{
DataTable dt = ObjDAL.ExecuteSelectStatement("EXEC " + clsUtility.DBName + ".dbo.Get_PurchaseInvoice_Popup '" + txtSupplierBillNo.Text + "'");
if (ObjUtil.ValidateTable(dt))
{
ObjUtil.SetControlData(txtSupplierBillNo, "SupplierBillNo");
ObjUtil.SetControlData(txtPurchaseInvoiceID, "PurchaseInvoiceID");
ObjUtil.ShowDataPopup(dt, txtSupplierBillNo, this, this);
if (ObjUtil.GetDataPopup() != null && ObjUtil.GetDataPopup().DataSource != null)
{
// if there is only one column
ObjUtil.GetDataPopup().AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
if (ObjUtil.GetDataPopup().ColumnCount > 0)
{
ObjUtil.GetDataPopup().Columns["PurchaseInvoiceID"].Visible = false;
ObjUtil.GetDataPopup().Columns["SupplierID"].Visible = false;
ObjUtil.SetDataPopupSize(300, 0);
}
}
ObjUtil.GetDataPopup().CellClick += Posting_Delivery_CellClick;
ObjUtil.GetDataPopup().KeyDown += Posting_Delivery_KeyDown;
}
else
{
ObjUtil.CloseAutoExtender();
}
}
else
{
txtPurchaseInvoiceID.Clear();
txtTotalQTY.Clear();
ObjUtil.CloseAutoExtender();
}
}
catch (Exception ex)
{
clsUtility.ShowErrorMessage(ex.ToString(), clsUtility.strProjectTitle);
}
}
private void LoadData()
{
DataTable dt = null;
dt = ObjDAL.ExecuteSelectStatement("SELECT S.SupplierID,S.SupplierName,S.CountryID,C.CountryName,(CASE S.ActiveStatus WHEN 1 THEN 'Active' WHEN 0 THEN 'InActive' END) ActiveStatus,S.Phone,S.EmailID,S.BankName,S.BankAccountNo,S.BankAddress " +
"FROM " + clsUtility.DBName + ".[dbo].[SupplierMaster] S " +
"LEFT OUTER JOIN " + clsUtility.DBName + ".[dbo].[CountryMaster] C ON S.CountryID = C.CountryID");
if (ObjUtil.ValidateTable(dt))
{
dataGridView1.DataSource = dt;
}
else
{
dataGridView1.DataSource = null;
}
}
private void LoadData()
{
string q = "SELECT e1.EmpID,EmployeeCode,Name,ShopID,(CASE e1.Gender WHEN 1 THEN 'Male' WHEN 0 THEN 'Female' END) Gender,DOB,[Address],Photo, s1.StoreName FROM " + clsUtility.DBName + ".dbo.EmployeeDetails e1 JOIN " + clsUtility.DBName + ".dbo.StoreMaster s1" +
" ON e1.ShopID=s1.StoreID ORDER BY EmpID DESC";
DataTable dataTable = ObjDAL.ExecuteSelectStatement(q);
if (ObjUtil.ValidateTable(dataTable))
{
dgvEmployee.DataSource = dataTable;
lblTotalRecords.Text = "Total Employee Count : " + dgvEmployee.Rows.Count.ToString();
}
else
{
dgvEmployee.DataSource = null;
lblTotalRecords.Text = "Total Employee Count : 0";
}
}
private void LoadData()
{
DataTable dt = null;
dt = ObjDAL.ExecuteSelectStatement("SELECT sm.SizeID, sm.Size, sm.SizeTypeID, stm.SizeTypeName" +
", (CASE WHEN sm.ActiveStatus = 1 THEN 'Active' WHEN sm.ActiveStatus = 0 THEN 'InActive' END) ActiveStatus FROM " + clsUtility.DBName + ".[dbo].[SizeMaster] sm " +
"INNER JOIN " + clsUtility.DBName + ".[dbo].[SizeTypeMaster] stm ON sm.SizeTypeID = stm.SizeTypeID ORDER BY sm.SizeTypeID,sm.Size");
if (ObjUtil.ValidateTable(dt))
{
dataGridView1.DataSource = dt;
}
else
{
dataGridView1.DataSource = null;
}
}
private void txtSalesMan_TextChanged(object sender, EventArgs e)
{
try
{
DataTable dt = ObjDAL.ExecuteSelectStatement("select Empid,Name from " + clsUtility.DBName + ".dbo.employeeDetails where Name Like '" + txtSalesMan.Text + "%'");
if (dt != null && dt.Rows.Count > 0)
{
ObjUtil.SetControlData(txtSalesMan, "Name");
ObjUtil.SetControlData(txtEmpID, "Empid");
ObjUtil.ShowDataPopup(dt, txtSalesMan, this, this);
if (ObjUtil.GetDataPopup() != null && ObjUtil.GetDataPopup().DataSource != null)
{
// if there is only one column
ObjUtil.GetDataPopup().AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
if (ObjUtil.GetDataPopup().ColumnCount > 0)
{
ObjUtil.GetDataPopup().Columns["Empid"].Visible = false;
ObjUtil.SetDataPopupSize(200, 0);
}
}
//ObjUtil.GetDataPopup().CellClick += frmSalecounter_CellClick;
//ObjUtil.GetDataPopup().KeyDown += frmSalecounter_KeyDown;
}
else
{
ObjUtil.CloseAutoExtender();
}
}
catch (Exception)
{
}
}
private string GetTotalCreditValue()
{
DataTable dt = ObjDAL.ExecuteSelectStatement("SELECT ISNULL(SUM(Value),0) FROM " + clsUtility.DBName + ".[dbo].[tblCreditClosing] WITH(NOLOCK) WHERE MasterCashClosingID=" + pMasterCashClosingID);
if (ObjUtil.ValidateTable(dt))
{
return(dt.Rows[0][0].ToString());
}
return("0");
}
private void txtSearchByProductName_TextChanged(object sender, EventArgs e)
{
try
{
if (txtSearchByProductName.Text.Length > 0)
{
DataTable dt = ObjDAL.ExecuteSelectStatement("EXEC " + clsUtility.DBName + ".dbo.Get_ProductDetails_Popup '" + txtSearchByProductName.Text + "'");
if (ObjUtil.ValidateTable(dt))
{
ObjUtil.SetControlData(txtSearchByProductName, "ProductName");
ObjUtil.SetControlData(txtProductID, "ProductID");
ObjUtil.ShowDataPopup(dt, txtSearchByProductName, this, groupBox1);
if (ObjUtil.GetDataPopup() != null && ObjUtil.GetDataPopup().DataSource != null)
{
ObjUtil.GetDataPopup().AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
if (ObjUtil.GetDataPopup().ColumnCount > 0)
{
ObjUtil.GetDataPopup().Columns["ProductID"].Visible = false;
ObjUtil.GetDataPopup().Columns["CategoryID"].Visible = false;
ObjUtil.SetDataPopupSize(300, 0);
}
}
ObjUtil.GetDataPopup().CellClick += Material_Details_SearchByProductName_CellClick;
ObjUtil.GetDataPopup().KeyDown += Material_Details_SearchByProductName_KeyDown;
}
else
{
ObjUtil.CloseAutoExtender();
}
}
else
{
txtProductID.Clear();
ObjUtil.CloseAutoExtender();
}
}
catch (Exception)
{
}
}
private void BindUserDetails()
{
DataTable dt = ObjDAL.ExecuteSelectStatement("SELECT * FROM " + clsUtility.DBName + ".[dbo].[UserManagement] WHERE EmployeeID=" + EmployeeID);
if (ObjUtil.ValidateTable(dt))
{
txtUsername.Text = dt.Rows[0]["UserName"].ToString();
txtPass.Text = ObjUtil.Decrypt(dt.Rows[0]["Password"].ToString(), true);
txtEmail.Text = dt.Rows[0]["EmailID"].ToString();
}
}
private void loadUser()
{
if (clsUtility.IsAdmin)
{
string str = "SELECT DISTINCT u1.UserID , u1.UserName FROM " + clsUtility.DBName + ".[dbo].[UserManagement] u1 JOIN " + clsUtility.DBName + ".[dbo].[tblUserRights] ur " +
"ON u1.UserID = ur.UserID";
DataTable dtuser = ObjCon.ExecuteSelectStatement(str);
dgvUser.DataSource = dtuser;
dgvUser.Columns["UserID"].Visible = false;
}
else
{
string str = "SELECT DISTINCT u1.UserID , u1.UserName FROM " + clsUtility.DBName + ".[dbo].[UserManagement] u1 JOIN " + clsUtility.DBName + ".[dbo].[tblUserRights] ur " +
"ON u1.UserID = ur.UserID WHERE u1.UserID=" + clsUtility.LoginID;
DataTable dtuser = ObjCon.ExecuteSelectStatement(str);
dgvUser.DataSource = dtuser;
dgvUser.Columns["UserID"].Visible = false;
}
}
private void txtPurchaseInvoice_TextChanged(object sender, EventArgs e)
{
try
{
if (txtPurchaseInvoice.TextLength > 0)
{
//DataTable dt = ObjCon.ExecuteSelectStatement("EXEC " + clsUtility.DBName + ".dbo.Get_PurchaseInvoice_Popup '" + txtPurchaseInvoice.Text + "', 1");
DataTable dt = ObjDAL.ExecuteSelectStatement("EXEC " + clsUtility.DBName + ".dbo.Get_PurchaseInvoice_Popup '" + txtPurchaseInvoice.Text + "', 0");
if (ObjUtil.ValidateTable(dt))
{
ObjUtil.SetControlData(txtPurchaseInvoice, "SupplierBillNo");
ObjUtil.SetControlData(txtPurchaseID, "PurchaseInvoiceID");
ObjUtil.ShowDataPopup(dt, txtPurchaseInvoice, this, this);
if (ObjUtil.GetDataPopup() != null && ObjUtil.GetDataPopup().DataSource != null)
{
// if there is only one column
ObjUtil.GetDataPopup().AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
if (ObjUtil.GetDataPopup().ColumnCount > 0)
{
ObjUtil.GetDataPopup().Columns["PurchaseInvoiceID"].Visible = false;
ObjUtil.GetDataPopup().Columns["SupplierID"].Visible = false;
ObjUtil.SetDataPopupSize(300, 0);
}
}
ObjUtil.GetDataPopup().CellClick += frmManuallyBarCode_CellClick;
ObjUtil.GetDataPopup().KeyDown += frmManuallyBarCode_KeyDown;;
}
}
else
{
ObjUtil.CloseAutoExtender();
}
}
catch (Exception)
{
}
}
private void txtSearchByProductName_TextChanged(object sender, EventArgs e)
{
try
{
if (txtSearchByProductName.Text.Length == 0)
{
dgvProductDetails.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.EnableResizing;
//Most time consumption enum is DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders
dgvProductDetails.RowHeadersVisible = false; // set it to false if not needed
LoadItemModelDetails();
return;
}
if (txtSearchByProductName.Text.Length > 0)
{
DataTable dt = ObjDAL.ExecuteSelectStatement("EXEC " + clsUtility.DBName + ".dbo.Get_ProductDetails_Popup '" + txtSearchByProductName.Text + "'");
if (ObjUtil.ValidateTable(dt))
{
ObjUtil.SetControlData(txtSearchByProductName, "ItemName");
ObjUtil.SetControlData(txtProductID, "ProductID");
ObjUtil.ShowDataPopup(dt, txtSearchByProductName, this, groupBox1);
if (ObjUtil.GetDataPopup() != null && ObjUtil.GetDataPopup().DataSource != null)
{
ObjUtil.GetDataPopup().AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
if (ObjUtil.GetDataPopup().ColumnCount > 0)
{
ObjUtil.GetDataPopup().Columns["ProductID"].Visible = false;
ObjUtil.GetDataPopup().Columns["CategoryID"].Visible = false;
ObjUtil.SetDataPopupSize(300, 0);
}
}
ObjUtil.GetDataPopup().CellClick += frmItemWiseModelNo_SearchByProductName_CellClick;
ObjUtil.GetDataPopup().KeyDown += frmItemWiseModelNo_SearchByProductName_KeyDown;
}
else
{
ObjUtil.CloseAutoExtender();
}
}
else
{
txtProductID.Clear();
ObjUtil.CloseAutoExtender();
}
}
catch (Exception ex)
{
clsUtility.ShowErrorMessage(ex.ToString(), clsUtility.strProjectTitle);
}
}
private void Load_Color_SizeData()
{
dtPurchaseQTYColor = ObjDAL.ExecuteSelectStatement("EXEC " + clsUtility.DBName + ".[dbo].[Get_PurchaseInvoice_Color_Size] '" + txtSupplierBillNo.Text + "', " + listBoxModelNo.SelectedItem + "");
if (ObjUtil.ValidateTable(dtPurchaseQTYColor))
{
//ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterGridClick, clsUtility.IsAdmin);
ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterGridClick);
dgvQtycolor.DataSource = null;
dgvQtycolor.DataSource = dtPurchaseQTYColor;
dgvQtycolor.Refresh();
dgvQtycolor.ReadOnly = true;
cmbSizeType.Enabled = false;
}
else
{
//ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterNew, clsUtility.IsAdmin);
ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterNew);
dgvQtycolor.ReadOnly = false;
dgvQtycolor.DataSource = null;
cmbSizeType.Enabled = true;
}
}
private void txtSalesMan_TextChanged(object sender, EventArgs e)
{
try
{
if (txtSalesMan.Text.Trim().Length == 0)
{
return;
}
DataTable dt = ObjDAL.ExecuteSelectStatement("SELECT Empid,Name FROM " + clsUtility.DBName + ".dbo.employeeDetails WITH(NOLOCK) WHERE Name Like '" + txtSalesMan.Text + "%'");
if (ObjUtil.ValidateTable(dt))
{
ObjUtil.SetControlData(txtSalesMan, "Name");
ObjUtil.SetControlData(txtEmpID, "Empid");
ObjUtil.ShowDataPopup(dt, txtSalesMan, this, groupBox1);
if (ObjUtil.GetDataPopup() != null && ObjUtil.GetDataPopup().DataSource != null)
{
// if there is only one column
ObjUtil.GetDataPopup().AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
if (ObjUtil.GetDataPopup().ColumnCount > 0)
{
ObjUtil.GetDataPopup().Columns["Empid"].Visible = false;
ObjUtil.SetDataPopupSize(450, 0);
}
}
//ObjUtil.GetDataPopup().CellClick += Sales_Bill_Details_CellClick;
//ObjUtil.GetDataPopup().KeyDown += Sales_Bill_Details_KeyDown;
}
else
{
ObjUtil.CloseAutoExtender();
}
}
catch (Exception)
{
}
}
public static string GetPrinterName(PrinterType printerType)
{
CoreApp.clsConnection_DAL ObjCon = new clsConnection_DAL(true);
string printerName = "";
if (printerType == PrinterType.BarCodePrinter)
{
DataTable dtPrinter = ObjCon.ExecuteSelectStatement("SELECT * FROM [tblPrinterSetting] WITH(NOLOCK) WHERE machineName='" + Environment.MachineName + "' ");
if (dtPrinter.Rows.Count > 0)
{
printerName = dtPrinter.Rows[0]["BarCodePrinter"].ToString();
}
}
else if (printerType == PrinterType.InvoicePrinter)
{
DataTable dtPrinter = ObjCon.ExecuteSelectStatement("SELECT * FROM [tblPrinterSetting] WITH(NOLOCK) WHERE machineName='" + Environment.MachineName + "' ");
if (dtPrinter.Rows.Count > 0)
{
printerName = dtPrinter.Rows[0]["InvoicePrinter"].ToString();
}
}
return(printerName);
}
private void LoadData()
{
DataTable dt = null;
dt = ObjDAL.ExecuteSelectStatement("EXEC " + clsUtility.DBName + ".dbo.Get_CurrencyRate");
if (ObjUtil.ValidateTable(dt))
{
dataGridView1.DataSource = dt;
}
else
{
dataGridView1.DataSource = null;
}
}
private void LoadFromStore()
{
string strQ = "";
if (clsUtility.IsAdmin)
{
strQ = "SELECT StoreID,StoreName FROM " + clsUtility.DBName + ".dbo.StoreMaster WITH(NOLOCK)";
cmdFrom.Enabled = true;
}
else
{
cmdFrom.Enabled = false;
strQ = "SELECT StoreID,StoreName FROM " + clsUtility.DBName + ".dbo.StoreMaster WHERE StoreID in " +
" (SELECT StoreID FROM " + clsUtility.DBName + ".dbo.tblStoreUserRights WHERE UserID = " + clsUtility.LoginID + ")";
}
DataTable dtFromStore = ObjDAL.ExecuteSelectStatement(strQ);
if (ObjUtil.ValidateTable(dtFromStore))
{
cmdFrom.DataSource = dtFromStore;
cmdFrom.DisplayMember = "StoreName";
cmdFrom.ValueMember = "StoreID";
}
}
private void LoadData()
{
DataTable dt = ObjDAL.ExecuteSelectStatement("EXEC " + clsUtility.DBName + ".dbo.Get_DiffPurchase_Received_Details " + PurchaseInvoiceID);
int TotalBillQTY = 0, TotalReceivedQTY = 0, TotalDiffQTY = 0;
double TotalDiffValue = 0;
if (ObjUtil.ValidateTable(dt))
{
for (int i = 0; i < dt.Rows.Count; i++)
{
TotalReceivedQTY += dt.Rows[i]["Receive QTY"] != DBNull.Value ? Convert.ToInt32(dt.Rows[i]["Receive QTY"]) : 0;
TotalDiffQTY += dt.Rows[i]["Diff QTY"] != DBNull.Value ? Convert.ToInt32(dt.Rows[i]["Diff QTY"]) : 0;
TotalDiffValue += dt.Rows[i]["Diff QTY"] != DBNull.Value ? Convert.ToDouble(dt.Rows[i]["Diff Value"]) : 0;
if (i == 0)
{
TotalBillQTY = dt.Rows[i]["TotalQTY"] != DBNull.Value ? Convert.ToInt32(dt.Rows[i]["TotalQTY"]) : 0;
continue;
}
}
cmbSupplier.SelectedValue = Convert.ToInt32(dt.Rows[0]["SupplierID"]);
txtTotalBillQTY.Text = TotalBillQTY.ToString();
txtTotalQTYReceived.Text = TotalReceivedQTY.ToString();
//txtTotalDiffQTY.Text = TotalDiffQTY.ToString();
txtTotalDiffQTY.Text = (TotalReceivedQTY - TotalBillQTY).ToString();
txtTotalDiffValue.Text = TotalDiffValue.ToString();
txtSupplierBillNo.Text = dt.Rows[0]["SupplierBillNo"].ToString();
txtNewRate.Text = dt.Rows[0]["New Rate"].ToString();
dtpBillDate.Value = Convert.ToDateTime(dt.Rows[0]["BillDate"]);
object ob = ObjDAL.ExecuteScalar("SELECT CurrencyName FROM " + clsUtility.DBName + ".[dbo].[CurrencyRateSetting] WITH(NOLOCK) WHERE CountryID=" + dt.Rows[0]["CountryID"]);
txtCurrencyName.Text = ob.ToString();
dataGridView1.DataSource = dt;
}
else
{
txtTotalBillQTY.Text = TotalBillQTY.ToString();
txtTotalQTYReceived.Text = TotalReceivedQTY.ToString();
txtTotalDiffQTY.Text = TotalDiffQTY.ToString();
txtTotalDiffValue.Text = TotalDiffValue.ToString();
dataGridView1.DataSource = null;
}
}
private void LoadData()
{
DataTable dt = null;
dt = ObjDAL.ExecuteSelectStatement("SELECT sm.SizeTypeID,sm.SizeTypeName,cm.CategoryID,cm.CategoryName" +
", (CASE sm.ActiveStatus WHEN 1 THEN 'Active' WHEN 0 THEN 'InActive' END) " + "ActiveStatus FROM SizeTypeMaster sm " +
" LEFT JOIN CategoryMaster cm ON sm.CategoryID = cm.CategoryID");
if (ObjUtil.ValidateTable(dt))
{
dgvSizeTypeMaster.DataSource = dt;
}
else
{
dgvSizeTypeMaster.DataSource = null;
}
}
private void LoadData()
{
ObjUtil.SetDataGridProperty(dgvSizeTypeMaster, DataGridViewAutoSizeColumnsMode.Fill);
DataTable dt = null;
dt = ObjDAL.ExecuteSelectStatement("SELECT sm.SizeTypeID,sm.SizeTypeName,cm.CategoryID,cm.CategoryName" +
", (CASE WHEN sm.ActiveStatus = 1 THEN 'Active' WHEN sm.ActiveStatus = 0 THEN 'InActive' END) " + "ActiveStatus FROM SizeTypeMaster sm " +
" LEFT JOIN CategoryMaster cm ON sm.CategoryID = cm.CategoryID");
if (ObjUtil.ValidateTable(dt))
{
dgvSizeTypeMaster.DataSource = dt;
}
else
{
dgvSizeTypeMaster.DataSource = null;
}
}
private string GetBarCodeSettings()
{
string strBarCodeSettings = null;
DataTable dataTable = ObjCon.ExecuteSelectStatement("SELECT BarCodeSetting FROM " + clsUtility.DBName + ".dbo.tblBarCodeSettings WITH(NOLOCK)");
if (ObjUtil.ValidateTable(dataTable))
{
if (dataTable.Rows[0]["BarCodeSetting"] != DBNull.Value)
{
strBarCodeSettings = dataTable.Rows[0]["BarCodeSetting"].ToString();
}
}
else
{
clsUtility.ShowInfoMessage("No Barcode Template found.", clsUtility.strProjectTitle);
}
return(strBarCodeSettings);
}
