public void BindPurchaseItemGroup()
{
try
{
clsCategoryMaster objLoad = new clsCategoryMaster();
objLoad.Mode = "PurchaseItemGroup";
objLoad.CompanyID = cId;
var ds = objLoad.GetAllCategory();
DataTable dt = ds.Tables[0];
DataRow dr = dt.NewRow();
dr["CategoryMasterCatKey"] = "0";
dr["CategoryMasterCatVal"] = "Please Select PurchaseItem Group";
dt.Rows.InsertAt(dr, 0);
//DataRow dr = dt.NewRow();
/* Bind the PurchaseItem Group */
cmbPurchaseItemGroup.DataSource = dt;
cmbPurchaseItemGroup.DisplayMember = "CategoryMasterCatVal";
cmbPurchaseItemGroup.ValueMember = "CategoryMasterCatKey";
cmbPurchaseItemGroup.Text = "Please Select PurchaseItem Group";
/* Bind the PurchaseItem Group */
/* Bind the Search PurchaseItem Group */
cmbSearchPurchaseItemGroup.DataSource = dt;
cmbSearchPurchaseItemGroup.DisplayMember = "CategoryMasterCatVal";
cmbSearchPurchaseItemGroup.ValueMember = "CategoryMasterCatKey";
cmbSearchPurchaseItemGroup.Text = "Please Select PurchaseItem Group";
/* Bind the Search PurchaseItem Group */
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "BindPurchaseItemGroup", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void SaveFormData(String mode)
{
try
{
clsCategoryMaster objSave = new clsCategoryMaster();
objSave.CategoryMasterCatKey = Convert.ToInt32(txtKey.Text);
objSave.CategoryMasterCatName = cmbCategory.Text;
objSave.CategoryMasterCatVal = txtCategoryValue.Text;
objSave.CategoryMasterCatIsActive = chkActiveInActive.Checked == true ? 1 : 0;
objSave.CategoryMasterHsnCode = txtHsnCode.Text;
objSave.Mode = mode.ToUpper();
objSave.CompanyID = cId;
if (mode.ToUpper().Equals("DELETE"))
{
var confirmation = MessageBox.Show("Are You Sure You Want to Delete " + " " + txtCategoryValue.Text, "Category Master Alert", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (confirmation.ToString().Equals("Yes"))
{
objSave.AddUpdateDelete();
BindDataGrid();
ResetFormControl();
}
}
else
{
if (objSave.Validation().Length > 0)
{
MessageBox.Show(objSave.Validation(), "Category Master Alert", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
objSave.AddUpdateDelete();
MessageBox.Show(cmbCategory.Text + " " + txtCategoryValue.Text + " " + mode + " Success Fully", "Category Save", MessageBoxButtons.OK, MessageBoxIcon.Information);
BindDataGrid();
ResetFormControl();
if (pageAction.Equals("Yes"))
{
this.Close();
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "SaveFormData", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void BindDataGrid()
{
try
{
clsCategoryMaster objLoad = new clsCategoryMaster();
objLoad.Mode = "SELECTALL";
objLoad.CompanyID = cId;
objLoad.CategoryMasterCatName = cmbCategory.Text;
dgvCategoryDetail.AutoGenerateColumns = false;
var ds = objLoad.GetAllCategory();
dgvCategoryDetail.DataSource = ds.Tables[0];
lblRecordCount.Text = ds.Tables[0].Rows.Count.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "BindDataGrid", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void BindCategoryCombo()
{
try
{
clsCategoryMaster objLoad = new clsCategoryMaster();
objLoad.Mode = "COMBOFILL";
objLoad.CompanyID = cId;
var ds = objLoad.GetAllCategory();
DataTable dt = ds.Tables[0];
DataRow dr = dt.NewRow();
dr["CategoryMasterCatKey"] = "0";
dr["CategoryMasterCatName"] = "Please Select Category";
dt.Rows.InsertAt(dr, 0);
cmbCategory.DataSource = dt;
cmbCategory.DisplayMember = "CategoryMasterCatName";
cmbCategory.ValueMember = "CategoryMasterCatKey";
cmbCategory.Text = "Please Select Category";
cmbCategory.Focus();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "BindCategoryCombo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
