private void dgvBranchStockDetails_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetRowNumber(dgvBranchStockDetails);
ObjUtil.SetDataGridProperty(dgvBranchStockDetails, DataGridViewAutoSizeColumnsMode.DisplayedCells);
dgvBranchStockDetails.Columns["ProductID"].Visible = false;
dgvBranchStockDetails.Columns["SubProductID"].Visible = false;
dgvBranchStockDetails.Columns["StoreID"].Visible = false;
dgvBranchStockDetails.Columns["StoreName"].Visible = false;
dgvBranchStockDetails.Columns["ColorID"].Visible = false;
dgvBranchStockDetails.Columns["SizeID"].Visible = false;
}
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 dgvCustomerMaster_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetRowNumber(dgvCustomerMaster);
ObjUtil.SetDataGridProperty(dgvCustomerMaster, DataGridViewAutoSizeColumnsMode.Fill);
dgvCustomerMaster.Columns["CustomerID"].Visible = false;
lblTotalRecords.Text = "Total Records : " + dgvCustomerMaster.Rows.Count;
}
private void LoadData()
{
ObjUtil.SetDataGridProperty(dataGridView1, DataGridViewAutoSizeColumnsMode.Fill);
DataTable dt = null;
dt = ObjDAL.GetDataCol(clsUtility.DBName + ".dbo.CategoryMaster", "CategoryID,CategoryName,CategoryDescription,(CASE WHEN ActiveStatus =1 THEN 'Active' WHEN ActiveStatus =0 THEN 'InActive' END) ActiveStatus", "CategoryName");
if (ObjUtil.ValidateTable(dt))
{
dataGridView1.DataSource = dt;
}
else
{
dataGridView1.DataSource = null;
}
}
private void Dgv_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
try
{
DataGridView dgv = (DataGridView)sender;
ObjUtil.SetDataGridProperty(dgv, DataGridViewAutoSizeColumnsMode.Fill);
dgv.RowHeadersVisible = false;
dgv.AllowUserToAddRows = false;
dgv.Columns[0].ReadOnly = true;
dgv.Columns[1].ReadOnly = true;
dgv.Columns[2].ReadOnly = true;
dgv.DefaultCellStyle.SelectionBackColor = Color.White;
dgv.DefaultCellStyle.SelectionForeColor = Color.Black;
for (int i = 0; i < dgv.Rows.Count; i++)
{
if (Convert.ToDecimal(dgv.Rows[i].Cells["Rate"].Value) < 0)
{
dgv.Rows[i].DefaultCellStyle.BackColor = Color.Yellow;
dgv.Rows[i].DefaultCellStyle.ForeColor = Color.Black;
dgv.Rows[i].DefaultCellStyle.SelectionBackColor = System.Drawing.Color.Yellow;
dgv.Rows[i].DefaultCellStyle.SelectionForeColor = System.Drawing.Color.Black;
}
}
}
catch (Exception)
{
}
}
private void dataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetRowNumber(dataGridView1);
ObjUtil.SetDataGridProperty(dataGridView1, DataGridViewAutoSizeColumnsMode.Fill);
dataGridView1.Columns["PettyCashExpID"].Visible = false;
lblTotalRecords.Text = "Total Records : " + dataGridView1.Rows.Count;
}
private void dataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetRowNumber(dataGridView1);
ObjUtil.SetDataGridProperty(dataGridView1, DataGridViewAutoSizeColumnsMode.ColumnHeader);
//ObjUtil.SetDataGridProperty(dataGridView1, DataGridViewAutoSizeColumnsMode.Fill);
dataGridView1.Columns["PurchaseInvoiceDetailsID"].Visible = false;
dataGridView1.Columns["PurchaseInvoiceID"].Visible = false;
dataGridView1.Columns["DeliveryPurchaseID1"].Visible = false;
dataGridView1.Columns["ProductID"].Visible = false;
dataGridView1.Columns["BrandID"].Visible = false;
dataGridView1.Columns["SupplierID"].Visible = false;
dataGridView1.Columns["CategoryID"].Visible = false;
dataGridView1.Columns["CountryID"].Visible = false;
dataGridView1.Columns["SizeTypeID"].Visible = false;
dataGridView1.Columns["StoreID"].Visible = false;
//lblTotalRecords.Text = "Total Records : " + dataGridView1.Rows.Count;
}
private void dataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetRowNumber(dataGridView1);
ObjUtil.SetDataGridProperty(dataGridView1, DataGridViewAutoSizeColumnsMode.Fill);
dataGridView1.Columns["PC_Store_ID"].Visible = false;
dataGridView1.Columns["StoreID"].Visible = false;
dataGridView1.Columns["StoreCategoryID"].Visible = false;
}
private void dataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetRowNumber(dataGridView1);
ObjUtil.SetDataGridProperty(dataGridView1, DataGridViewAutoSizeColumnsMode.ColumnHeader);
dataGridView1.Columns["ModelNo"].HeaderText = "Style No.";
dataGridView1.Columns["PurchaseInvoiceDetailsID"].Visible = false;
dataGridView1.Columns["PurchaseInvoiceID"].Visible = false;
dataGridView1.Columns["DeliveryPurchaseID1"].Visible = false;
dataGridView1.Columns["ProductID"].Visible = false;
dataGridView1.Columns["SubProductID"].Visible = false;
dataGridView1.Columns["BrandID"].Visible = false;
dataGridView1.Columns["SupplierID"].Visible = false;
dataGridView1.Columns["CategoryID"].Visible = false;
dataGridView1.Columns["CountryID"].Visible = false;
dataGridView1.Columns["SizeTypeID"].Visible = false;
dataGridView1.Columns["StoreID"].Visible = false;
}
private void dataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetRowNumber(dataGridView1);
ObjUtil.SetDataGridProperty(dataGridView1, DataGridViewAutoSizeColumnsMode.ColumnHeader);
//ObjUtil.SetDataGridProperty(dataGridView1, DataGridViewAutoSizeColumnsMode.Fill);
dataGridView1.Columns["CurrencyRateID"].Visible = false;
dataGridView1.Columns["CountryID"].Visible = false;
}
private void dgvEmployee_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetRowNumber(dgvEmployee);
ObjUtil.SetDataGridProperty(dgvEmployee, DataGridViewAutoSizeColumnsMode.Fill);
dgvEmployee.Columns["Photo"].Visible = false;
dgvEmployee.Columns["EmpID"].Visible = false;
lblTotalRecords.Text = "Total Records : " + dgvEmployee.Rows.Count;
}
private void dgvProductDetails_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetRowNumber(dgvProductDetails);
ObjUtil.SetDataGridProperty(dgvProductDetails, DataGridViewAutoSizeColumnsMode.Fill);
dgvProductDetails.Columns["Id"].Visible = false;
dgvProductDetails.Columns["SalesMan"].Visible = false;
dgvProductDetails.Columns["ShopeID"].Visible = false;
}
private void dataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetRowNumber(dataGridView1);
ObjUtil.SetDataGridProperty(dataGridView1, DataGridViewAutoSizeColumnsMode.Fill);
dataGridView1.AllowUserToOrderColumns = false;
dataGridView1.AllowUserToResizeColumns = false;
dataGridView1.AllowUserToResizeRows = false;
dataGridView1.AllowUserToDeleteRows = false;
}
private void dataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetRowNumber(dataGridView1);
ObjUtil.SetDataGridProperty(dataGridView1, DataGridViewAutoSizeColumnsMode.ColumnHeader);
//ObjUtil.SetDataGridProperty(dataGridView1, DataGridViewAutoSizeColumnsMode.Fill);
dataGridView1.Columns["PurchaseInvoiceID"].Visible = false;
dataGridView1.Columns["SupplierID"].Visible = false;
lblTotalRecords.Text = "Total Records : " + dataGridView1.Rows.Count;
}
private void dgvPettyCashExp_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetRowNumber(dgvPettyCashExp);
ObjUtil.SetDataGridProperty(dgvPettyCashExp, DataGridViewAutoSizeColumnsMode.Fill);
dgvPettyCashExp.Columns["PettyCashExpID"].Visible = false;
dgvPettyCashExp.Columns["MasterCashClosingID"].Visible = false;
dgvPettyCashExp.Columns["StoreID"].Visible = false;
dgvPettyCashExp.Columns["CreatedBy"].Visible = false;
}
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 void dataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetRowNumber(dataGridView1);
ObjUtil.SetDataGridProperty(dataGridView1, DataGridViewAutoSizeColumnsMode.ColumnHeader);
dataGridView1.Columns["SubProductID"].Visible = false;
dataGridView1.Columns["ProductID"].Visible = false;
dataGridView1.Columns["Photo"].Visible = false;
dataGridView1.Columns["SupplierID"].Visible = false;
dataGridView1.Columns["CountryID"].Visible = false;
}
private void dgvProductDetails_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetRowNumber(dgvProductDetails);
ObjUtil.SetDataGridProperty(dgvProductDetails, DataGridViewAutoSizeColumnsMode.Fill);
for (int i = 0; i < dgvProductDetails.Columns.Count; i++)
{
if (i == 0)
{
dgvProductDetails.Columns[i].ReadOnly = false;
continue;
}
dgvProductDetails.Columns[i].ReadOnly = true;
}
dgvProductDetails.Columns["ProductStockID"].Visible = false;
dgvProductDetails.Columns["StoreID"].Visible = false;
dgvProductDetails.Columns["SubProductID"].Visible = false;
}
private void dgvProductDetails_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetRowNumber(dgvProductDetails);
ObjUtil.SetDataGridProperty(dgvProductDetails, DataGridViewAutoSizeColumnsMode.ColumnHeader);
//ObjUtil.SetDataGridProperty(dgvProductDetails, DataGridViewAutoSizeColumnsMode.Fill);
dgvProductDetails.Columns["ProductID"].Visible = false;
dgvProductDetails.Columns["StoreID"].Visible = false;
dgvProductDetails.Columns["CategoryID"].Visible = false;
dgvProductDetails.Columns["SizeTypeID"].Visible = false;
dgvProductDetails.Columns["SizeID"].Visible = false;
}
private void dgvProductDetails_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetRowNumber(dgvProductDetails);
ObjUtil.SetDataGridProperty(dgvProductDetails, DataGridViewAutoSizeColumnsMode.Fill);
dgvProductDetails.Columns["ProductID"].Visible = false;
dgvProductDetails.Columns["ColoriD"].Visible = false;
dgvProductDetails.Columns["SizeiD"].Visible = false;
txtTotalItems.Text = dgvProductDetails.Rows.Count.ToString();
}
private void dgvProductDetails_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetRowNumber(dgvProductDetails);
ObjUtil.SetDataGridProperty(dgvProductDetails, DataGridViewAutoSizeColumnsMode.Fill);
dgvProductDetails.Columns["SubProductID"].Visible = false;
dgvProductDetails.Columns["ProductID"].Visible = false;
dgvProductDetails.Columns["StoreID"].Visible = false;
dgvProductDetails.Columns["BrandID"].Visible = false;
lblTotalRecord.Text = "Total Records : " + dgvProductDetails.Rows.Count;
}
private void dgvCloseCash_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetRowNumber(dgvCloseCash);
ObjUtil.SetDataGridProperty(dgvCloseCash, DataGridViewAutoSizeColumnsMode.Fill, Color.White);
if (listView1.Items[0].Selected)
{
dgvCloseCash.Columns["CashBandID"].Visible = false;
dgvCloseCash.Columns["CashBand"].Visible = false;
dgvCloseCash.Columns["CashBoxDate"].Visible = false;
dgvCloseCash.Columns["CashStatus"].Visible = false;
dgvCloseCash.Columns["StoreID"].Visible = false;
dgvCloseCash.Columns["MasterCashClosingID"].Visible = false;
dgvCloseCash.Columns["CashNo"].Visible = false;
dgvCloseCash.Columns["EmployeeID"].Visible = false;
dgvCloseCash.Columns["TotalCashValue"].Visible = false;
dgvCloseCash.Columns["Name"].Visible = false;
dgvCloseCash.Columns["CashReturn"].Visible = false;
CalcTotalCashBand();
dgvCloseCash.RowsDefaultCellStyle.SelectionBackColor = Color.White;
dgvCloseCash.RowsDefaultCellStyle.SelectionForeColor = Color.Black;
}
else if (listView1.Items[1].Selected)
{
if (dgvCloseCash.Columns.Contains("CreditClosingID"))
{
dgvCloseCash.Columns["CreditClosingID"].Visible = false;
}
if (dgvCloseCash.Columns.Contains("MasterCashClosingID"))
{
dgvCloseCash.Columns["MasterCashClosingID"].Visible = false;
}
}
else if (listView1.Items[2].Selected)
{
if (dgvCloseCash.Columns.Contains("PettyCashExpID"))
{
dgvCloseCash.Columns["PettyCashExpID"].Visible = false;
}
if (dgvCloseCash.Columns.Contains("MasterCashClosingID"))
{
dgvCloseCash.Columns["MasterCashClosingID"].Visible = false;
}
CalcTotalPettyCashExp();
dgvCloseCash.RowsDefaultCellStyle.SelectionBackColor = System.Drawing.Color.White;
dgvCloseCash.RowsDefaultCellStyle.SelectionForeColor = System.Drawing.Color.Black;
}
dgvCloseCash.ClearSelection();
}
private void dgvProductDetails_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetRowNumber(dgvProductDetails);
//ObjUtil.SetDataGridProperty(dgvProductDetails, DataGridViewAutoSizeColumnsMode.ColumnHeader);
ObjUtil.SetDataGridProperty(dgvProductDetails, DataGridViewAutoSizeColumnsMode.Fill);
dgvProductDetails.Columns["ProductID"].Visible = false;
dgvProductDetails.Columns["Photo"].Visible = false;
dgvProductDetails.Columns["StoreID"].Visible = false;
dgvProductDetails.Columns["CategoryID"].Visible = false;
dgvProductDetails.Columns["SizeTypeID"].Visible = false;
dgvProductDetails.Columns["SizeID"].Visible = false;
lblTotalRecords.Text = "Total Records : " + dgvProductDetails.Rows.Count.ToString();
dgvProductDetails.MultiSelect = true;
}
private void dgvProductDetails_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetRowNumber(dgvProductDetails);
dgvProductDetails.Columns["ProductID"].Visible = false;
dgvProductDetails.Columns["ColoriD"].Visible = false;
dgvProductDetails.Columns["SizeiD"].Visible = false;
dgvProductDetails.Columns["OIRate"].Visible = false;
dgvProductDetails.Columns["Adj_Amount"].Visible = false;
dgvProductDetails.Columns["SubProductID"].Visible = false;
ObjUtil.SetDataGridProperty(dgvProductDetails, DataGridViewAutoSizeColumnsMode.Fill, System.Drawing.Color.White);
dgvProductDetails.ClearSelection();
dgvProductDetails.RowsDefaultCellStyle.SelectionBackColor = System.Drawing.Color.White;
dgvProductDetails.RowsDefaultCellStyle.SelectionForeColor = System.Drawing.Color.Black;
}
private void dgvProductDetails_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetRowNumber(dgvProductDetails);
ObjUtil.SetDataGridProperty(dgvProductDetails, DataGridViewAutoSizeColumnsMode.Fill, Color.White);
dgvProductDetails.Columns["TransferItemID"].Visible = false;
dgvProductDetails.Columns["StoreBillDetailsID"].Visible = false;
dgvProductDetails.Columns["ProductID"].Visible = false;
dgvProductDetails.Columns["SubProductID"].Visible = false;
dgvProductDetails.Columns["BillDate"].Visible = false;
dgvProductDetails.Columns["BillNo"].Visible = false;
dgvProductDetails.Columns["TotalQTY"].Visible = false;
dgvProductDetails.Columns["Total"].Visible = false;
dgvProductDetails.Columns["CellColor"].Visible = false;
dgvProductDetails.Columns["ColorID"].Visible = false;
dgvProductDetails.Columns["SizeID"].Visible = false;
for (int i = 0; i < dgvProductDetails.Rows.Count; i++)
{
if (dgvProductDetails.Rows[i].Cells["CellColor"].Value.ToString() == "Green")
{
dgvProductDetails.Rows[i].Cells["State"].Style.BackColor = Color.Green;
}
else if (dgvProductDetails.Rows[i].Cells["CellColor"].Value.ToString() == "Red")
{
dgvProductDetails.Rows[i].Cells["State"].Style.BackColor = Color.Red;
}
else if (dgvProductDetails.Rows[i].Cells["CellColor"].Value.ToString() == "Orange")
{
dgvProductDetails.Rows[i].Cells["State"].Style.BackColor = Color.Orange;
}
else if (dgvProductDetails.Rows[i].Cells["CellColor"].Value.ToString() == "Violet")
{
dgvProductDetails.Rows[i].Cells["State"].Style.BackColor = Color.Violet;
}
}
dgvProductDetails.ClearSelection();
dgvProductDetails.RowsDefaultCellStyle.SelectionBackColor = Color.Transparent;
dgvProductDetails.RowsDefaultCellStyle.SelectionForeColor = Color.Transparent;
}
private void dgvTransferWatch_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetDataGridProperty(dgvTransferWatch, DataGridViewAutoSizeColumnsMode.DisplayedCells);
dgvTransferWatch.Columns["StoreTransferID"].Visible = false;
dgvTransferWatch.Columns["CreatedBy"].Visible = false;
if (dgvTransferWatch.DataSource != null)
{
ObjUtil.SetRowNumber(dgvTransferWatch);
if (dgvTransferWatch.Columns.Contains("ColView"))
{
dgvTransferWatch.Columns.Remove("ColView");
}
DataGridViewButtonColumn ColView = new DataGridViewButtonColumn();
ColView.DataPropertyName = "View";
ColView.HeaderText = "View";
ColView.Name = "ColView";
ColView.Text = "View";
ColView.UseColumnTextForButtonValue = true;
//dataGridView1.Columns.Add(ColView);
dgvTransferWatch.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { ColView });
}
}
private void dataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetRowNumber(dataGridView1);
ObjUtil.SetDataGridProperty(dataGridView1, DataGridViewAutoSizeColumnsMode.ColumnHeader);
//ObjUtil.SetDataGridProperty(dataGridView1, DataGridViewAutoSizeColumnsMode.Fill);
dataGridView1.Columns["ProductID"].Visible = false;
dataGridView1.Columns["BrandID"].Visible = false;
if (dataGridView1.Columns.Contains("PurchaseInvoiceID"))
{
dataGridView1.Columns["PurchaseInvoiceID"].Visible = false;
}
if (dataGridView1.Columns.Contains("SupplierID"))
{
dataGridView1.Columns["SupplierID"].Visible = false;
}
if (dataGridView1.Columns.Contains("BillDate"))
{
dataGridView1.Columns["BillDate"].Visible = false;
}
if (dataGridView1.Columns.Contains("BillValue"))
{
dataGridView1.Columns["BillValue"].Visible = false;
}
if (dataGridView1.Columns.Contains("TotalQTY"))
{
dataGridView1.Columns["TotalQTY"].Visible = false;
}
if (dataGridView1.Columns.Contains("LocalValue"))
{
dataGridView1.Columns["LocalValue"].Visible = false;
}
if (dataGridView1.Columns.Contains("LocalBillValue"))
{
dataGridView1.Columns["LocalBillValue"].Visible = false;
}
}
private void dgvUser_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetRowNumber(dgvUser);
ObjUtil.SetDataGridProperty(dgvUser, DataGridViewAutoSizeColumnsMode.Fill);
}
private void dgvShopeDetails_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetDataGridProperty(dgvShopeDetails, DataGridViewAutoSizeColumnsMode.Fill);
dgvShopeDetails.Columns[0].ReadOnly = false;
}
private void dgvPurchaseInvoice_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
ObjUtil.SetRowNumber(dgvPurchaseInvoice);
ObjUtil.SetDataGridProperty(dgvPurchaseInvoice, DataGridViewAutoSizeColumnsMode.ColumnHeader);
dgvPurchaseInvoice.Columns["PurchaseInvoiceID"].Visible = false;
}
