public void SaveReplacementOrderSerialDetail(ReplacementOrderSerialDetail argReplacementOrderSerialDetail, DataAccess da, List <ErrorHandler> lstErr)
{
try
{
if (blnIsReplacementOrderSerialDetailExists(argReplacementOrderSerialDetail.RepOrderCode, argReplacementOrderSerialDetail.RepOrderItemNo, argReplacementOrderSerialDetail.SerialNo1, argReplacementOrderSerialDetail.ClientCode, da) == false)
{
InsertReplacementOrderSerialDetail(argReplacementOrderSerialDetail, da, lstErr);
}
else
{
UpdateReplacementOrderSerialDetail(argReplacementOrderSerialDetail, da, lstErr);
}
}
catch (Exception ex)
{
objErrorHandler.Type = ErrorConstant.strAboartType;
objErrorHandler.MsgId = 0;
objErrorHandler.Module = ErrorConstant.strInsertModule;
objErrorHandler.ModulePart = ErrorConstant.strMasterModule;
objErrorHandler.Message = ex.Message.ToString();
objErrorHandler.RowNo = 0;
objErrorHandler.FieldName = "";
objErrorHandler.LogCode = "";
lstErr.Add(objErrorHandler);
}
}
private ReplacementOrderSerialDetail objCreateReplacementOrderSerialDetail(DataRow dr)
{
ReplacementOrderSerialDetail tReplacementOrderSerialDetail = new ReplacementOrderSerialDetail();
tReplacementOrderSerialDetail.SetObjectInfo(dr);
return(tReplacementOrderSerialDetail);
}
public void UpdateReplacementOrderSerialDetail(ReplacementOrderSerialDetail argReplacementOrderSerialDetail, DataAccess da, List <ErrorHandler> lstErr)
{
SqlParameter[] param = new SqlParameter[21];
param[0] = new SqlParameter("@RepOrderCode", argReplacementOrderSerialDetail.RepOrderCode);
param[1] = new SqlParameter("@RepOrderItemNo", argReplacementOrderSerialDetail.RepOrderItemNo);
param[2] = new SqlParameter("@SerialNo1", argReplacementOrderSerialDetail.SerialNo1);
param[3] = new SqlParameter("@SerialNo2", argReplacementOrderSerialDetail.SerialNo2);
param[4] = new SqlParameter("@MaterialCode", argReplacementOrderSerialDetail.MaterialCode);
param[5] = new SqlParameter("@MatGroup1Code", argReplacementOrderSerialDetail.MatGroup1Code);
param[6] = new SqlParameter("@PartnerCode", argReplacementOrderSerialDetail.PartnerCode);
param[7] = new SqlParameter("@PartnerEmployeeCode", argReplacementOrderSerialDetail.PartnerEmployeeCode);
param[8] = new SqlParameter("@ToPartnerCode", argReplacementOrderSerialDetail.ToPartnerCode);
param[9] = new SqlParameter("@OrderQty", argReplacementOrderSerialDetail.OrderQty);
param[10] = new SqlParameter("@UOMCode", argReplacementOrderSerialDetail.UOMCode);
param[11] = new SqlParameter("@ReceivedQty", argReplacementOrderSerialDetail.ReceivedQty);
param[12] = new SqlParameter("@RepOrderStatus", argReplacementOrderSerialDetail.RepOrderStatus);
param[13] = new SqlParameter("@IssueDocCode", argReplacementOrderSerialDetail.IssueDocCode);
param[14] = new SqlParameter("@IssueDocItemNo", argReplacementOrderSerialDetail.IssueDocItemNo);
param[15] = new SqlParameter("@ClientCode", argReplacementOrderSerialDetail.ClientCode);
param[16] = new SqlParameter("@CreatedBy", argReplacementOrderSerialDetail.CreatedBy);
param[17] = new SqlParameter("@ModifiedBy", argReplacementOrderSerialDetail.ModifiedBy);
param[18] = new SqlParameter("@Type", SqlDbType.Char);
param[18].Size = 1;
param[18].Direction = ParameterDirection.Output;
param[19] = new SqlParameter("@Message", SqlDbType.VarChar);
param[19].Size = 255;
param[19].Direction = ParameterDirection.Output;
param[20] = new SqlParameter("@returnvalue", SqlDbType.VarChar);
param[20].Size = 20;
param[20].Direction = ParameterDirection.Output;
int i = da.NExecuteNonQuery("Proc_UpdateReplacementOrderSerialDetail", param);
string strMessage = Convert.ToString(param[19].Value);
string strType = Convert.ToString(param[18].Value);
string strRetValue = Convert.ToString(param[20].Value);
objErrorHandler.Type = strType;
objErrorHandler.MsgId = 0;
objErrorHandler.Module = ErrorConstant.strInsertModule;
objErrorHandler.ModulePart = ErrorConstant.strMasterModule;
objErrorHandler.Message = strMessage.ToString();
objErrorHandler.RowNo = 0;
objErrorHandler.FieldName = "";
objErrorHandler.LogCode = "";
lstErr.Add(objErrorHandler);
}
public ReplacementOrderSerialDetail objGetReplacementOrderSerialDetail(string argRepOrderCode, int argRepOrderItemNo, string argSerialNo1, string argClientCode)
{
ReplacementOrderSerialDetail argReplacementOrderSerialDetail = new ReplacementOrderSerialDetail();
DataSet DataSetToFill = new DataSet();
if (argRepOrderCode.Trim() == "")
{
goto ErrorHandlers;
}
if (argRepOrderItemNo <= 0)
{
goto ErrorHandlers;
}
if (argSerialNo1.Trim() == "")
{
goto ErrorHandlers;
}
if (argClientCode.Trim() == "")
{
goto ErrorHandlers;
}
DataSetToFill = this.GetReplacementOrderSerialDetail(argRepOrderCode, argRepOrderItemNo, argSerialNo1, argClientCode);
if (DataSetToFill.Tables[0].Rows.Count <= 0)
{
goto Finish;
}
argReplacementOrderSerialDetail = this.objCreateReplacementOrderSerialDetail((DataRow)DataSetToFill.Tables[0].Rows[0]);
goto Finish;
ErrorHandlers:
Finish:
DataSetToFill = null;
return(argReplacementOrderSerialDetail);
}
public ICollection <ReplacementOrderSerialDetail> colGetReplacementOrderSerialDetail(string argRepOrderCode, int argRepOrderItemNo, string argClientCode)
{
List <ReplacementOrderSerialDetail> lst = new List <ReplacementOrderSerialDetail>();
DataSet DataSetToFill = new DataSet();
ReplacementOrderSerialDetail tReplacementOrderSerialDetail = new ReplacementOrderSerialDetail();
DataSetToFill = this.GetReplacementOrderSerialDetail(argRepOrderCode, argRepOrderItemNo, argClientCode);
if (DataSetToFill != null)
{
foreach (DataRow dr in DataSetToFill.Tables[0].Rows)
{
lst.Add(objCreateReplacementOrderSerialDetail(dr));
}
}
goto Finish;
Finish:
DataSetToFill = null;
return(lst);
}
public ICollection <ErrorHandler> SaveReplacementOrderSerialDetail(ReplacementOrderSerialDetail argReplacementOrderSerialDetail)
{
List <ErrorHandler> lstErr = new List <ErrorHandler>();
DataAccess da = new DataAccess();
try
{
if (blnIsReplacementOrderSerialDetailExists(argReplacementOrderSerialDetail.RepOrderCode, argReplacementOrderSerialDetail.RepOrderItemNo, argReplacementOrderSerialDetail.SerialNo1, argReplacementOrderSerialDetail.ClientCode) == false)
{
da.Open_Connection();
da.BEGIN_TRANSACTION();
InsertReplacementOrderSerialDetail(argReplacementOrderSerialDetail, da, lstErr);
foreach (ErrorHandler objerr in lstErr)
{
if (objerr.Type == "E")
{
da.ROLLBACK_TRANSACTION();
return(lstErr);
}
}
}
else
{
da.Open_Connection();
da.BEGIN_TRANSACTION();
UpdateReplacementOrderSerialDetail(argReplacementOrderSerialDetail, da, lstErr);
foreach (ErrorHandler objerr in lstErr)
{
if (objerr.Type == "E")
{
da.ROLLBACK_TRANSACTION();
return(lstErr);
}
}
}
}
catch (Exception ex)
{
if (da != null)
{
da.ROLLBACK_TRANSACTION();
}
objErrorHandler.Type = ErrorConstant.strAboartType;
objErrorHandler.MsgId = 0;
objErrorHandler.Module = ErrorConstant.strInsertModule;
objErrorHandler.ModulePart = ErrorConstant.strMasterModule;
objErrorHandler.Message = ex.Message.ToString();
objErrorHandler.RowNo = 0;
objErrorHandler.FieldName = "";
objErrorHandler.LogCode = "";
lstErr.Add(objErrorHandler);
}
finally
{
if (da != null)
{
da.Close_Connection();
da = null;
}
}
return(lstErr);
}
public PartnerErrorResult SavePartnerGoodsMovement(PartnerGoodsMovement argPartnerGoodsMovement, PartnerGoodsMovementDetailCol argPartnerGNDetail, PartnerGoodsMovSerialDetailCol argPartnerGMSerialDetail)
{
List <ErrorHandler> lstErr = new List <ErrorHandler>();
PartnerErrorResult errorcol = new PartnerErrorResult();
PartnerGoodsMovementDetailManager objPartnerGMDetailManager = new PartnerGoodsMovementDetailManager();
PartnerGoodsMovSerialDetailManager objPartnerGNSerialDetailManager = new PartnerGoodsMovSerialDetailManager();
DataAccess da = new DataAccess();
string strRetValue = "";
try
{
da.Open_Connection();
da.BEGIN_TRANSACTION();
if (blnIsPartnerGoodsMovementExists(argPartnerGoodsMovement.PGoodsMovementCode, argPartnerGoodsMovement.ClientCode, da) == false)
{
strRetValue = InsertPartnerGoodsMovement(argPartnerGoodsMovement, da, lstErr);
}
else
{
strRetValue = UpdatePartnerGoodsMovement(argPartnerGoodsMovement, da, lstErr);
}
foreach (ErrorHandler objerr in lstErr)
{
if (objerr.Type == "E")
{
errorcol.colErrorHandler.Add(objerr);
da.ROLLBACK_TRANSACTION();
return(errorcol);
}
if (objerr.Type == "A")
{
errorcol.colErrorHandler.Add(objerr);
da.ROLLBACK_TRANSACTION();
return(errorcol);
}
}
if (strRetValue != "")
{
if (argPartnerGNDetail.colPartnerGMDetail.Count > 0)
{
foreach (PartnerGoodsMovementDetail objPartnerGMDetail in argPartnerGNDetail.colPartnerGMDetail)
{
objPartnerGMDetail.PGoodsMovementCode = strRetValue;
if (objPartnerGMDetail.IsDeleted == 0)
{
objPartnerGMDetailManager.SavePartnerGoodsMovementDetail(objPartnerGMDetail, da, lstErr);
}
else
{
/*Delete Function Call*/
}
}
foreach (ErrorHandler objerr in lstErr)
{
if (objerr.Type == "E")
{
errorcol.colErrorHandler.Add(objerr);
da.ROLLBACK_TRANSACTION();
return(errorcol);
}
if (objerr.Type == "A")
{
errorcol.colErrorHandler.Add(objerr);
da.ROLLBACK_TRANSACTION();
return(errorcol);
}
}
}
if (argPartnerGMSerialDetail.colPartnerGMSerialDetail.Count > 0)
{
foreach (PartnerGoodsMovSerialDetail objPartnerGMSerialDetail in argPartnerGMSerialDetail.colPartnerGMSerialDetail)
{
objPartnerGMSerialDetail.PGoodsMovementCode = strRetValue;
if (objPartnerGMSerialDetail.IsDeleted == 0)
{
objPartnerGNSerialDetailManager.SavePartnerGoodsMovSerialDetail(objPartnerGMSerialDetail, da, lstErr);
}
else
{
/*Call delete function*/
}
}
foreach (ErrorHandler objerr in lstErr)
{
if (objerr.Type == "E")
{
errorcol.colErrorHandler.Add(objerr);
da.ROLLBACK_TRANSACTION();
return(errorcol);
}
if (objerr.Type == "A")
{
errorcol.colErrorHandler.Add(objerr);
da.ROLLBACK_TRANSACTION();
return(errorcol);
}
}
}
/******************************/
int IsCreateRepOrder = 0;
PartnerGMDocTypeManager objPartnerGMDocTypeMan = new PartnerGMDocTypeManager();
DataSet ds = objPartnerGMDocTypeMan.GetPartnerGMDocType(Convert.ToString(argPartnerGoodsMovement.PartnerGMDocTypeCode), Convert.ToString(argPartnerGoodsMovement.ClientCode), da);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
if (Convert.ToString(ds.Tables[0].Rows[0]["CreateRepOrder"]) != "")
{
IsCreateRepOrder = Convert.ToInt32(ds.Tables[0].Rows[0]["CreateRepOrder"]);
}
}
}
if (IsCreateRepOrder == 1)
{
///* Call Replace Order Save Function */
ReplacementOrder objRepalcementOrder = new ReplacementOrder();
string strNewRepOrderCode = objReplaceOrderManager.GenerateRepOrderCode("NEW", "RO01", argPartnerGoodsMovement.PartnerCode, argPartnerGoodsMovement.ClientCode);
objRepalcementOrder.RepOrderCode = strNewRepOrderCode;
objRepalcementOrder.RepOrderDocTypeCode = Convert.ToString("RO01");
objRepalcementOrder.RepOrderDate = Convert.ToDateTime(argPartnerGoodsMovement.GoodsMovDate).ToString("yyyy-MM-dd");
objRepalcementOrder.TotalQuantity = 0;
objRepalcementOrder.RepOrderStatus = "OPEN";
objRepalcementOrder.OrderType = Convert.ToString(argPartnerGoodsMovement.AssignType);
objRepalcementOrder.IssueDocCode = Convert.ToString(argPartnerGoodsMovement.PGoodsMovementCode);
objRepalcementOrder.PartnerCode = Convert.ToString(argPartnerGoodsMovement.PartnerCode);
objRepalcementOrder.ToPartnerCode = Convert.ToString(argPartnerGoodsMovement.ToPartnerCode);
objRepalcementOrder.ClientCode = Convert.ToString(argPartnerGoodsMovement.ClientCode);
objRepalcementOrder.CreatedBy = Convert.ToString(argPartnerGoodsMovement.CreatedBy);
objRepalcementOrder.ModifiedBy = Convert.ToString(argPartnerGoodsMovement.ModifiedBy);
ReplacementOrderDetailCol argReplacementOrderDetailCol = new ReplacementOrderDetailCol();
ReplacementOrderDetail objReplacementOrderDetail = null;
ReplacementOrderSerialDetailCol argReplacementOrderSerialDetailCol = new ReplacementOrderSerialDetailCol();
ReplacementOrderSerialDetail objReplacementOrderSerialDetail = null;
int ictr = 0;
foreach (PartnerGoodsMovementDetail objPartnerGMDetail in argPartnerGNDetail.colPartnerGMDetail)
{
ictr = ictr + 1;
objReplacementOrderDetail = new ReplacementOrderDetail();
objReplacementOrderDetail.RepOrderCode = strNewRepOrderCode;
objReplacementOrderDetail.RepOrderItemNo = ictr;
objReplacementOrderDetail.MaterialCode = objPartnerGMDetail.MaterialCode;
objReplacementOrderDetail.MatGroup1Code = objPartnerGMDetail.MatGroup1Code;
objReplacementOrderDetail.PartnerCode = objPartnerGMDetail.PartnerCode;
objReplacementOrderDetail.PartnerEmployeeCode = objPartnerGMDetail.FromPartnerEmployeeCode;
objReplacementOrderDetail.OrderQty = objPartnerGMDetail.Quantity;
objReplacementOrderDetail.UOMCode = objPartnerGMDetail.UOMCode;
objReplacementOrderDetail.ReceivedQty = 0;
objReplacementOrderDetail.RepOrderStatus = "OPEN";
objReplacementOrderDetail.IssueDocCode = objPartnerGMDetail.PGoodsMovementCode;
objReplacementOrderDetail.IssueDocItemNo = objPartnerGMDetail.ItemNo;
objReplacementOrderDetail.ToPartnerCode = objPartnerGMDetail.ToPartnerCode;
objReplacementOrderDetail.ClientCode = argPartnerGoodsMovement.ClientCode;
objReplacementOrderDetail.CreatedBy = argPartnerGoodsMovement.CreatedBy;
objReplacementOrderDetail.ModifiedBy = argPartnerGoodsMovement.ModifiedBy;
objReplacementOrderDetail.IsDeleted = 0;
argReplacementOrderDetailCol.colReplacementOrderDetail.Add(objReplacementOrderDetail);
foreach (PartnerGoodsMovSerialDetail objPartnerGMSerialDetail in argPartnerGMSerialDetail.colPartnerGMSerialDetail)
{
if (objPartnerGMSerialDetail.ItemNo == objPartnerGMDetail.ItemNo)
{
objReplacementOrderSerialDetail = new ReplacementOrderSerialDetail();
objReplacementOrderSerialDetail.RepOrderCode = strNewRepOrderCode;
objReplacementOrderSerialDetail.RepOrderItemNo = ictr;
objReplacementOrderSerialDetail.SerialNo1 = objPartnerGMSerialDetail.SerialNo1;
objReplacementOrderSerialDetail.SerialNo2 = objPartnerGMSerialDetail.SerialNo2;
objReplacementOrderSerialDetail.MaterialCode = objPartnerGMSerialDetail.MaterialCode;
objReplacementOrderSerialDetail.MatGroup1Code = objPartnerGMSerialDetail.MatGroup1Code;
objReplacementOrderSerialDetail.PartnerCode = objPartnerGMSerialDetail.PartnerCode;
objReplacementOrderSerialDetail.PartnerEmployeeCode = objPartnerGMSerialDetail.PartnerEmployeeCode;
objReplacementOrderSerialDetail.OrderQty = 1;
objReplacementOrderSerialDetail.UOMCode = objPartnerGMDetail.UOMCode;
objReplacementOrderSerialDetail.ReceivedQty = 0;
objReplacementOrderSerialDetail.RepOrderStatus = "OPEN";
objReplacementOrderSerialDetail.IssueDocCode = objPartnerGMSerialDetail.PGoodsMovementCode;
objReplacementOrderSerialDetail.IssueDocItemNo = objPartnerGMSerialDetail.ItemNo;
objReplacementOrderSerialDetail.ToPartnerCode = objPartnerGMSerialDetail.ToPartnerCode;
objReplacementOrderSerialDetail.ClientCode = argPartnerGoodsMovement.ClientCode;
objReplacementOrderSerialDetail.CreatedBy = argPartnerGoodsMovement.CreatedBy;
objReplacementOrderSerialDetail.ModifiedBy = argPartnerGoodsMovement.ModifiedBy;
objReplacementOrderSerialDetail.IsDeleted = 0;
argReplacementOrderSerialDetailCol.colReplacementOrderSerialDetail.Add(objReplacementOrderSerialDetail);
}
}
}
if (argReplacementOrderDetailCol.colReplacementOrderDetail.Count > 0)
{
objReplaceOrderManager.SaveReplacementOrder(objRepalcementOrder, argReplacementOrderDetailCol, argReplacementOrderSerialDetailCol, da, lstErr);
foreach (ErrorHandler objerr in lstErr)
{
if (objerr.Type == "E")
{
errorcol.colErrorHandler.Add(objerr);
da.ROLLBACK_TRANSACTION();
return(errorcol);
}
if (objerr.Type == "A")
{
errorcol.colErrorHandler.Add(objerr);
da.ROLLBACK_TRANSACTION();
return(errorcol);
}
}
}
}
/******************************/
}
da.COMMIT_TRANSACTION();
}
catch (Exception ex)
{
if (da != null)
{
da.ROLLBACK_TRANSACTION();
}
objErrorHandler.Type = ErrorConstant.strAboartType;
objErrorHandler.MsgId = 0;
objErrorHandler.Module = ErrorConstant.strInsertModule;
objErrorHandler.ModulePart = ErrorConstant.strMasterModule;
objErrorHandler.Message = ex.Message.ToString();
objErrorHandler.RowNo = 0;
objErrorHandler.FieldName = "";
objErrorHandler.LogCode = "";
lstErr.Add(objErrorHandler);
errorcol.colErrorHandler.Add(objErrorHandler);
}
finally
{
if (da != null)
{
da.Close_Connection();
da = null;
}
}
return(errorcol);
}
