private void btnSave_Click(object sender, EventArgs e)
{
if (ValidateForm())
{
int a = 0;
for (int i = 0; i < dtSize.Rows.Count; i++)
{
ObjDAL.SetColumnData("Size", SqlDbType.VarChar, dtSize.Rows[i]["Size"].ToString());
ObjDAL.SetColumnData("ActiveStatus", SqlDbType.Bit, Convert.ToInt32(dtSize.Rows[i]["ActiveStatus"]));
ObjDAL.SetColumnData("SizeTypeID", SqlDbType.Int, Convert.ToInt32(dtSize.Rows[i]["SizeTypeID"]));
ObjDAL.SetColumnData("CreatedBy", SqlDbType.Int, clsUtility.LoginID); //if LoginID=0 then Test Admin else user
a = ObjDAL.InsertData(clsUtility.DBName + ".dbo.SizeMaster", true);
}
if (a > 0)
{
//ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterSave, clsUtility.IsAdmin);
ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterSave);
clsUtility.ShowInfoMessage(clsUtility.MsgDataSaved, clsUtility.strProjectTitle);
ClearAll();
LoadData();
grpSizeType.Enabled = false;
btnAddMore.Enabled = false;
}
else
{
clsUtility.ShowInfoMessage(clsUtility.MsgDatanotSaved, clsUtility.strProjectTitle);
ObjDAL.ResetData();
}
}
}
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 btnSave_Click(object sender, EventArgs e)
{
if (ValidateForm())
{
if (DuplicateUser(0))
{
ObjDAL.SetColumnData("Name", SqlDbType.NVarChar, txtCustomerName.Text.Trim());
ObjDAL.SetColumnData("Address", SqlDbType.NVarChar, txtCustomerAddress.Text.Trim());
ObjDAL.SetColumnData("PhoneNo", SqlDbType.NVarChar, txtCustomerPhoneNo.Text.Trim());
ObjDAL.SetColumnData("ActiveStatus", SqlDbType.Bit, cmbCustomerActiveStatus.SelectedItem.ToString() == "Active" ? 1 : 0);
ObjDAL.SetColumnData("CreatedBy", SqlDbType.Int, clsUtility.LoginID); //if LoginID=0 then Test Admin else user
if (ObjDAL.InsertData(clsUtility.DBName + ".dbo.CustomerMaster", true) > 0)
{
//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();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (Validateform())
{
if (DuplicateUser(0))
{
ObjDAL.SetColumnData("CountryID", SqlDbType.Int, cmbCountry.SelectedValue);
ObjDAL.SetColumnData("CurrencyCode", SqlDbType.NVarChar, txtCurrencyCode.Text);
ObjDAL.SetColumnData("CurrencyName", SqlDbType.NVarChar, txtCurrencyName.Text);
ObjDAL.SetColumnData("CurrencyRate", SqlDbType.Decimal, txtCurrencyRate.Text);
ObjDAL.SetColumnData("CreatedBy", SqlDbType.Int, clsUtility.LoginID); //if LoginID=0 then Test Admin else user
if (ObjDAL.InsertData(clsUtility.DBName + ".dbo.CurrencyRateSetting", true) > 0)
{
ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterSave, clsUtility.IsAdmin);
clsUtility.ShowInfoMessage("Currency Rate for '" + cmbCountry.Text + "' is Saved Successfully..", clsUtility.strProjectTitle);
ClearAll();
LoadData();
grpCurrencyValue.Enabled = false;
}
else
{
clsUtility.ShowInfoMessage("Currency Rate for '" + cmbCountry.Text + "' is not Saved Successfully..", clsUtility.strProjectTitle);
}
}
else
{
clsUtility.ShowErrorMessage("Currency Rate for '" + cmbCountry.Text + "' is already exist..", clsUtility.strProjectTitle);
cmbCountry.Focus();
}
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 btnSave_Click(object sender, EventArgs e)
{
if (Validateform())
{
if (DuplicateUser(0))
{
ObjDAL.SetColumnData("SizeTypeName", SqlDbType.NVarChar, txtSizeTypeName.Text.Trim());
//if (cmbDepartment.SelectedIndex >= 0)
//{
ObjDAL.SetColumnData("CategoryID", SqlDbType.Int, cmbDepartment.SelectedValue);
//}
ObjDAL.SetColumnData("ActiveStatus", SqlDbType.Bit, cmbActiveStatus.SelectedItem.ToString() == "Active" ? 1 : 0);
ObjDAL.SetColumnData("CreatedBy", SqlDbType.Int, clsUtility.LoginID); //if LoginID=0 then Test Admin else user
if (ObjDAL.InsertData(clsUtility.DBName + ".dbo.SizeTypeMaster", true) > 0)
{
//ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterSave, clsUtility.IsAdmin);
ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterSave);
clsUtility.ShowInfoMessage("Size Type Name : '" + txtSizeTypeName.Text + "' is Saved Successfully..", clsUtility.strProjectTitle);
ClearAll();
LoadData();
grpSizeTypeDetails.Enabled = false;
}
else
{
clsUtility.ShowInfoMessage("Size Type Name : '" + txtSizeTypeName.Text + "' is not Saved Successfully..", clsUtility.strProjectTitle);
}
ObjDAL.ResetData();
}
else
{
clsUtility.ShowErrorMessage("'" + txtSizeTypeName.Text + "' Size Type is already exist..", clsUtility.strProjectTitle);
txtSizeTypeName.Focus();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (clsFormRights.HasFormRight(clsFormRights.Forms.Purchase_Invoice, clsFormRights.Operation.Save) || clsUtility.IsAdmin)
{
if (Validateform())
{
if (DuplicateUser(0))
{
ObjDAL.SetColumnData("SupplierBillNo", SqlDbType.NVarChar, txtSupplierBillNo.Text.Trim());
ObjDAL.SetColumnData("ShipmentNo", SqlDbType.NVarChar, txtShipmentNo.Text.Trim());
ObjDAL.SetColumnData("BillValue", SqlDbType.Decimal, txtBillValue.Text.Trim());
ObjDAL.SetColumnData("TotalQTY", SqlDbType.Int, txtTotalQTY.Text.Trim());
ObjDAL.SetColumnData("SupplierID", SqlDbType.Int, cmbSupplier.SelectedValue);
ObjDAL.SetColumnData("BillDate", SqlDbType.Date, dtpBillDate.Value.ToString("yyyy-MM-dd"));
ObjDAL.SetColumnData("Discount", SqlDbType.Decimal, txtForeignDiscount.Text.Length > 0 ? Convert.ToDecimal(txtForeignDiscount.Text) : 0);
ObjDAL.SetColumnData("ForeignExp", SqlDbType.Decimal, txtForeignExp.Text.Length > 0 ? Convert.ToDecimal(txtForeignExp.Text) : 0);
ObjDAL.SetColumnData("GrandTotal", SqlDbType.Decimal, txtNetValue.Text.Trim());
ObjDAL.SetColumnData("LocalValue", SqlDbType.Decimal, txtLocalValue.Text.Trim());
ObjDAL.SetColumnData("LocalExp", SqlDbType.Decimal, txtLocalExp.Text.Length > 0 ? Convert.ToDecimal(txtLocalExp.Text) : 0);
ObjDAL.SetColumnData("LocalBillValue", SqlDbType.Decimal, txtLocalBillValue.Text.Trim());
ObjDAL.SetColumnData("CreatedBy", SqlDbType.Int, clsUtility.LoginID); //if LoginID=0 then Test Admin else user
if (ObjDAL.InsertData(clsUtility.DBName + ".dbo.PurchaseInvoice", true) > 0)
{
//ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterSave, clsUtility.IsAdmin);
ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterSave);
clsUtility.ShowInfoMessage("Purchase Invoice for '" + cmbSupplier.Text + "' is Saved Successfully..", clsUtility.strProjectTitle);
ClearAll();
LoadData();
grpPurchaseInvoice.Enabled = false;
grpForeignCurrency.Enabled = false;
grpLocalCurrency.Enabled = false;
}
else
{
clsUtility.ShowInfoMessage("Purchase Invoice for '" + cmbSupplier.Text + "' is not Saved Successfully..", clsUtility.strProjectTitle);
}
}
else
{
clsUtility.ShowErrorMessage("Purchase Invoice for '" + cmbSupplier.Text + "' is already exist..", clsUtility.strProjectTitle);
cmbSupplier.Focus();
}
ObjDAL.ResetData();
}
}
else
{
clsUtility.ShowInfoMessage("You have no rights to perform this task", clsUtility.strProjectTitle);
}
}
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, listBoxModelNo.SelectedItem);
ObjDAL.SetColumnData("ProductID", SqlDbType.Int, ProductID);
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);
//ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterSave, clsUtility.IsAdmin);
ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterSave);
clsUtility.ShowInfoMessage(clsUtility.MsgDataSaved, clsUtility.strProjectTitle);
Clear_ColorSize();
//LoadData();
LoadModelData();
txtSupplierBillNo.Enabled = false;
btnSearch.Enabled = false;
//grpPurchaseBillDetail.Enabled = false;
}
else
{
clsUtility.ShowInfoMessage(clsUtility.MsgDatanotSaved, clsUtility.strProjectTitle);
ObjDAL.ResetData();
}
}
else
{
clsUtility.ShowErrorMessage("Purchase Invoice '" + txtSupplierBillNo.Text + "' is already exist..", clsUtility.strProjectTitle);
ObjDAL.ResetData();
txtSupplierBillNo.Focus();
}
}
}
else
{
clsUtility.ShowInfoMessage("You have no rights to perform this task", clsUtility.strProjectTitle);
}
}
private void btnSaveData_Click(object sender, EventArgs e)
{
if (StoreBillDetailsID > 0)
{
ObjDAL.SetStoreProcedureData("ReceiveBillNo", SqlDbType.NVarChar, GenerateReceiveBillNumber(), clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("StoreBillDetailsID", SqlDbType.Int, StoreBillDetailsID, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("StoreID", SqlDbType.Int, frmHome.Home_StoreID, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("CreatedBy", SqlDbType.Int, clsUtility.LoginID, clsConnection_DAL.ParamType.Input);
DataSet ds = ObjDAL.ExecuteStoreProcedure_Get(clsUtility.DBName + ".dbo.SPR_Insert_ReceiveBillDetails");
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
if (ObjUtil.ValidateTable(dt))
{
if (Convert.ToInt32(dt.Rows[0]["Flag"]) == 1)
{
StoreBillDetailsID = 0;
LoadData();
}
clsUtility.ShowInfoMessage(dt.Rows[0]["Msg"].ToString(), clsUtility.strProjectTitle);
}
}
}
else
{
clsUtility.ShowInfoMessage("There is no Update found for Receive Bill details.", clsUtility.strProjectTitle);
}
ObjDAL.ResetData();
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (clsFormRights.HasFormRight(clsFormRights.Forms.frmOtherSetting, clsFormRights.Operation.Delete) || clsUtility.IsAdmin)
{
DialogResult d = MessageBox.Show("Are you sure want to delete '" + cmbSelectPC.Text + "' Machine ", clsUtility.strProjectTitle, MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (d == DialogResult.Yes)
{
if (ObjDAL.DeleteData(clsUtility.DBName + ".dbo.tblPC_Store_Mapping", "PC_Store_ID = " + ID) > 0)
{
clsUtility.ShowInfoMessage("'" + cmbSelectPC.Text + "' Machine has been deleted ", clsUtility.strProjectTitle);
ClearAll();
LoadData();
groupBox1.Enabled = false;
ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterDelete);
}
else
{
clsUtility.ShowErrorMessage("'" + cmbSelectPC.Text + "' Machine is not deleted ", clsUtility.strProjectTitle);
ObjDAL.ResetData();
}
}
}
else
{
clsUtility.ShowInfoMessage("You have no rights to perform this task", clsUtility.strProjectTitle);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (Validateform())
{
if (DuplicateUser(ID))
{
string pass = ObjUtil.Encrypt(txtPassword.Text, true);
ObjDAL.UpdateColumnData("UserName", SqlDbType.NVarChar, txtUserName.Text);
ObjDAL.UpdateColumnData("Password", SqlDbType.NVarChar, pass);
ObjDAL.UpdateColumnData("EmailID", SqlDbType.VarChar, txtEmail.Text);
ObjDAL.UpdateColumnData("SecurityQuestion", SqlDbType.NVarChar, cmbSecurity.SelectedItem.ToString());
ObjDAL.UpdateColumnData("Answer", SqlDbType.NVarChar, ObjUtil.Encrypt(txtAsnwer.Text.Trim(), true));
ObjDAL.UpdateColumnData("IsAdmin", SqlDbType.Bit, rdAdmin.Checked == true ? 1 : 0);
ObjDAL.UpdateColumnData("ActiveStatus", SqlDbType.Bit, rdActive.Checked == true ? 1 : 0);
if (rdAdmin.Checked == false)
{
admin = false;
clsUtility.IsAdmin = admin;
}
if (UserName != txtUserName.Text.Trim() || txtVerifyPassword.Text.Trim() != ObjUtil.Decrypt(pass, true) || rdAdmin.Checked || rdLimitedUser.Checked)
{
ObjDAL.UpdateColumnData("UpdatedOn", SqlDbType.DateTime, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
ObjDAL.UpdateColumnData("UpdatedBy", SqlDbType.Int, LogID); //if LogID=0 then Test Admin else user
}
if (ObjDAL.UpdateData(DBName + ".dbo.UserManagement", "UserID=" + ID) > 0)
{
ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterUpdate, admin);
LoadData();
ClearAll();
EnableDisable(false);
clsUtility.ShowInfoMessage("'" + UserName + "' user is Updated", clsUtility.strProjectTitle);
}
else
{
clsUtility.ShowErrorMessage("'" + UserName + "' user is not Updated", clsUtility.strProjectTitle);
}
ObjDAL.ResetData();
}
else
{
clsUtility.ShowErrorMessage("'" + txtUserName.Text + "' UserName OR EmailID is already exist..", clsUtility.strProjectTitle);
txtUserName.Focus();
}
}
}
private void InsertComapnyMasterTable()
{
ObjDAL.SetColumnData("CompanyName", SqlDbType.NVarChar, txtOrganisation.Text.Trim());
ObjDAL.SetColumnData("Address", SqlDbType.NVarChar, txtAddress.Text.Trim());
ObjDAL.SetColumnData("MobileNo", SqlDbType.NVarChar, txtMobileNo.Text.Trim());
ObjDAL.SetColumnData("EmailID", SqlDbType.NVarChar, txtEmail.Text.Trim());
ObjDAL.InsertData(clsUtility.DBName + ".dbo.CompanyMaster", false);
ObjDAL.ResetData();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (clsFormRights.HasFormRight(clsFormRights.Forms.Supplier_Details, clsFormRights.Operation.Save) || clsUtility.IsAdmin)
{
if (Validateform())
{
if (DuplicateUser(0))
{
ObjDAL.SetColumnData("SupplierName", SqlDbType.NVarChar, txtSupplierName.Text.Trim());
ObjDAL.SetColumnData("CountryID", SqlDbType.Int, cmbCountry.SelectedValue);
ObjDAL.SetColumnData("Phone", SqlDbType.VarChar, txtPhone.Text.Trim());
ObjDAL.SetColumnData("EmailID", SqlDbType.VarChar, txtEmail.Text.Trim());
ObjDAL.SetColumnData("BankName", SqlDbType.NVarChar, txtBankName.Text.Trim());
ObjDAL.SetColumnData("BankAccountNo", SqlDbType.VarChar, txtBankAccNo.Text.Trim());
ObjDAL.SetColumnData("BankAddress", SqlDbType.NVarChar, txtBankAdd.Text.Trim());
ObjDAL.SetColumnData("ActiveStatus", SqlDbType.Bit, cmbActiveStatus.SelectedItem.ToString() == "Active" ? 1 : 0);
ObjDAL.SetColumnData("CreatedBy", SqlDbType.Int, clsUtility.LoginID); //if LoginID=0 then Test Admin else user
if (ObjDAL.InsertData(clsUtility.DBName + ".dbo.SupplierMaster", true) > 0)
{
ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterSave);
clsUtility.ShowInfoMessage("Supplier Name : '" + txtSupplierName.Text + "' is Saved Successfully..", clsUtility.strProjectTitle);
ClearAll();
LoadData();
grpSupplier.Enabled = false;
}
else
{
clsUtility.ShowInfoMessage("Supplier : '" + txtSupplierName.Text + "' is not Saved Successfully..", clsUtility.strProjectTitle);
}
ObjDAL.ResetData();
}
else
{
clsUtility.ShowErrorMessage("'" + txtSupplierName.Text + "' Supplier is already exist..", clsUtility.strProjectTitle);
txtSupplierName.Focus();
}
}
}
else
{
clsUtility.ShowInfoMessage("You have no rights to perform this task", clsUtility.strProjectTitle);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (clsFormRights.HasFormRight(clsFormRights.Forms.Store_Master, clsFormRights.Operation.Save) || clsUtility.IsAdmin)
{
if (Validateform())
{
if (DuplicateUser(0))
{
ObjDAL.SetColumnData("StoreName", SqlDbType.NVarChar, txtStoreName.Text.Trim());
ObjDAL.SetColumnData("Tel", SqlDbType.VarChar, txtTel.Text.Trim());
ObjDAL.SetColumnData("Fax", SqlDbType.VarChar, txtFax.Text.Trim());
ObjDAL.SetColumnData("Place", SqlDbType.NVarChar, txtPlace.Text.Trim());
ObjDAL.SetColumnData("StoreCategory", SqlDbType.Int, cmbStoreCat.SelectedIndex);
ObjDAL.SetColumnData("ActiveStatus", SqlDbType.Bit, cmbActiveStatus.SelectedItem.ToString() == "Active" ? 1 : 0);
ObjDAL.SetColumnData("CreatedBy", SqlDbType.Int, clsUtility.LoginID); //if LoginID=0 then Test Admin else user
if (ObjDAL.InsertData(clsUtility.DBName + ".dbo.StoreMaster", true) > 0)
{
//ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterSave, clsUtility.IsAdmin);
ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterSave);
clsUtility.ShowInfoMessage("Store : '" + txtStoreName.Text + "' is Saved Successfully..", clsUtility.strProjectTitle);
ClearAll();
LoadData();
grpStore.Enabled = false;
}
else
{
clsUtility.ShowInfoMessage("Store : '" + txtStoreName.Text + "' is not Saved Successfully..", clsUtility.strProjectTitle);
}
}
else
{
clsUtility.ShowErrorMessage("Store : '" + txtStoreName.Text + "' is already exist..", clsUtility.strProjectTitle);
txtStoreName.Focus();
}
ObjDAL.ResetData();
}
}
else
{
clsUtility.ShowInfoMessage("You have no rights to perform this task", 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);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (clsFormRights.HasFormRight(clsFormRights.Forms.Brand_Master, clsFormRights.Operation.Save) || clsUtility.IsAdmin)
{
if (Validateform())
{
if (DuplicateUser(0))
{
ObjDAL.SetColumnData("CashBand", SqlDbType.Decimal, txtCashBand.Text.Trim());
ObjDAL.SetColumnData("ActiveStatus", SqlDbType.Bit, cmbActiveStatus.SelectedItem.ToString() == "Active" ? 1 : 0);
ObjDAL.SetColumnData("CreatedBy", SqlDbType.Int, clsUtility.LoginID); //if LoginID=0 then Test Admin else user
if (ObjDAL.InsertData(clsUtility.DBName + ".dbo.tblCloseCashBandMaster", true) > 0)
{
//ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterSave, clsUtility.IsAdmin);
ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterSave);
clsUtility.ShowInfoMessage("CashBand : '" + txtCashBand.Text + "' is Saved Successfully..", clsUtility.strProjectTitle);
ClearAll();
LoadData();
grpClosingBALMaster.Enabled = false;
}
else
{
clsUtility.ShowInfoMessage("CashBand Name : '" + txtCashBand.Text + "' is not Saved Successfully..", clsUtility.strProjectTitle);
ObjDAL.ResetData();
}
}
else
{
clsUtility.ShowErrorMessage("'" + txtCashBand.Text + "' CashBand is already exist..", clsUtility.strProjectTitle);
ObjDAL.ResetData();
txtCashBand.Focus();
}
}
}
else
{
clsUtility.ShowInfoMessage("You have no rights to perform this task", clsUtility.strProjectTitle);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (Validateform())
{
ObjDAL.SetStoreProcedureData("PettyCashAmt", SqlDbType.Decimal, txtPettyCash.Text, clsConnection_DAL.ParamType.Input);
ObjDAL.SetStoreProcedureData("StoreID", SqlDbType.Int, frmHome.Home_StoreID, 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_PettyCashAmt");
if (b)
{
clsUtility.ShowInfoMessage("Petty Cash book Saved Successfully..", clsUtility.strProjectTitle);
ClearAll();
LoadData();
}
else
{
clsUtility.ShowInfoMessage("Petty Cash book not Saved Successfully..", clsUtility.strProjectTitle);
}
ObjDAL.ResetData();
}
}
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 InsertClientRegistration()
{
//clsConnection_DAL ObjDAL = new clsConnection_DAL(true);
DataTable dt = ObjDAL.GetDataCol(ClientDBName + ".dbo.RegistrationDetails", "[SoftKey],[ExpiryDate],[StatusDate]", "ISNULL([IsServer],0) = 1 AND ISNULL([IsKeyEnter],0) = 1", null);
if (ObjUtil.ValidateTable(dt))
{
ObjDAL.SetColumnData("PcName", SqlDbType.NVarChar, Environment.MachineName);
ObjDAL.SetColumnData("StatusDate", SqlDbType.VarChar, dt.Rows[0]["StatusDate"].ToString());
ObjDAL.SetColumnData("SoftKey", SqlDbType.VarChar, dt.Rows[0]["SoftKey"].ToString());
ObjDAL.SetColumnData("IsTrail", SqlDbType.Bit, 0);
ObjDAL.SetColumnData("RegDate", SqlDbType.Date, DateTime.Now);
ObjDAL.SetColumnData("ExpiryDate", SqlDbType.VarChar, dt.Rows[0]["ExpiryDate"].ToString());
ObjDAL.SetColumnData("IsKeyEnter", SqlDbType.Bit, 1);
if (ObjDAL.InsertData(ClientDBName + ".dbo.RegistrationDetails", true) > 0)
{
ObjDAL.ResetData();
clsUtility.ShowInfoMessage("Client Registration is successfully", clsUtility.strProjectTitle);
//System.Diagnostics.Process.Start(exeName + ".exe");
Application.Exit();
}
}
}
private void CreateNewUser(int EmployeeID)
{
ObjDAL.SetColumnData("UserName", SqlDbType.NVarChar, txtUsername.Text.Trim());
ObjDAL.SetColumnData("Password", SqlDbType.NVarChar, ObjUtil.Encrypt(txtPass.Text.Trim(), true));
ObjDAL.SetColumnData("EmailID", SqlDbType.NVarChar, txtEmail.Text.Trim());
ObjDAL.SetColumnData("IsAdmin", SqlDbType.Bit, false);
ObjDAL.SetColumnData("IsBlock", SqlDbType.Bit, false);
ObjDAL.SetColumnData("EmployeeID", SqlDbType.Int, EmployeeID);
if (ObjDAL.InsertData(clsUtility.DBName + ".dbo.UserManagement", true) > 0)
{
ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterSave, clsUtility.IsAdmin);
clsUtility.ShowInfoMessage("User has been added Successfully.", clsUtility.strProjectTitle);
ClearAll();
LoadData();
grpEmployee.Enabled = false;
}
else
{
clsUtility.ShowInfoMessage("Failed to add the User.", clsUtility.strProjectTitle);
ObjDAL.ResetData();
}
}
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 btnSave_Click(object sender, EventArgs e)
{
if (Validateform())
{
if (DuplicateUser(0))
{
ObjDAL.SetColumnData("ProductName", SqlDbType.NVarChar, txtProductName.Text.Trim());
ObjDAL.SetColumnData("CategoryID", SqlDbType.Int, cmbCategory.SelectedValue);
ObjDAL.SetColumnData("ActiveStatus", SqlDbType.Bit, cmbActiveStatus.SelectedItem.ToString() == "Active" ? 1 : 0);
ObjDAL.SetColumnData("CreatedBy", SqlDbType.Int, clsUtility.LoginID); //if LoginID=0 then Test Admin else user
if (PicProductMaster.Image != null)
{
ObjDAL.SetColumnData("Photo", SqlDbType.VarBinary, ObjUtil.GetImageBytes(PicProductMaster.Image));
}
if (ObjDAL.InsertData(clsUtility.DBName + ".dbo.ProductMaster", true) > 0)
{
//ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterSave, clsUtility.IsAdmin);
ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterSave);
clsUtility.ShowInfoMessage("Product Name : '" + txtProductName.Text + "' is Saved Successfully..", clsUtility.strProjectTitle);
ClearAll();
LoadData();
grpProduct.Enabled = false;
}
else
{
clsUtility.ShowInfoMessage("Product Name : '" + txtProductName.Text + "' is not Saved Successfully..", clsUtility.strProjectTitle);
ObjDAL.ResetData();
}
}
else
{
clsUtility.ShowErrorMessage("'" + txtProductName.Text + "' Product is already exist..", clsUtility.strProjectTitle);
ObjDAL.ResetData();
txtProductName.Focus();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (clsFormRights.HasFormRight(clsFormRights.Forms.Purchase_Bill_Details, clsFormRights.Operation.Save) || clsUtility.IsAdmin)
{
DataTable dtPurchaseInvoiceBill = (DataTable)dataGridView1.DataSource;
if (ObjUtil.ValidateTable(dtPurchaseInvoiceBill))
{
int _ID = 0;
bool b = false;
for (int i = 0; i < dtPurchaseInvoiceBill.Rows.Count; i++)
{
_ID = 0;
ObjDAL.SetColumnData("PurchaseInvoiceID", SqlDbType.Int, PurchaseInvoiceID);
ObjDAL.SetColumnData("SupplierBillNo", SqlDbType.NVarChar, txtSupplierBillNo.Text.Trim());
ObjDAL.SetColumnData("SupplierID", SqlDbType.Int, cmbSupplier.SelectedValue);
ObjDAL.SetColumnData("BillDate", SqlDbType.Date, dtpBillDate.Value.ToString("yyyy-MM-dd"));
ObjDAL.SetColumnData("CreatedBy", SqlDbType.Int, clsUtility.LoginID); //if LoginID=0 then Test Admin else user
_ProductID = Convert.ToInt32(dtPurchaseInvoiceBill.Rows[i]["ProductID"]);
ObjDAL.SetColumnData("ProductID", SqlDbType.Int, _ProductID);
ObjDAL.SetColumnData("ModelNo", SqlDbType.NVarChar, dtPurchaseInvoiceBill.Rows[i]["ModelNo"].ToString());
ObjDAL.SetColumnData("BrandID", SqlDbType.Int, dtPurchaseInvoiceBill.Rows[i]["BrandID"].ToString());
_QTY = Convert.ToInt32(dtPurchaseInvoiceBill.Rows[i]["QTY"]);
ObjDAL.SetColumnData("QTY", SqlDbType.Int, _QTY);
ObjDAL.SetColumnData("Rate", SqlDbType.Decimal, dtPurchaseInvoiceBill.Rows[i]["Rate"].ToString());
ObjDAL.SetColumnData("Sales_Price", SqlDbType.Decimal, dtPurchaseInvoiceBill.Rows[i]["EndUser"].ToString());
ObjDAL.SetColumnData("AddedRatio", SqlDbType.Int, dtPurchaseInvoiceBill.Rows[i]["AddedRatio"].ToString());
ObjDAL.SetColumnData("SuppossedPrice", SqlDbType.Decimal, dtPurchaseInvoiceBill.Rows[i]["SuppossedPrice"].ToString());
_ID = ObjDAL.InsertData(clsUtility.DBName + ".dbo.PurchaseInvoiceDetails", true);
//Updating Sales price in Product Master table for sales window
ObjDAL.UpdateColumnData("Rate", SqlDbType.Decimal, dtPurchaseInvoiceBill.Rows[i]["EndUser"]);
ObjDAL.UpdateData(clsUtility.DBName + ".dbo.ProductMaster", "ProductID = " + _ProductID + "");
}
if (_ID > 0)
{
//ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterSave, clsUtility.IsAdmin);
ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterSave);
if (txtDiffQty.Text == "0" && txtDiffValue.Text == "0")
{
clsUtility.ShowInfoMessage("Purchase Invoice is Saved Successfully..", clsUtility.strProjectTitle);
}
ClearAll();
grpPurchaseBillDetail.Enabled = false;
}
else
{
clsUtility.ShowInfoMessage("Purchase Invoice is not Saved Successfully..", clsUtility.strProjectTitle);
}
ObjDAL.ResetData();
}
else
{
//ObjDAL.UpdateColumnData("SupplierBillNo", SqlDbType.VarChar, txtSupplierBillNo.Text.Trim());
//ObjDAL.UpdateColumnData("ProductID", SqlDbType.Int, txtProductID.Text.Trim());
//ObjDAL.UpdateColumnData("ModelNo", SqlDbType.NVarChar, txtModelNo.Text.Trim());
//ObjDAL.UpdateColumnData("BrandID", SqlDbType.Int, cmbBrand.SelectedValue);
//ObjDAL.UpdateColumnData("QTY", SqlDbType.Int, txtQTY.Text);
//ObjDAL.UpdateColumnData("Rate", SqlDbType.Decimal, txtRate.Text.Trim());
//ObjDAL.UpdateColumnData("UpdatedBy", SqlDbType.Int, clsUtility.LoginID); //if LoginID=0 then Test
//ObjDAL.UpdateColumnData("UpdatedOn", SqlDbType.DateTime, DateTime.Now);
//if (ObjDAL.UpdateData(clsUtility.DBName + ".dbo.PurchaseInvoiceDetails", "PurchaseInvoiceID = " + PurchaseInvoiceID + "") > 0)
//{
// ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterUpdate, clsUtility.IsAdmin);
// ObjUtil.SetCommandButtonStatus(clsCommon.ButtonStatus.AfterUpdate);
// clsUtility.ShowInfoMessage("Purchase Invoice for '" + cmbSupplier.SelectedItem + "' is Updated", clsUtility.strProjectTitle);
// ClearAll();
// grpPurchaseBillDetail.Enabled = false;
// ObjDAL.ResetData();
//}
//else
//{
// clsUtility.ShowInfoMessage("Purchase Invoice for '" + cmbSupplier.SelectedItem + "' is not Updated", clsUtility.strProjectTitle);
// ObjDAL.ResetData();
//}
}
}
else
{
clsUtility.ShowInfoMessage("You have no rights to perform this task", clsUtility.strProjectTitle);
}
dataGridView1.DataSource = dtPurchaseInvoice;
}
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);
}
}
