private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(textItemName.Text))
{
Common.MessageAlert("First Enter Item Name");
}
else
{
ItemNameEL objItemEL = new ItemNameEL();
ItemNameDL objItemDL = new ItemNameDL();
objItemEL.Item_name = textItemName.Text;
int inserResult = objItemDL.Insert(objItemEL);
if (inserResult != 0)
{
if (inserResult == (int)DuplicateItem.Yes)
{
Common.MessageAlert("This item ia already present");
}
else
{
Common.MessageSave();
GridBind();
ControlClear();
}
}
}
}
catch
{
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
if (Common.MessageConfim("Are You Want To Delete This "))
{
ItemNameEL objItemEL = new ItemNameEL();
ItemNameDL objItemDL = new ItemNameDL();
objItemEL.Item_id = DataGridViewSelectedItem.Item_id;
if (objItemDL.Delete(objItemEL))
{
Common.MessageDelete();
GridBind();
ControlClear();
}
else
{
}
}
}
catch
{
}
}
void ItemGridBind()
{
try
{
ItemNameDL objItemNameDL = new ItemNameDL();
int? companyId = null;
int? itemId = null;
if ((int)cmbCompany.SelectedValue > 0)
{
companyId = (int)cmbCompany.SelectedValue;
}
if ((int)cmbItem.SelectedValue > 0)
{
itemId = (int)cmbItem.SelectedValue;
}
DataTable dt = objItemNameDL.GetpurchaseReport(datePickerFromDate.Value, datePickerToDate.Value, companyId, itemId);
grdItem.DataSource = dt;
grdItem.Columns["Company_id"].Visible = false;
}
catch
{
}
}
/// <summary>
/// add new name fiels
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAdd_Click(object sender, EventArgs e)
{
if (txtItemName.Text == "")
{
Common.MessageAlert("Item Name Name can't be Blank");
}
else
{
try
{
ItemNameEL objItemNameEL = new ItemNameEL();
ItemNameDL objItemNameDL = new ItemNameDL();
objItemNameEL.Item_name = txtItemName.Text.Trim();
objItemNameEL.HSN_Code = txtHSN.Text.Trim();
objItemNameEL.Item_name_description = txtDescription.Text.Trim();
objItemNameDL.Insert(objItemNameEL);
FillComboBoxes();
ClearControl();
Common.MessageSave();
}
catch (Exception ex)
{
Common.MessageAlert(ex.Message);
}
}
}
/// <summary>
/// file field name & datatype dropdown
/// </summary>
private void FillComboBoxes()
{
try
{
// Filll FieldName drop Down box
ItemNameDL objItemNameDL = new ItemNameDL();
ItemNameEL objItemNameEL = new ItemNameEL();
objItemNameEL.Item_name = "Add New";
objItemNameEL.Item_id = 0;
List <ItemNameEL> lstInputField = new List <ItemNameEL>();
lstInputField.Add(objItemNameEL);
lstInputField.AddRange(objItemNameDL.GetItemNameAll());
cmbItemName.SelectedValueChanged -= cmbItemName_SelectedValueChanged;
cmbItemName.DataSource = lstInputField;
cmbItemName.DisplayMember = "Item_Name";
cmbItemName.ValueMember = "Item_Id";
cmbItemName.SelectedValueChanged += cmbItemName_SelectedValueChanged;
}
catch (Exception ex)
{
Common.MessageAlert(ex.Message);
}
}
void bindGridComboBox()
{
DataGridViewComboBoxColumn ItemName = (DataGridViewComboBoxColumn)dataGridView1.Columns["ItemName"];
ItemNameDL objItemNameDL = new ItemNameDL();
LstItemNameEL = objItemNameDL.GetItemNameAll();
ItemName.DataSource = LstItemNameEL;
ItemName.DisplayMember = "Item_Name";
ItemName.ValueMember = "Item_Id";
}
private void ItemComboBox()
{
ItemNameDL objItemNameDL = new ItemNameDL();
List <ItemNameEL> itemList = objItemNameDL.GetItemNameAll();
itemList.Insert(0, new ItemNameEL {
Item_id = 0, Item_name = "All"
});
cmbItem.SelectedIndexChanged -= cmbItem_SelectedIndexChanged;
cmbItem.DataSource = itemList;
cmbItem.DisplayMember = "Item_Name";
cmbItem.ValueMember = "Item_Id";
cmbItem.SelectedIndexChanged += cmbItem_SelectedIndexChanged;
}
void bindGridComboBox()
{
DataGridViewComboBoxColumn ItemName = (DataGridViewComboBoxColumn)dataGridView1.Columns["ItemName"];
ItemNameDL objItemNameDL = new ItemNameDL();
LstItemNameEL = objItemNameDL.GetItemPriceList(companyEL.Company_id);
ItemName.DataSource = LstItemNameEL;
ItemName.DisplayMember = "Item_Name";
ItemName.ValueMember = "Item_Id";
//ItemName.HeaderText = "Item Name";
//Adding combo box column in dataGridView
//dataGridView1.Columns.Insert(4, ItemName);
}
void GridBind()
{
try
{
ItemNameDL objItemDL = new ItemNameDL();
List <ItemNameEL> ItemList = objItemDL.GetItemNameAll();
dataGridView1.SelectionChanged -= dataGridView1_SelectionChanged;
dataGridView1.Click -= dataGridView1_Click;
dataGridView1.DataSource = ItemList;
dataGridView1.Columns["Item_id"].Visible = false;
dataGridView1.SelectionChanged += dataGridView1_SelectionChanged;
dataGridView1.Click += dataGridView1_Click;
}
catch
{
}
ControlClear();
}
void GridBind()
{
try
{
ItemNameDL objItemNameDL = new ItemNameDL();
List <ItemNameEL> lstItemPrice = objItemNameDL.GetItemPriceList(companyEL.Company_id);
dataGridView1.Rows.Clear();
for (int i = 0; i < lstItemPrice.Count; i++)
{
int n = dataGridView1.Rows.Add();
dataGridView1.Rows[n].Cells["Item_Id"].Value = lstItemPrice[i].Item_id.ToString();
dataGridView1.Rows[n].Cells["Item_Name"].Value = lstItemPrice[i].Item_name.ToString();
dataGridView1.Rows[n].Cells["Company_Item_Id"].Value = lstItemPrice[i].Company_Item_Id;
dataGridView1.Rows[n].Cells["Item_Price"].Value = lstItemPrice[i].Item_Price;
}
}
catch
{
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable();
dt.Columns.Add("Company_Item_Id", typeof(int));
dt.Columns.Add("Item_Id", typeof(int));
dt.Columns.Add("Item_Price", typeof(int));
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
try
{
int Company_Item_Id = Convert.ToInt32(dataGridView1.Rows[i].Cells["Company_Item_Id"].Value);
int Item_Id = Convert.ToInt32(dataGridView1.Rows[i].Cells["Item_Id"].Value);
decimal Item_Price = Convert.ToDecimal(dataGridView1.Rows[i].Cells["Item_Price"].Value);
dt.Rows.Add(Company_Item_Id, Item_Id, Item_Price);
}
catch (Exception)
{
Common.MessageAlert("Please enter valid value for price.");
}
}
ItemNameDL objItemNameDL = new ItemNameDL();
if (objItemNameDL.SaveItemPrice(dt, companyEL.Company_id))
{
Common.MessageSave();
GridBind();
}
}
catch
{
}
}
