private void btnSave_Click(object sender, EventArgs e)
{
if (tbxCompanyName.Text.Equals(string.Empty))
{
MessageBox.Show("Company Name can not be blank!");
return;
}
ItemCompanyMasterModel objCompany = new ItemCompanyMasterModel();
objCompany.ItemCompany = tbxCompanyName.Text.Trim();
objCompany.StockAccount = cbxStockaccount.Text.Trim() == null?string.Empty:cbxStockaccount.Text.Trim();
objCompany.SalesAccount = cbxSalesaccount.Text.Trim() == null ? string.Empty : cbxSalesaccount.Text.Trim();
objCompany.PurchaseAccount = cbxPurchaseAccount.Text.Trim() == null ? string.Empty : cbxPurchaseAccount.Text.Trim();
objCompany.CreatedBy = "Admin";
bool isSuccess = objICBL.SaveItemCompany(objCompany);
if (isSuccess)
{
MessageBox.Show("Saved Successfully!");
ClearControls();
tbxCompanyName.Focus();
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (ItemcompId == 0)
{
tbxCompanyName.Focus();
return;
}
ItemCompanyMasterModel objCompany = new ItemCompanyMasterModel();
objCompany.ItemCompany = tbxCompanyName.Text.Trim();
objCompany.StockAccount = cbxStockaccount.Text.Trim() == null ? string.Empty : cbxStockaccount.Text.Trim();
objCompany.SalesAccount = cbxSalesaccount.Text.Trim() == null ? string.Empty : cbxSalesaccount.Text.Trim();
objCompany.PurchaseAccount = cbxPurchaseAccount.Text.Trim() == null ? string.Empty : cbxPurchaseAccount.Text.Trim();
objCompany.ModifiedBy = "Admin";
objCompany.ICM_id = ItemcompId;
bool isSuccess = objICBL.UpdateItemCompany(objCompany);
if (isSuccess)
{
MessageBox.Show("Update Successfully!");
ItemcompId = 0;
ClearControls();
Administration.List.ItemcompanyList frmList = new Administration.List.ItemcompanyList();
frmList.StartPosition = FormStartPosition.CenterScreen;
frmList.ShowDialog();
FillItemCompanyInfo();
}
}
//Update
public bool UpdateItemCompany(ItemCompanyMasterModel objCompany)
{
string Query = string.Empty;
bool isUpdate = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@ItemCompany", objCompany.ItemCompany));
paramCollection.Add(new DBParameter("@StockAccount", objCompany.StockAccount));
paramCollection.Add(new DBParameter("@SalesAccount", objCompany.SalesAccount));
paramCollection.Add(new DBParameter("@PurchaseAccount", objCompany.PurchaseAccount));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ICompany_Id", objCompany.ICM_id));
System.Data.IDataReader dr =
_dbHelper.ExecuteDataReader("spUpdateItemCompany", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
}
catch (Exception ex)
{
isUpdate = false;
throw ex;
}
return(isUpdate);
}
//Get List Of Groups By Id
public ItemCompanyMasterModel GetAllItemCompanyById(int id)
{
ItemCompanyMasterModel objICM = new ItemCompanyMasterModel();
string Query = "SELECT * FROM `itemcompanymaster` WHERE ICM_ID=" + id + "";
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objICM.ICM_id = Convert.ToInt32(dr["ICM_ID"]);
objICM.ItemCompany = dr["ItemCompany"].ToString();
objICM.StockAccount = dr["StockAccount"].ToString();
objICM.SalesAccount = dr["SalesAccount"].ToString();
objICM.PurchaseAccount = dr["PurchaseAccount"].ToString();
}
return(objICM);
}
//List Item Company
public List <ItemCompanyMasterModel> GetAllItemCompany()
{
List <ItemCompanyMasterModel> lstIC = new List <ItemCompanyMasterModel>();
ItemCompanyMasterModel objICM;
string Query = "SELECT DISTINCT ICM_ID,ItemCompany FROM `itemcompanymaster`";
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objICM = new ItemCompanyMasterModel();
objICM.ICM_id = Convert.ToInt32(dr["ICM_Id"]);
objICM.ItemCompany = dr["ItemCompany"].ToString();
lstIC.Add(objICM);
}
return(lstIC);
}
private void FillItemCompanyInfo()
{
if (ItemcompId == 0)
{
tbxCompanyName.Focus();
ClearControls();
lblUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
lblSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
lblDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
return;
}
ItemCompanyMasterModel objICM = objICBL.GetAllItemCompanyById(ItemcompId);
tbxCompanyName.Text = objICM.ItemCompany;
cbxStockaccount.SelectedItem = objICM.StockAccount;
cbxSalesaccount.SelectedItem = objICM.SalesAccount;
cbxPurchaseAccount.SelectedItem = objICM.PurchaseAccount;
lblUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
lblSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
lblDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
tbxCompanyName.Focus();
}
