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