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); } }