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
{
}
}
/// <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);
}
}
private void LastColumnComboSelectionChanged(object sender, EventArgs e)
{
int rowIndex = ((DataGridViewComboBoxEditingControl)sender).EditingControlRowIndex;
ItemNameEL selectedItem = (ItemNameEL)((System.Windows.Forms.ComboBox)(((DataGridViewComboBoxEditingControl)sender))).SelectedItem;
if (selectedItem != null)
{
dataGridView1.Rows[rowIndex].Cells["Item_Rate"].Value = selectedItem.Item_Price.ToString();
}
else
{
dataGridView1.Rows[rowIndex].Cells["Item_Rate"].Value = "";
}
}
void BindControl()
{
try
{
ItemNameEL objItemEL = DataGridViewSelectedItem;
textItemName.Text = objItemEL.Item_name;
btnDelete.Visible = true;
btnUpdate.Visible = true;
btnSave.Visible = false;
}
catch
{
ControlClear();
}
}
public ItemNameEL GetItemNameById(int ItemName_id)
{
ItemNameEL objItemNameEL = null;
SQLHelper objSQLHelper = new SQLHelper();
DataTable dt = objSQLHelper.ExecuteSelectProcedure("SelectItemNameById"
, objSQLHelper.SqlParam("@Item_id", ItemName_id, SqlDbType.Int)
);
if (dt != null && dt.Rows.Count > 0)
{
objItemNameEL = new ItemNameEL();
objItemNameEL.Item_id = (int)dt.Rows[0]["Item_id"];
objItemNameEL.Item_name = dt.Rows[0]["Item_name"].ToString();
}
return(objItemNameEL);
}
public bool Delete(ItemNameEL objItemNameEL)
{
SQLHelper objSQLHelper = new SQLHelper();
SqlTransaction objSqlTransaction = objSQLHelper.BeginTrans();
try
{
int cpmpanyId = objSQLHelper.ExecuteDeleteProcedure("DeleteItemName", objSqlTransaction
, objSQLHelper.SqlParam("@Item_id", objItemNameEL.Item_id, SqlDbType.Int)
);
objSqlTransaction.Commit();
return(true);
}
catch
{
objSqlTransaction.Rollback();
return(false);
}
}
public int Insert(ItemNameEL objItemNameEL)
{
SQLHelper objSQLHelper = new SQLHelper();
SqlTransaction objSqlTransaction = objSQLHelper.BeginTrans();
try
{
int Id = objSQLHelper.ExecuteInsertProcedure("InsertItemName", objSqlTransaction
, objSQLHelper.SqlParam("@Item_Name", objItemNameEL.Item_name, SqlDbType.NVarChar)
);
objSqlTransaction.Commit();
return(Id);
}
catch
{
objSqlTransaction.Rollback();
return(0);
}
}
public List <ItemNameEL> GetItemNameAll()
{
ItemNameEL objItemNameEL;
List <ItemNameEL> lstInputFieldEL = new List <ItemNameEL>();
SQLHelper objSQLHelper = new SQLHelper();
DataTable dt = objSQLHelper.ExecuteSelectProcedure("SelectItemNameAll");
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
objItemNameEL = new ItemNameEL();
objItemNameEL.Item_id = (int)dt.Rows[i]["Item_id"];
objItemNameEL.Item_name = dt.Rows[i]["Item_name"].ToString();
lstInputFieldEL.Add(objItemNameEL);
}
}
return(lstInputFieldEL);
}
public bool Update(ItemNameEL objItemNameEL)
{
SQLHelper objSQLHelper = new SQLHelper();
SqlTransaction objSqlTransaction = objSQLHelper.BeginTrans();
try
{
int Id = objSQLHelper.ExecuteUpdateProcedure("UpdateItemName", objSqlTransaction
, objSQLHelper.SqlParam("@Item_Name", objItemNameEL.Item_name, SqlDbType.NVarChar)
, objSQLHelper.SqlParam("@HSN_Code", objItemNameEL.HSN_Code, SqlDbType.NVarChar)
, objSQLHelper.SqlParam("@Item_id", objItemNameEL.Item_id, SqlDbType.Int)
);
objSqlTransaction.Commit();
return(true);
}
catch
{
objSqlTransaction.Rollback();
return(false);
}
}
/// <summary>
/// set text of field name on bases of selected value in dropdown box
/// </summary>
private void BindControl()
{
ItemNameEL InputFieldEL = (ItemNameEL)cmbItemName.SelectedItem;
if (InputFieldEL.Item_id != 0)
{
txtItemName.Text = cmbItemName.Text;
btnAdd.Visible = false;
btnUpdate.Visible = true;
txtDescription.Text = InputFieldEL.Item_name_description;
txtHSN.Text = InputFieldEL.HSN_Code;
}
else
{
txtItemName.Text = "";
txtHSN.Text = "";
btnAdd.Visible = true;
btnUpdate.Visible = false;
txtDescription.Text = "";
}
}
public List <ItemNameEL> GetItemPriceList(int CompanyId)
{
ItemNameEL objItemNameEL;
List <ItemNameEL> lstInputFieldEL = new List <ItemNameEL>();
SQLHelper objSQLHelper = new SQLHelper();
DataTable dt = objSQLHelper.ExecuteSelectProcedure("GetItemPriceList"
, objSQLHelper.SqlParam("@Company_Id", CompanyId, SqlDbType.Int)
);
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
objItemNameEL = new ItemNameEL();
objItemNameEL.Item_id = Convert.ToInt32(dt.Rows[i]["Item_id"]);
objItemNameEL.Item_name = dt.Rows[i]["Item_name"].ToString();
objItemNameEL.Item_Price = Convert.ToDecimal(dt.Rows[i]["Item_Price"]);
objItemNameEL.Company_Item_Id = Convert.ToInt32(dt.Rows[i]["Company_Item_Id"]);
lstInputFieldEL.Add(objItemNameEL);
}
}
return(lstInputFieldEL);
}
