public long Add(PRPDCAP obj) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@PRPDCAPID", obj.PRPDCAPID), new SqlParameter("@CAPMaterial", obj.MaterialCode), new SqlParameter("@GRNNO", obj.GRNNO), new SqlParameter("@CAPQty", obj.CAPQty), new SqlParameter("@Instructions", obj.Instructions), new SqlParameter("@ReworkQty", obj.ReworkQty), new SqlParameter("@DisposeQty", obj.DisposeQty), new SqlParameter("@AcceptQty", obj.AcceptQty), new SqlParameter("@Remarks", obj.Remarks), new SqlParameter("@EnterdBy", obj.EnteredBy.EmployeeID), new SqlParameter("@EnterdDate", obj.EnteredDate), new SqlParameter("@ApprovedBy", obj.ApprovedBy.EmployeeID), new SqlParameter("@ApprovedDate", obj.ApprovedDate), new SqlParameter("@TestedBy", obj.TestedBy.EmployeeID), new SqlParameter("@TestDate", obj.TestedDate), new SqlParameter("@CAPStatus", obj.Status), new SqlParameter("@ReworkMTN", obj.ReworkMTN), new SqlParameter("@DisposeMTN", obj.DisposeMTN) }; return(Execute.RunSP_RowsEffected(Connection, "SPADD_PRPDCAP", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Update(PRPDCAP obj, long Original_PRPDCAPID) { try { da.Connection = Connection; return(da.Update(obj.MaterialCode, obj.GRNNO, obj.CAPQty, obj.Instructions, obj.ReworkQty, obj.DisposeQty, obj.AcceptQty, obj.Remarks, obj.EnteredBy.EmployeeID, obj.EnteredDate, obj.ApprovedBy.EmployeeID, obj.ApprovedDate, obj.TestedBy.EmployeeID, obj.TestedDate, (int)obj.Status, obj.ReworkMTN, obj.DisposeMTN, Original_PRPDCAPID)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } finally { da.Dispose(); } }
public int Update(PRPDCAP obj, long Original_PRPDCAPID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@Original_PRPDCAPID", Original_PRPDCAPID) }; return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_PRPDCAP", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public long Add(PRPDCAP obj) { try { da.Connection = Connection; Decimal?ID = null; int res = da.SPADD_PRPDCAP_Update(obj.PRPDCAPID, obj.MaterialCode, obj.GRNNO, obj.CAPQty, obj.Instructions, obj.ReworkQty, obj.DisposeQty, obj.AcceptQty, obj.Remarks, obj.EnteredBy.EmployeeID, obj.EnteredDate, obj.ApprovedBy.EmployeeID, obj.ApprovedDate, obj.TestedBy.EmployeeID, obj.TestedDate, (int)obj.Status, obj.ReworkMTN, obj.DisposeMTN, ref ID); if (ID.HasValue) { return(Convert.ToInt64(ID.Value)); } return(0); } catch (Exception ex) { throw new Exception(ex.Message, ex); } finally { da.Dispose(); } }
public PRPDCAP Get(long PRPDCAPID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@PRPDCAPID", PRPDCAPID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_PRPDCAPByID", paramList); PRPDCAP obj = new PRPDCAP(); if (dt.Rows.Count > 0) { obj.PRPDCAPID = Convert.ToInt64(dt.Rows[0]["PRPDCAPID"]); obj.MaterialCode = Convert.ToString(dt.Rows[0]["CAPMaterial"]); obj.GRNNO = Convert.ToInt64(dt.Rows[0]["GRNNO"]); obj.CAPQty = Convert.ToDecimal(dt.Rows[0]["CAPQty"]); obj.Instructions = Convert.ToString(dt.Rows[0]["Instructions"]); obj.ReworkQty = Convert.ToDecimal(dt.Rows[0]["ReworkQty"]); obj.DisposeQty = Convert.ToDecimal(dt.Rows[0]["DisposeQty"]); obj.AcceptQty = Convert.ToDecimal(dt.Rows[0]["AcceptQty"]); obj.Remarks = Convert.ToString(dt.Rows[0]["Remarks"]); obj.EnteredBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[0]["EnterdBy"])); obj.EnteredDate = Convert.ToDateTime(dt.Rows[0]["EnterdDate"]); obj.ApprovedBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[0]["ApprovedBy"])); obj.ApprovedDate = Convert.ToDateTime(dt.Rows[0]["ApprovedDate"]); obj.TestedBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[0]["TestedBy"])); obj.TestedDate = Convert.ToDateTime(dt.Rows[0]["TestDate"]); obj.Status = (PRPDCAP.CAPStatus)Enum.Parse(typeof(PRPDCAP.CAPStatus), Convert.ToString(dt.Rows[0]["CAPStatus"])); obj.ReworkMTN = Convert.ToInt64(dt.Rows[0]["ReworkMTN"]); obj.DisposeMTN = Convert.ToInt64(dt.Rows[0]["DisposeMTN"]); } return(obj); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public PRPDCAP Get(long PRPDCAPID) { MRPDataSetPRPD dsMRP = new MRPDataSetPRPD(); PRPDCAP obj = new PRPDCAP(); Employee_DL objEmployee_DL = new Employee_DL(Connection); Material_DL objMaterial_DL = new Material_DL(Connection); try { da.Connection = Connection; da.FillByID(dsMRP.tblPRPDCAP, PRPDCAPID); if (dsMRP.tblPRPDCAP.Rows.Count > 0) { MRPDataSetPRPD.tblPRPDCAPRow dr = (MRPDataSetPRPD.tblPRPDCAPRow)dsMRP.tblPRPDCAP.Rows[0]; if (!dr.IsAcceptQtyNull()) { obj.AcceptQty = dr.AcceptQty; } if (!dr.IsApprovedByNull()) { obj.ApprovedBy = objEmployee_DL.Get(dr.ApprovedBy); } if (!dr.IsApprovedDateNull()) { obj.ApprovedDate = dr.ApprovedDate; } obj.MaterialCode = (dr.CAPMaterial); obj.CAPQty = dr.CAPQty; if (!dr.IsDisposeQtyNull()) { obj.DisposeQty = dr.DisposeQty; } if (!dr.IsEnterdByNull()) { obj.EnteredBy = objEmployee_DL.Get(dr.EnterdBy); } obj.EnteredDate = dr.EnterdDate; obj.GRNNO = Convert.ToInt64(dr.GRNNO); obj.Instructions = dr.Instructions; obj.PRPDCAPID = Convert.ToInt64(dr.PRPDCAPID); obj.Remarks = dr.Remarks; if (!dr.IsReworkQtyNull()) { obj.ReworkQty = dr.ReworkQty; } obj.Status = (PRPDCAP.CAPStatus)dr.CAPStatus; if (!dr.IsTestedByNull()) { obj.TestedBy = objEmployee_DL.Get(dr.TestedBy); } if (!dr.IsTestDateNull()) { obj.TestedDate = dr.TestDate; } if (!dr.IsReworkMTNNull()) { obj.ReworkMTN = Convert.ToInt64(dr.ReworkMTN); } if (!dr.IsDisposeMTNNull()) { obj.DisposeMTN = Convert.ToInt64(dr.DisposeMTN); } return(obj); } return(null); } catch (Exception ex) { throw new Exception(ex.Message, ex); } finally { da.Dispose(); dsMRP.Dispose(); objEmployee_DL = null; objMaterial_DL = null; } }