public ReplacementOrder objGetReplacementOrder(string argRepOrderCode, string argClientCode)
{
ReplacementOrder argReplacementOrder = new ReplacementOrder();
DataSet DataSetToFill = new DataSet();
if (argRepOrderCode.Trim() == "")
{
goto ErrorHandlers;
}
if (argClientCode.Trim() == "")
{
goto ErrorHandlers;
}
DataSetToFill = this.GetReplacementOrder(argRepOrderCode, argClientCode);
if (DataSetToFill.Tables[0].Rows.Count <= 0)
{
goto Finish;
}
argReplacementOrder = this.objCreateReplacementOrder((DataRow)DataSetToFill.Tables[0].Rows[0]);
goto Finish;
ErrorHandlers:
Finish:
DataSetToFill = null;
return(argReplacementOrder);
}
private ReplacementOrder objCreateReplacementOrder(DataRow dr)
{
ReplacementOrder tReplacementOrder = new ReplacementOrder();
tReplacementOrder.SetObjectInfo(dr);
return(tReplacementOrder);
}
public string UpdateReplacementOrder(ReplacementOrder argReplacementOrder, DataAccess da, List <ErrorHandler> lstErr)
{
SqlParameter[] param = new SqlParameter[15];
param[0] = new SqlParameter("@RepOrderCode", argReplacementOrder.RepOrderCode);
param[1] = new SqlParameter("@RepOrderDocTypeCode", argReplacementOrder.RepOrderDocTypeCode);
param[2] = new SqlParameter("@RepOrderDate", argReplacementOrder.RepOrderDate);
param[3] = new SqlParameter("@TotalQuantity", argReplacementOrder.TotalQuantity);
param[4] = new SqlParameter("@RepOrderStatus", argReplacementOrder.RepOrderStatus);
param[5] = new SqlParameter("@IssueDocCode", argReplacementOrder.IssueDocCode);
param[6] = new SqlParameter("@PartnerCode", argReplacementOrder.PartnerCode);
param[7] = new SqlParameter("@ToPartnerCode", argReplacementOrder.ToPartnerCode);
param[8] = new SqlParameter("@OrderType", argReplacementOrder.OrderType);
param[9] = new SqlParameter("@ClientCode", argReplacementOrder.ClientCode);
param[10] = new SqlParameter("@CreatedBy", argReplacementOrder.CreatedBy);
param[11] = new SqlParameter("@ModifiedBy", argReplacementOrder.ModifiedBy);
param[12] = new SqlParameter("@Type", SqlDbType.Char);
param[12].Size = 1;
param[12].Direction = ParameterDirection.Output;
param[13] = new SqlParameter("@Message", SqlDbType.VarChar);
param[13].Size = 255;
param[13].Direction = ParameterDirection.Output;
param[14] = new SqlParameter("@returnvalue", SqlDbType.VarChar);
param[14].Size = 20;
param[14].Direction = ParameterDirection.Output;
int i = da.NExecuteNonQuery("Proc_UpdateReplacementOrder", param);
string strMessage = Convert.ToString(param[13].Value);
string strType = Convert.ToString(param[12].Value);
string strRetValue = Convert.ToString(param[14].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);
return(strRetValue);
}
public ICollection <ReplacementOrder> colGetReplacementOrder(string argClientCode)
{
List <ReplacementOrder> lst = new List <ReplacementOrder>();
DataSet DataSetToFill = new DataSet();
ReplacementOrder tReplacementOrder = new ReplacementOrder();
DataSetToFill = this.GetReplacementOrder(argClientCode);
if (DataSetToFill != null)
{
foreach (DataRow dr in DataSetToFill.Tables[0].Rows)
{
lst.Add(objCreateReplacementOrder(dr));
}
}
goto Finish;
Finish:
DataSetToFill = null;
return(lst);
}
public void SaveReplacementOrder(ReplacementOrder argReplacementOrder, ReplacementOrderDetailCol argReplacementOrderDetailCol, ReplacementOrderSerialDetailCol argReplacementOrderSerialDetailCol, DataAccess da, List <ErrorHandler> lstErr)
{
try
{
string strRetValue = "";
if (blnIsReplacementOrderExists(argReplacementOrder.RepOrderCode, argReplacementOrder.ClientCode, da) == false)
{
strRetValue = InsertReplacementOrder(argReplacementOrder, da, lstErr);
}
else
{
strRetValue = UpdateReplacementOrder(argReplacementOrder, da, lstErr);
}
if (strRetValue != "")
{
if (argReplacementOrderDetailCol.colReplacementOrderDetail.Count > 0)
{
foreach (ReplacementOrderDetail objReplacementOrderDetail in argReplacementOrderDetailCol.colReplacementOrderDetail)
{
objReplacementOrderDetail.RepOrderCode = strRetValue;
if (objReplacementOrderDetail.IsDeleted == 0)
{
objReplacementOrderDetailMan.SaveReplacementOrderDetail(objReplacementOrderDetail, da, lstErr);
}
else
{
/*******************/
/** Call Delete Function **/
}
if (argReplacementOrderSerialDetailCol.colReplacementOrderSerialDetail.Count > 0)
{
foreach (ReplacementOrderSerialDetail objReplacementOrderSerialDetail in argReplacementOrderSerialDetailCol.colReplacementOrderSerialDetail)
{
if (objReplacementOrderSerialDetail.RepOrderItemNo == objReplacementOrderDetail.RepOrderItemNo)
{
objReplacementOrderSerialDetail.RepOrderCode = strRetValue;
if (objReplacementOrderSerialDetail.IsDeleted == 0)
{
objReplacementOrderSerialDetailManager.SaveReplacementOrderSerialDetail(objReplacementOrderSerialDetail, da, lstErr);
}
else
{
}
}
}
}
}
}
}
}
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);
}
}
public ICollection <ErrorHandler> SaveReplacementOrder(ReplacementOrder argReplacementOrder)
{
List <ErrorHandler> lstErr = new List <ErrorHandler>();
DataAccess da = new DataAccess();
try
{
if (blnIsReplacementOrderExists(argReplacementOrder.RepOrderCode, argReplacementOrder.ClientCode) == false)
{
da.Open_Connection();
da.BEGIN_TRANSACTION();
InsertReplacementOrder(argReplacementOrder, da, lstErr);
foreach (ErrorHandler objerr in lstErr)
{
if (objerr.Type == "E")
{
da.ROLLBACK_TRANSACTION();
return(lstErr);
}
}
}
else
{
da.Open_Connection();
da.BEGIN_TRANSACTION();
UpdateReplacementOrder(argReplacementOrder, da, lstErr);
foreach (ErrorHandler objerr in lstErr)
{
if (objerr.Type == "E")
{
da.ROLLBACK_TRANSACTION();
return(lstErr);
}
}
}
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);
}
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);
}