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 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 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 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()
{
//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 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 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 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()
{
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 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()
{
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 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()
{
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 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 SaveEmployee()
{
ObjDAL.SetStoreProcedureData("EmployeeCode", SqlDbType.NVarChar, txtEmployeeCode.Text.Trim(), clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("Name", SqlDbType.NVarChar, txtName.Text.Trim(), clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("MobileNo", SqlDbType.VarChar, txtMobileNo.Text, clsConnection_DAL.ParamType.Input);
if (radMale.Checked)
{
ObjDAL.SetStoreProcedureData("Gender", SqlDbType.Bit, true, clsConnection_DAL.ParamType.Input);
}
else if (radFemale.Checked)
{
ObjDAL.SetStoreProcedureData("Gender", SqlDbType.Bit, false, clsConnection_DAL.ParamType.Input);
}
if (dtpDOB.Checked)
{
ObjDAL.SetStoreProcedureData("DOB", SqlDbType.DateTime, dtpDOB.Value.ToString("yyyy-MM-dd"), clsConnection_DAL.ParamType.Input);
}
else
{
ObjDAL.SetStoreProcedureData("DOB", SqlDbType.DateTime, null, clsConnection_DAL.ParamType.Input);
}
ObjDAL.SetStoreProcedureData("Address", SqlDbType.NVarChar, txtAdd.Text.Trim(), clsConnection_DAL.ParamType.Input);
if (PicEmployee.Image != null)
{
ObjDAL.SetStoreProcedureData("Photo", SqlDbType.VarBinary, ObjUtil.GetImageBytes(PicEmployee.Image), clsConnection_DAL.ParamType.Input);
}
ObjDAL.SetStoreProcedureData("CreatedBy", SqlDbType.Int, clsUtility.LoginID, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("EMPID", SqlDbType.Int, 0, clsConnection_DAL.ParamType.Output);
bool b = ObjDAL.ExecuteStoreProcedure_DML(clsUtility.DBName + ".dbo.SPR_Insert_Employee");
if (b)
{
DataTable dt = ObjDAL.GetOutputParmData();
if (ObjUtil.ValidateTable(dt))
{
EmployeeID = Convert.ToInt32(dt.Rows[0][1]);
}
ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterSave);
clsUtility.ShowInfoMessage("Employee has been added Successfully.", clsUtility.strProjectTitle);
if (txtUsername.Text.Trim().Length != 0 && txtPass.Text.Trim().Length != 0)
{
CreateNewUser(EmployeeID);
}
ClearAll();
LoadData();
grpEmployee.Enabled = false;
}
else
{
clsUtility.ShowInfoMessage("Failed to add the Employee.", clsUtility.strProjectTitle);
ObjDAL.ResetData();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (clsFormRights.HasFormRight(clsFormRights.Forms.Delivering_Purchase_Bill, clsFormRights.Operation.Save) || clsUtility.IsAdmin)
{
if (Validateform())
{
if (DuplicateUser(0))
{
int DeliveryPurchaseBillID = 0;
ObjDAL.SetColumnData("PurchaseInvoiceID", SqlDbType.Int, pPurchaseInvoiceID);
ObjDAL.SetColumnData("SupplierBillNo", SqlDbType.NVarChar, txtSupplierBillNo.Text.Trim());
ObjDAL.SetColumnData("SizeTypeID", SqlDbType.Int, cmbSizeType.SelectedValue);
ObjDAL.SetColumnData("ModelNo", SqlDbType.NVarChar, cmbListBox.Text);
//ObjDAL.SetColumnData("ModelNo", SqlDbType.NVarChar, listBoxStyleNo.SelectedItem);
ObjDAL.SetColumnData("ProductID", SqlDbType.Int, ProductID);
ObjDAL.SetColumnData("SubProductID", SqlDbType.Int, SubProductID);
ObjDAL.SetColumnData("StoreID", SqlDbType.Int, cmbStore.SelectedValue);
ObjDAL.SetColumnData("CreatedBy", SqlDbType.Int, clsUtility.LoginID); //if LoginID=0 then Test Admin else user
DeliveryPurchaseBillID = ObjDAL.InsertData(clsUtility.DBName + ".dbo.DeliveryPurchaseBill1", true);
if (DeliveryPurchaseBillID > 0)
{
int DeliveryPurchaseBillID2 = DataSavedDeliveryPurchaseBill2(DeliveryPurchaseBillID);
int DeliveryPurchaseBillID3 = DataSavedDeliveryPurchaseBill3(DeliveryPurchaseBillID, DeliveryPurchaseBillID2);
if (DeliveryPurchaseBillID2 > 0 && DeliveryPurchaseBillID3 > 0)
{
ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterSave);
clsUtility.ShowInfoMessage(clsUtility.MsgDataSaved, clsUtility.strProjectTitle);
}
else
{
ObjDAL.SetStoreProcedureData("PurchaseInvoiceID", SqlDbType.Int, pPurchaseInvoiceID, clsConnection_DAL.ParamType.Input);
ObjDAL.ExecuteStoreProcedure_DML(clsUtility.DBName + ".dbo.SPR_Delete_Delivering_PurchaseBill");
clsUtility.ShowInfoMessage(clsUtility.MsgDatanotSaved, clsUtility.strProjectTitle);
}
LoadData(); // Added
LoadModelData();
Clear_ColorSize();
txtSupplierBillNo.Enabled = false;
btnSearch.Enabled = false;
object qty = dtPurchaseInvoice.Compute("SUM(QTY)", null);
txtTotalQTY.Text = qty.ToString();
//grpPurchaseBillDetail.Enabled = false;
}
else
{
clsUtility.ShowInfoMessage(clsUtility.MsgDatanotSaved, clsUtility.strProjectTitle);
}
ObjDAL.ResetData();
}
else
{
clsUtility.ShowErrorMessage("Purchase Invoice '" + txtSupplierBillNo.Text + "' is already exist..", clsUtility.strProjectTitle);
txtSupplierBillNo.Focus();
}
}
}
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 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);
}
}
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 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("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 btnSave_Click(object sender, EventArgs e)
{
if (clsFormRights.HasFormRight(clsFormRights.Forms.Customer_Master, clsFormRights.Operation.Save) || clsUtility.IsAdmin)
{
if (ValidateForm())
{
if (DuplicateUser(0))
{
ObjDAL.SetStoreProcedureData("Name", SqlDbType.NVarChar, txtCustomerName.Text.Trim(), clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("Address", SqlDbType.NVarChar, txtCustomerAddress.Text.Trim(), clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("PhoneNo", SqlDbType.NVarChar, txtCustomerMobileNo.Text.Trim(), clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("EmailID", SqlDbType.NVarChar, txtCustomerEmailID.Text.Trim(), clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("ActiveStatus", SqlDbType.Bit, cmbCustomerActiveStatus.SelectedItem.ToString() == "Active" ? 1 : 0, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("CreatedBy", SqlDbType.Int, clsUtility.LoginID, clsConnection_DAL.ParamType.Input);
bool b = ObjDAL.ExecuteStoreProcedure_DML(clsUtility.DBName + ".dbo.SPR_Insert_Customer");
if (b)
{
//ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterSave, clsUtility.IsAdmin);
ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterSave);
clsUtility.ShowInfoMessage("Customer Name : '" + txtCustomerName.Text + "' is Saved Successfully..", clsUtility.strProjectTitle);
ClearAll();
LoadData();
grpCustomer.Enabled = false;
}
else
{
clsUtility.ShowInfoMessage("Customer Name : '" + txtCustomerName.Text + "' is not Saved Successfully..", clsUtility.strProjectTitle);
}
}
else
{
clsUtility.ShowErrorMessage("'" + txtCustomerName.Text + "' Customer is already exist..", clsUtility.strProjectTitle);
txtCustomerName.Focus();
}
ObjDAL.ResetData();
}
}
else
{
clsUtility.ShowInfoMessage("You have no rights to perform this task", clsUtility.strProjectTitle);
}
}