private void txtSearchByProduct_TextChanged(object sender, EventArgs e)
{
if (txtSearchByProduct.Text.Trim().Length == 0)
{
LoadData();
return;
}
ObjDAL.SetStoreProcedureData("ProductName", SqlDbType.NVarChar, txtSearchByProduct.Text.Trim(), clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("CategoryId", SqlDbType.Int, 0, clsConnection_DAL.ParamType.Input);
DataSet ds = ObjDAL.ExecuteStoreProcedure_Get(clsUtility.DBName + ".dbo.Get_Product_Master");
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
if (ObjUtil.ValidateTable(dt))
{
dataGridView1.DataSource = dt;
}
else
{
dataGridView1.DataSource = null;
}
}
else
{
dataGridView1.DataSource = null;
}
}
private void LoadData()
{
try
{
ObjDAL.SetStoreProcedureData("FromDate", SqlDbType.Date, DBNull.Value, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("ToDate", SqlDbType.Date, DBNull.Value, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("BillStatus", SqlDbType.Int, DBNull.Value, clsConnection_DAL.ParamType.Input);
DataSet ds = ObjDAL.ExecuteStoreProcedure_Get(clsUtility.DBName + ".dbo.SPR_Get_StoreTransfer_List");
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
if (ObjUtil.ValidateTable(dt))
{
dgvTransferWatch.DataSource = dt;
}
else
{
dgvTransferWatch.DataSource = null;
}
}
}
catch (Exception ex)
{
clsUtility.ShowErrorMessage(ex.ToString(), clsUtility.strProjectTitle);
}
}
private void LoadData()
{
ObjDAL.SetStoreProcedureData("StoreBillDetailsID", SqlDbType.Int, StoreBillDetailsID, clsConnection_DAL.ParamType.Input);
DataSet ds = ObjDAL.ExecuteStoreProcedure_Get(clsUtility.DBName + ".dbo.SPR_Get_StoreTransfer_ItemDetails");
if (ds != null && ds.Tables.Count > 0)
{
dtStoreTransfer = ds.Tables[0];
if (ObjUtil.ValidateTable(dtStoreTransfer))
{
dgvProductDetails.DataSource = dtStoreTransfer;
txtDate.Text = Convert.ToDateTime(dtStoreTransfer.Rows[0]["BillDate"]).ToShortDateString();
txtTotalQTY.Text = dtStoreTransfer.Rows[0]["TotalQTY"].ToString();
txtBillNo.Text = dtStoreTransfer.Rows[0]["BillNo"].ToString();
object rate = dtStoreTransfer.Compute("SUM(Total)", string.Empty);
txtValue.Text = rate.ToString();
}
else
{
dgvProductDetails.DataSource = null;
}
}
else
{
dgvProductDetails.DataSource = null;
}
}
private void GetSelectedItemStockDetails()
{
ObjDAL.SetStoreProcedureData("ProductID", SqlDbType.Int, dgvBranchStockDetails.SelectedRows[0].Cells["ProductID"].Value, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("BarcodeNo", SqlDbType.BigInt, dgvBranchStockDetails.SelectedRows[0].Cells["BarcodeNo"].Value, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("ColorID", SqlDbType.Int, 0, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("ModelNo", SqlDbType.NVarChar, dgvBranchStockDetails.SelectedRows[0].Cells["ModelNo"].Value, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("CategoryID", SqlDbType.Int, 0, clsConnection_DAL.ParamType.Input);
DataSet ds = ObjDAL.ExecuteStoreProcedure_Get(clsUtility.DBName + ".dbo.SPR_Get_Material_NewDetails");
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
if (ObjUtil.ValidateTable(dt))
{
if (dt.Rows.Count > 1)
{
dgvStockDetails.DataSource = dt;
}
else
{
dgvStockDetails.DataSource = null;
}
}
else
{
dgvStockDetails.DataSource = null;
}
}
ObjDAL.ResetData();
}
private void SearchByStyleNo()
{
ObjDAL.SetStoreProcedureData("PurchaseInvoiceID", SqlDbType.Int, txtPurchaseID.Text, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("StoreID", SqlDbType.Int, frmHome.Home_StoreID, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("ModelNo", SqlDbType.NVarChar, cmbListBox.Text, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("PrintStaus", SqlDbType.Int, 0, clsConnection_DAL.ParamType.Input);
DataSet ds = ObjDAL.ExecuteStoreProcedure_Get(clsUtility.DBName + ".dbo.Get_PurchaseInvoice_BulkPrint_Color_Size");
if (ObjUtil.ValidateDataSet(ds))
{
DataTable dtPurchaseInvDetails = ds.Tables[0];
if (ObjUtil.ValidateTable(dtPurchaseInvDetails))
{
dataGridView1.DataSource = dtPurchaseInvDetails;
//txtPurchaseID.Text = "";
}
else
{
dataGridView1.DataSource = dtPurchaseInvDetails;
//txtPurchaseID.Clear();
clsUtility.ShowInfoMessage("No purchase invoice found for the given purhcase number.");
}
}
ObjDAL.ResetData();
}
private void LoadData()
{
ObjDAL.SetStoreProcedureData("StoreID", SqlDbType.Int, frmHome.Home_StoreID, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("FromDate", SqlDbType.Date, DBNull.Value, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("ToDate", SqlDbType.Date, DBNull.Value, clsConnection_DAL.ParamType.Input);
DataSet ds = ObjDAL.ExecuteStoreProcedure_Get(clsUtility.DBName + ".dbo.SPR_Get_PettyCashExpAmt");
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
if (ds.Tables.Count > 1)
{
DataTable dtPettyCashBal = ds.Tables[1];
if (ObjUtil.ValidateTable(dtPettyCashBal))
{
txtTotalPettyCash.Text = dtPettyCashBal.Rows[0]["TotalPettyCashAmt"].ToString();
txtTotalExpenses.Text = dtPettyCashBal.Rows[0]["TotalPettyCashExpAmt"].ToString();
txtPettyCashBAL.Text = dtPettyCashBal.Rows[0]["PettyCashBalance"].ToString();
}
}
if (ObjUtil.ValidateTable(dt))
{
dgvPettyCashExp.DataSource = dt;
}
else
{
dgvPettyCashExp.DataSource = null;
}
}
}
private void LoadData()
{
//DataTable dtPurchaseInvDetails = ObjCon.ExecuteSelectStatement("EXEC " + clsUtility.DBName + ".dbo.Get_PurchaseInvoice_BulkPrint_Color_Size '" + txtPurchaseID.Text + "'");
ObjDAL.SetStoreProcedureData("PurchaseInvoiceID", SqlDbType.Int, txtPurchaseID.Text, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("StoreID", SqlDbType.Int, frmHome.Home_StoreID, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("ModelNo", SqlDbType.NVarChar, "0", clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("PrintStaus", SqlDbType.Int, 0, clsConnection_DAL.ParamType.Input);
DataSet ds = ObjDAL.ExecuteStoreProcedure_Get(clsUtility.DBName + ".dbo.Get_PurchaseInvoice_BulkPrint_Color_Size");
if (ObjUtil.ValidateDataSet(ds))
{
btnResetPrint.Enabled = true;
DataTable dtPurchaseInvDetails = ds.Tables[0];
if (ObjUtil.ValidateTable(dtPurchaseInvDetails))
{
dgvProductDetails.DataSource = dtPurchaseInvDetails;
CurrentPurchaseInvoiceID = txtPurchaseID.Text;
//txtPurchaseID.Text = "";
}
else
{
dgvProductDetails.DataSource = dtPurchaseInvDetails;
chkAll.Visible = false;
CurrentPurchaseInvoiceID = "";
//txtPurchaseID.Clear();
clsUtility.ShowInfoMessage("No purchase invoice found for the given purhcase number.", clsUtility.strProjectTitle);
cmbListBox.DataSource = null;
}
if (ds.Tables.Count >= 1)
{
DataTable dtStyleNo = ds.Tables[1];
if (ObjUtil.ValidateTable(dtStyleNo))
{
cmbListBox.DataSource = dtStyleNo;
cmbListBox.DisplayMember = "ModelNo";
cmbListBox.ValueMember = "ModelNo";
cmbListBox.SelectedIndex = -1;
}
}
if (ds.Tables.Count >= 2)
{
DataTable dtProductPrint = ds.Tables[2];
if (ObjUtil.ValidateTable(dtProductPrint))
{
dataGridView1.DataSource = dtProductPrint;
}
else
{
dataGridView1.DataSource = null;
}
}
}
else
{
btnResetPrint.Enabled = false;
}
chkAll.Visible = true;
}
private void btnViewDetails_Click(object sender, EventArgs e)
{
if (ObjUtil.IsControlTextEmpty(txtSupplierBillNo))
{
clsUtility.ShowInfoMessage("Please Enter Bill Number.", clsUtility.strProjectTitle);
txtSupplierBillNo.Focus();
return;
}
dgvPurchaseItem.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.EnableResizing;
//Most time consumption enum is DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders
dgvPurchaseItem.RowHeadersVisible = false; // set it to false if not needed
ObjDAL.SetStoreProcedureData("BillNo", SqlDbType.NVarChar, txtPurchaseInvoiceID.Text, clsConnection_DAL.ParamType.Input);
DataSet ds = ObjDAL.ExecuteStoreProcedure_Get("sp_DetailPurchaseInvoiceReport");
if (ObjUtil.ValidateDataSet(ds))
{
dgvPurchaseInvoice.DataSource = ds.Tables[0];
if (ds.Tables.Count > 1)
{
dgvPurchaseInvoiceDetail.DataSource = ds.Tables[1];
}
if (ds.Tables.Count > 2)
{
dgvPurchaseItem.DataSource = ds.Tables[2];
}
dgvPurchaseInvoice.ClearSelection();
dgvPurchaseInvoiceDetail.ClearSelection();
dgvPurchaseItem.ClearSelection();
}
}
private Image GetProductPhoto(int SubProductID)
{
Image imgProduct = null;
ObjDAL.SetStoreProcedureData("SubProductID", SqlDbType.Int, SubProductID, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("ProductID", SqlDbType.Int, 0, clsConnection_DAL.ParamType.Input);
DataSet ds = ObjDAL.ExecuteStoreProcedure_Get(clsUtility.DBName + ".dbo.SPR_Get_ProductPhoto");
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
if (ObjUtil.ValidateTable(dt))
{
if (Convert.ToInt32(dt.Rows[0]["Flag"]) == 1)
{
string img = dt.Rows[0]["ImgName"].ToString();
if (System.IO.File.Exists(img))
{
imgProduct = Image.FromFile(img);
}
else
{
imgProduct = IMS_Client_2.Properties.Resources.NoImage;
}
}
else
{
imgProduct = IMS_Client_2.Properties.Resources.NoImage;
//clsUtility.ShowInfoMessage("Image file for the selected product doesn't exist.", clsUtility.strProjectTitle);
}
}
}
return(imgProduct);
}
private void LoadData()
{
ObjDAL.SetStoreProcedureData("StoreBillDetailsID", SqlDbType.Int, pStoreBillDetailsID, clsConnection_DAL.ParamType.Input);
DataSet ds = ObjDAL.ExecuteStoreProcedure_Get(clsUtility.DBName + ".dbo.SPR_Get_StoreTransfer_ListItems");
//DataSet ds = ObjDAL.ExecuteStoreProcedure_Get(clsUtility.DBName + ".dbo.SPR_Get_StoreTransfer_ItemDetails");
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
if (ObjUtil.ValidateTable(dt))
{
dgvTransferWatch.DataSource = dt;
txtBillNo.Text = dt.Rows[0]["BillNo"].ToString();
txtStoreName.Text = dt.Rows[0]["StoreName"].ToString();
txtBillDate.Text = Convert.ToDateTime(dt.Rows[0]["BillDate"]).ToString("yyyy-MM-dd");
txtReceiveBillDate.Text = dt.Rows[0]["ReceiveBillDate"] != DBNull.Value ?
Convert.ToDateTime(dt.Rows[0]["ReceiveBillDate"]).ToString("yyyy-MM-dd") : "";
txtTotalBillQTY.Text = dt.Rows[0]["TotalQTY"].ToString();
txtTotalEnterQTY.Text = dt.Rows[0]["ReceivedTotalQTY"].ToString();
}
else
{
dgvTransferWatch.DataSource = null;
}
}
}
private void LoadData()
{
ObjDAL.SetStoreProcedureData("StoreID", SqlDbType.Int, frmHome.Home_StoreID, clsConnection_DAL.ParamType.Input);
DataSet ds = ObjDAL.ExecuteStoreProcedure_Get(clsUtility.DBName + ".dbo.SPR_Get_ReceiveBranch_Transfer_List");
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
if (ObjUtil.ValidateTable(dt))
{
dgvProductDetails.DataSource = dt;
}
else
{
dgvProductDetails.DataSource = null;
}
}
}
private void LoadData()
{
DataSet ds = ObjDAL.ExecuteStoreProcedure_Get(clsUtility.DBName + ".dbo.SPR_Get_Customer");
if (ObjUtil.ValidateDataSet(ds))
{
DataTable dt = ds.Tables[0];
if (ObjUtil.ValidateTable(dt))
{
dgvCustomerMaster.DataSource = dt;
}
else
{
dgvCustomerMaster.DataSource = null;
}
}
else
{
dgvCustomerMaster.DataSource = null;
}
}
private void LoadData()
{
ObjDAL.SetStoreProcedureData("ColorName", SqlDbType.NVarChar, 0, clsConnection_DAL.ParamType.Input);
DataSet ds = ObjDAL.ExecuteStoreProcedure_Get(clsUtility.DBName + ".dbo.SPR_Get_Color_Master");
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
if (ObjUtil.ValidateTable(dt))
{
dgvColorMaster.DataSource = dt;
}
else
{
dgvColorMaster.DataSource = null;
}
}
else
{
dgvColorMaster.DataSource = null;
}
ObjDAL.ResetData();
}
private void LoadData()
{
ObjDAL.SetStoreProcedureData("SupplierBillNo", SqlDbType.VarChar, '0', clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("ShipmentNo", SqlDbType.VarChar, '0', clsConnection_DAL.ParamType.Input);
DataSet ds = ObjDAL.ExecuteStoreProcedure_Get(clsUtility.DBName + ".dbo.SPR_Get_PurchaseInvoice");
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
if (ObjUtil.ValidateTable(dt))
{
dataGridView1.DataSource = dt;
}
else
{
dataGridView1.DataSource = null;
}
}
else
{
dataGridView1.DataSource = null;
}
}
private void LoadData()
{
DataSet ds = ObjDAL.ExecuteStoreProcedure_Get(clsUtility.DBName + ".dbo.SPR_Get_Employee");
if (ObjUtil.ValidateDataSet(ds))
{
DataTable dataTable = ds.Tables[0];
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";
}
}
else
{
dgvEmployee.DataSource = null;
lblTotalRecords.Text = "Total Employee Count : 0";
}
}
private void LoadData()
{
ObjDAL.SetStoreProcedureData("StoreID", SqlDbType.Int, frmHome.Home_StoreID, clsConnection_DAL.ParamType.Input);
DataSet ds = ObjDAL.ExecuteStoreProcedure_Get(clsUtility.DBName + ".dbo.SPR_Get_PettyCashAmt");
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
if (ObjUtil.ValidateTable(dt))
{
dataGridView1.DataSource = dt;
}
else
{
dataGridView1.DataSource = null;
}
}
}
private void LoadData()
{
//DataTable dt = ObjCon.ExecuteSelectStatement("SELECT PSM.PC_Store_ID,PSM.StoreID, PSM.MachineName, SM.StoreName,SM.StoreID" + ",(CASE WHEN PSM.StoreCategory = 1 THEN 'Warehouse' WHEN PSM.StoreCategory = 0 THEN 'Normal Store' END) [StoreCategory] FROM " + clsUtility.DBName + ".[dbo].[tblPC_Store_Mapping] PSM " + "INNER JOIN " + clsUtility.DBName + ".[dbo].[StoreMaster] SM ON SM.StoreID = PSM.StoreID ORDER BY PSM.PC_Store_ID");
DataSet ds = ObjDAL.ExecuteStoreProcedure_Get(clsUtility.DBName + ".[dbo].SPR_Get_PCStoreMapping");
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
if (ObjUtil.ValidateTable(dt))
{
dataGridView1.DataSource = dt;
}
else
{
dataGridView1.DataSource = null;
}
}
}
private void GetDefaultShop()
{
ObjDAL.SetStoreProcedureData("MachineName", SqlDbType.NChar, Environment.MachineName, clsConnection_DAL.ParamType.Input);
DataSet ds = ObjDAL.ExecuteStoreProcedure_Get(clsUtility.DBName + ".[dbo].SPR_GetDefaultShopName");
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
if (ObjUtil.ValidateTable(dt))
{
Home_StoreID = Convert.ToInt32(dt.Rows[0]["StoreID"]);
lblShopName.Text = "Shop Name : " + dt.Rows[0]["StoreName"];
}
else
{
lblShopName.Text = "Shop Name : " + "NA";
}
}
}
private void LoadData()
{
DataSet ds = ObjDAL.ExecuteStoreProcedure_Get(clsUtility.DBName + ".dbo.SPR_Get_CashBand_Master");
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
if (ObjUtil.ValidateTable(dt))
{
dgvCashBand.DataSource = dt;
}
else
{
dgvCashBand.DataSource = null;
}
}
else
{
dgvCashBand.DataSource = null;
}
}
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)
{
ObjDAL.SetStoreProcedureData("PurchaseInvoiceID", SqlDbType.Int, txtPurchaseInvoiceID.Text, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("StoreID", SqlDbType.Int, cmbStore.SelectedValue, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("TotalQTY", SqlDbType.Int, txtTotalQTY.Text, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("EntryType", SqlDbType.Int, cmbEntryType.SelectedIndex, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("SupplierBillNo", SqlDbType.VarChar, txtSupplierBillNo.Text, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("CreatedBy", SqlDbType.Int, clsUtility.LoginID, clsConnection_DAL.ParamType.Input);
DataSet ds = ObjDAL.ExecuteStoreProcedure_Get(clsUtility.DBName + ".dbo.Insert_PurchaseInvoice_BulkPrint_Color_Size");
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
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 SearchByProductID()
{
//DataTable dt = ObjDAL.ExecuteSelectStatement("EXEC " + clsUtility.DBName + ".dbo.Get_Material_Details " + txtProductID.Text + ",NULL");
ObjDAL.SetStoreProcedureData("ProductID", SqlDbType.Int, txtProductID.Text.Trim(), clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("StoreID", SqlDbType.Int, DBNull.Value, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("BarcodeNo", SqlDbType.BigInt, DBNull.Value, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("ColorID", SqlDbType.Int, DBNull.Value, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("ModelNo", SqlDbType.NVarChar, DBNull.Value, clsConnection_DAL.ParamType.Input);
DataSet ds = ObjDAL.ExecuteStoreProcedure_Get(clsUtility.DBName + ".dbo.Get_Material_Details");
DataTable dt = ds.Tables[0];
if (ObjUtil.ValidateTable(dt))
{
dgvProductDetails.DataSource = dt;
}
else
{
dgvProductDetails.DataSource = null;
}
ObjDAL.ResetData();
}
private void LoadItemModelDetails()
{
ObjDAL.SetStoreProcedureData("ProductID", SqlDbType.Int, 0, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("ModelNo", SqlDbType.NVarChar, '0', clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("StoreID", SqlDbType.Int, 0, clsConnection_DAL.ParamType.Input);
DataSet ds = ObjDAL.ExecuteStoreProcedure_Get(clsUtility.DBName + ".dbo.SPR_Get_ItemWiseModelNo");
if (ds != null && ds.Tables.Count > 0)
{
DataTable dtItemModel = ds.Tables[0];
if (ObjUtil.ValidateTable(dtItemModel))
{
dgvProductDetails.DataSource = dtItemModel;
}
else
{
dgvProductDetails.DataSource = null;
}
}
else
{
dgvProductDetails.DataSource = null;
}
}
private void LoadData()
{
try
{
ObjDAL.SetStoreProcedureData("MasterCashClosingID", SqlDbType.Int, pMasterCashClosingID, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("StoreID", SqlDbType.Int, frmHome.Home_StoreID, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("PettyCashBAL", SqlDbType.Decimal, lblPettyCashBAL.Text, clsConnection_DAL.ParamType.Output);
DataSet ds = ObjDAL.ExecuteStoreProcedure_Get(clsUtility.DBName + ".dbo.SPR_Get_CashClosing_Details");
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
dtCredit = ds.Tables[1];
dtExpenses = ds.Tables[2];
DataTable dtoutput = ObjDAL.GetOutputParmData();
if (ObjUtil.ValidateTable(dtoutput))
{
PettyCashBAL = Convert.ToDecimal(dtoutput.Rows[0][1]);
lblPettyCashBAL.Text = PettyCashBAL.ToString();
}
if (ObjUtil.ValidateTable(dt))
{
dgvCloseCash.DataSource = dt;
dtCash = dt;
if (Convert.ToInt32(dt.Rows[0]["CashStatus"]) == 0)
{
dgvCloseCash.ReadOnly = false;
btnOpenCash.Enabled = false;
btnCloseCash.Enabled = true;
btnPreview.Enabled = false;
btnPrint.Enabled = false;
//btnPreview.Enabled = true;
//btnPrint.Enabled = true;
dgvCloseCash.DataSource = dtCash;
}
else
{
if (DateTime.Now.ToString("yyyy-MM-dd") == Convert.ToDateTime(dt.Rows[0]["CashBoxDate"]).ToString("yyyy-MM-dd"))
{
dgvCloseCash.ReadOnly = true;
btnOpenCash.Enabled = false;
btnCloseCash.Enabled = false;
btnPreview.Enabled = true;
btnPrint.Enabled = true;
}
else
{
dgvCloseCash.ReadOnly = true;
btnOpenCash.Enabled = true;
btnCloseCash.Enabled = false;
btnPreview.Enabled = true;
btnPrint.Enabled = true;
//btnPreview.Enabled = false;
//btnPrint.Enabled = false;
}
}
txtCashNo.Text = dt.Rows[0]["CashNo"].ToString();
txtCashierName.Text = dt.Rows[0]["Name"].ToString();
cmbShop.SelectedValue = dt.Rows[0]["StoreID"];
lblReturnedAmount.Text = dt.Rows[0]["CashReturn"].ToString();
txtTotalValue.Text = dt.Rows[0]["TotalCashValue"].ToString();
}
else
{
dgvCloseCash.DataSource = null;
dtCash = null;
dtExpenses = null;
btnOpenCash.Enabled = true;
btnCloseCash.Enabled = false;
btnPreview.Enabled = false;
btnPrint.Enabled = false;
}
ObjDAL.ResetData();
}
else
{
dtCash = null;
dtExpenses = null;
dgvCloseCash.DataSource = null;
//btnOpenCash.Enabled = false;
btnOpenCash.Enabled = true;
btnCloseCash.Enabled = false;
btnPreview.Enabled = false;
btnPrint.Enabled = false;
}
}
catch (Exception ex)
{
clsUtility.ShowErrorMessage(ex.ToString(), clsUtility.strProjectTitle);
}
}
