public CFinishedRawProductList FinishedRawProductListInsert(CFinishedRawProductList finishedRawProductList)
{
if (ISDuplicate(finishedRawProductList.FinishedProductID, finishedRawProductList.RawProductID))
{
throw new Exception("This product alredy exits in Finished Product");
}
try
{
this.OpenConnection();
string sqlCommand = String.Format(SqlQueries.GetQuery(Query.FinishedRawProductListInsert),
finishedRawProductList.FinishedProductID, finishedRawProductList.RawProductID,
finishedRawProductList.RawProductName, finishedRawProductList.Qnty, finishedRawProductList.Remarks,finishedRawProductList.InsType);
this.ExecuteNonQuery(sqlCommand);
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in InsertDeposit()", LogLevel.Error, "Database");
return null;
}
finally
{
this.CloseConnection();
}
return finishedRawProductList;
}
public bool FinishedRawProductListDelete(CFinishedRawProductList finishedRawProductList)
{
try
{
// GetFinishedRawProductListByFinishedProductIDRawProductID
this.OpenConnection();
string sqlCommand = String.Format(SqlQueries.GetQuery(Query.FinishedRawProductListDelete), finishedRawProductList.ID);
this.ExecuteNonQuery(sqlCommand);
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in InsertDeposit()", LogLevel.Error, "Database");
return false;
}
finally
{
this.CloseConnection();
}
return true;
}
public CFinishedRawProductList FinishedRawProductListUpdate(CFinishedRawProductList finishedRawProductList)
{
try
{
this.OpenConnection();
string sqlCommand = String.Format(SqlQueries.GetQuery(Query.FinishedRawProductListUpdate),
finishedRawProductList.FinishedProductID, finishedRawProductList.RawProductID,
finishedRawProductList.RawProductName, finishedRawProductList.Qnty,
finishedRawProductList.Remarks, finishedRawProductList.ID,finishedRawProductList.InsType);
this.ExecuteNonQuery(sqlCommand);
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in FinishedRawProductListUpdate()", LogLevel.Error, "Database");
}
finally
{
this.CloseConnection();
}
return finishedRawProductList;
}
public void FinishedRawProductUpdate(CFinishedRawProductList list, double quantity)
{
try
{
this.OpenConnection();
string command = string.Format(SqlQueries.GetQuery(Query.UpdateRawMaterialsByRawProductID),
list.RawProductID, (list.Qnty * quantity));
this.ExecuteNonQuery(command);
}
catch (Exception ex)
{
throw ex;
}
finally
{
this.CloseConnection();
}
}
private CFinishedRawProductList ReaderToFinishedRawProductList(IDataReader inReader)
{
CFinishedRawProductList tempCategory3 = new CFinishedRawProductList();
if (inReader["ID"] != null)
tempCategory3.ID = long.Parse(inReader["ID"].ToString());
if (inReader["finishedProductID"] != null)
tempCategory3.RawProductID = long.Parse(inReader["finishedProductID"].ToString());
if (inReader["rawProductID"] != null)
tempCategory3.RawProductID = long.Parse(inReader["rawProductID"].ToString());
if (inReader["rawProductName"] != null)
tempCategory3.RawProductName = inReader["rawProductName"].ToString();
if (inReader["qnty"] != null)
tempCategory3.Qnty = double.Parse(inReader["qnty"].ToString());
if (inReader["remarks"] != null)
tempCategory3.Remarks = inReader["remarks"].ToString();
try
{
tempCategory3.InsType = Convert.ToBoolean(inReader["ins_type"]);
}
catch
{
}
return tempCategory3;
}
public List<CFinishedRawProductList> GetFinishedRawProductListByProductID(long productID)
{
List<CFinishedRawProductList> cFinishedRawProductList = new List<CFinishedRawProductList>();
CFinishedRawProductList tempFinishedRawProductList = new CFinishedRawProductList();
try
{
this.OpenConnection();
string sqlCommand = string.Format(SqlQueries.GetQuery(Query.GetFinishedRawProductListByProductID), productID);
IDataReader oReader = this.ExecuteReader(sqlCommand);
if (oReader != null)
{
while (oReader.Read())
{
tempFinishedRawProductList = new CFinishedRawProductList();
tempFinishedRawProductList = ReaderToFinishedRawProductList(oReader);
if (tempFinishedRawProductList != null)
{
cFinishedRawProductList.Add(tempFinishedRawProductList);
}
}
}
}
catch (Exception ex)
{
System.Console.WriteLine("###" + ex.ToString() + "###");
Logger.Write("Exception : " + ex.Message + " in GetFinishedRawProductListByProductID(long productID)", LogLevel.Error, "Database");
if (ex.GetType().Equals(typeof(SqlException)))
{
SqlException oSQLEx = ex as SqlException;
if (oSQLEx.Number != 7619)
throw new Exception("Exception occured at GetFinishedRawProductListByProductID(long productID) ", ex);
}
else
{
throw new Exception("Exception occured at GetFinishedRawProductListByProductID(long productID) ", ex);
}
}
finally
{
this.CloseConnection();
}
return cFinishedRawProductList;
}
private void FillDataInGrid(CFinishedRawProductList cFinishedProductList)
{
cmbProductName.Text = cFinishedProductList.RawProductName;
txtRawQnty.Text = cFinishedProductList.Qnty.ToString();
txtRawQnty.Tag = cFinishedProductList;
btnAddFinishedtoRawProductList.Text = "Update";
isModifyRawProduct = true;
}
private void dgvRawProductList_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.RowIndex == -1)
{
return;
}
else
{
cFinishedProductList = (CFinishedRawProductList)dgvRawProductList.Rows[e.RowIndex].Cells["obj"].Value;
FillDataInGrid(cFinishedProductList);
}
}
private void btnRemove_Click(object sender, EventArgs e)
{
try
{
if (cFinishedProductList != null)
{
FinishedRawProductListDAO finishedRawProductListDao = new FinishedRawProductListDAO();
finishedRawProductListDao.FinishedRawProductListDelete(cFinishedProductList);
}
cFinishedProductList = null;
LoadDataGrid();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void AddFinishedtoRawProductList()
{
try
{
// FinishedRawProductListDAO finishedRawProductDAO = new FinishedRawProductListDAO();
FinishedRawProductListDAO finishedRawProductDAO = new FinishedRawProductListDAO();
// CFinishedRawProductList cfinishedproduct = new CFinishedRawProductList();
if (isModifyRawProduct && txtRawQnty.Tag != null)
{
cFinishedProductList = txtRawQnty.Tag as CFinishedRawProductList;
}
else
{
cFinishedProductList = new CFinishedRawProductList();
}
InventoryItem aInventoryItem = new InventoryItem();
aInventoryItem = (InventoryItem)cmbProductName.SelectedItem;
// cFinishedProductList.FinishedProductID = m_iCat3ID;
// cFinishedProductList.RawProductID = cCategory3sList[cmbProductName.SelectedIndex].Category3ID;
// cFinishedProductList.RawProductName = cCategory3sList[cmbProductName.SelectedIndex].Category3Name;
cFinishedProductList.FinishedProductID = m_iCat3ID;
cFinishedProductList.RawProductID = aInventoryItem.ItemId;
cFinishedProductList.RawProductName = aInventoryItem.ItemName;
//try { cFinishedProductList.Qnty = Convert.ToInt32(txtRawQnty.Text); }
//catch (Exception e)
//{
//}
try { cFinishedProductList.Qnty = Convert.ToDouble(txtRawQnty.Text); }
catch (Exception e)
{
}
cFinishedProductList.Remarks = "";
if (isModifyRawProduct)
{
finishedRawProductDAO.FinishedRawProductListUpdate(cFinishedProductList);
}
else
{
try
{
finishedRawProductDAO.FinishedRawProductListInsert(cFinishedProductList);
}
catch { }
}
RefreshFinishedRawProduct();
LoadDataGrid();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
