public void SaveDeliveryPartner(DeliveryPartner argDeliveryPartner, DataAccess da, List <ErrorHandler> lstErr) { try { if (blnIsDeliveryPartnerExists(argDeliveryPartner.DeliveryDocCode.Trim(), argDeliveryPartner.PFunctionCode.Trim(), argDeliveryPartner.ClientCode.Trim(), da) == false) { InsertDeliveryPartner(argDeliveryPartner, da, lstErr); } else { UpdateDeliveryPartner(argDeliveryPartner, 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 DeliveryPartner objCreateDeliveryPartner(DataRow dr) { DeliveryPartner tDeliveryPartner = new DeliveryPartner(); tDeliveryPartner.SetObjectInfo(dr); return(tDeliveryPartner); }
//public ICollection<ErrorHandler> SaveDeliveryPartner(DeliveryPartner argDeliveryPartner) //{ // List<ErrorHandler> lstErr = new List<ErrorHandler>(); // DataAccess da = new DataAccess(); // try // { // if (blnIsDeliveryPartnerExists(argDeliveryPartner.DeliveryDocCode, argDeliveryPartner.PFunctionCode, argDeliveryPartner.ClientCode,da) == false) // { // da.Open_Connection(); // da.BEGIN_TRANSACTION(); // InsertDeliveryPartner(argDeliveryPartner, da, lstErr); // foreach (ErrorHandler objerr in lstErr) // { // if (objerr.Type == "E") // { // da.ROLLBACK_TRANSACTION(); // return lstErr; // } // } // da.COMMIT_TRANSACTION(); // } // else // { // da.Open_Connection(); // da.BEGIN_TRANSACTION(); // UpdateDeliveryPartner(argDeliveryPartner, 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 void InsertDeliveryPartner(DeliveryPartner argDeliveryPartner, DataAccess da, List <ErrorHandler> lstErr) { SqlParameter[] param = new SqlParameter[10]; param[0] = new SqlParameter("@DeliveryDocCode", argDeliveryPartner.DeliveryDocCode); param[1] = new SqlParameter("@PFunctionCode", argDeliveryPartner.PFunctionCode); param[2] = new SqlParameter("@PartnerType", argDeliveryPartner.PartnerType); param[3] = new SqlParameter("@CustomerCode", argDeliveryPartner.CustomerCode); param[4] = new SqlParameter("@ClientCode", argDeliveryPartner.ClientCode); param[5] = new SqlParameter("@CreatedBy", argDeliveryPartner.CreatedBy); param[6] = new SqlParameter("@ModifiedBy", argDeliveryPartner.ModifiedBy); param[7] = new SqlParameter("@Type", SqlDbType.Char); param[7].Size = 1; param[7].Direction = ParameterDirection.Output; param[8] = new SqlParameter("@Message", SqlDbType.VarChar); param[8].Size = 255; param[8].Direction = ParameterDirection.Output; param[9] = new SqlParameter("@returnvalue", SqlDbType.VarChar); param[9].Size = 20; param[9].Direction = ParameterDirection.Output; int i = da.NExecuteNonQuery("Proc_InsertDeliveryPartner", param); string strMessage = Convert.ToString(param[8].Value); string strType = Convert.ToString(param[7].Value); string strRetValue = Convert.ToString(param[9].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 = ""; objErrorHandler.ReturnValue = strRetValue; lstErr.Add(objErrorHandler); }
public DeliveryPartner objGetDeliveryPartner(string argDeliveryDocCode, string argPFunctionCode, string argClientCode) { DeliveryPartner argDeliveryPartner = new DeliveryPartner(); DataSet DataSetToFill = new DataSet(); if (argDeliveryDocCode.Trim() == "") { goto ErrorHandlers; } if (argPFunctionCode.Trim() == "") { goto ErrorHandlers; } if (argClientCode.Trim() == "") { goto ErrorHandlers; } DataSetToFill = this.GetDeliveryPartner(argDeliveryDocCode, argPFunctionCode, argClientCode); if (DataSetToFill.Tables[0].Rows.Count <= 0) { goto Finish; } argDeliveryPartner = this.objCreateDeliveryPartner((DataRow)DataSetToFill.Tables[0].Rows[0]); goto Finish; ErrorHandlers: Finish: DataSetToFill = null; return(argDeliveryPartner); }
public ICollection <DeliveryPartner> colGetDeliveryPartner(string argDeliveryDocCode, string argClientCode) { List <DeliveryPartner> lst = new List <DeliveryPartner>(); DataSet DataSetToFill = new DataSet(); DeliveryPartner tDeliveryPartner = new DeliveryPartner(); DataSetToFill = this.GetDeliveryPartner(argDeliveryDocCode, argClientCode); if (DataSetToFill != null) { foreach (DataRow dr in DataSetToFill.Tables[0].Rows) { lst.Add(objCreateDeliveryPartner(dr)); } } goto Finish; Finish: DataSetToFill = null; return(lst); }
public ICollection <ErrorHandler> SaveDeliveryMaster(DeliveryMaster argDeliveryMaster, DataTable dtDeliveryPartner, ICollection <DeliveryDetail> colDeliveryDetail, ICollection <DeliverySerializeDetail> colDeliverySerialize) { List <ErrorHandler> lstErr = new List <ErrorHandler>(); DataAccess da = new DataAccess(); string strretValue = ""; try { da.Open_Connection(); da.BEGIN_TRANSACTION(); if (blnIsDeliveryMasterExists(argDeliveryMaster.DeliveryDocCode, argDeliveryMaster.ClientCode, da) == false) { strretValue = InsertDeliveryMaster(argDeliveryMaster, da, lstErr); } else { strretValue = UpdateDeliveryMaster(argDeliveryMaster, da, lstErr); } foreach (ErrorHandler objerr in lstErr) { if (objerr.Type == "E") { da.ROLLBACK_TRANSACTION(); return(lstErr); } if (objerr.Type == "A") { da.ROLLBACK_TRANSACTION(); return(lstErr); } } if (strretValue != "") { if (dtDeliveryPartner.Rows.Count > 0) { foreach (DataRow dr in dtDeliveryPartner.Rows) { if (Convert.ToInt32(dr["IsDeleted"]) == 0) { DeliveryPartner objDeliveryPartner = new DeliveryPartner(); objDeliveryPartner.DeliveryDocCode = strretValue.Trim(); objDeliveryPartner.PFunctionCode = Convert.ToString(dr["PFunctionCode"]).Trim(); objDeliveryPartner.CustomerCode = Convert.ToString(dr["CustomerCode"]).Trim(); objDeliveryPartner.PartnerType = Convert.ToString(dr["PartnerType"]).Trim(); objDeliveryPartner.ClientCode = Convert.ToString(dr["ClientCode"]).Trim(); objDeliveryPartner.CreatedBy = Convert.ToString(dr["CreatedBy"]).Trim(); objDeliveryPartner.ModifiedBy = Convert.ToString(dr["ModifiedBy"]).Trim(); objDeliveryPartnerManager.SaveDeliveryPartner(objDeliveryPartner, da, lstErr); } else { objDeliveryPartnerManager.DeleteDeliveryPartner(strretValue.Trim(), Convert.ToString(dr["PFunctionCode"]).Trim(), Convert.ToString(dr["ClientCode"]).Trim(), 1, da, lstErr); } } foreach (ErrorHandler objerr in lstErr) { if (objerr.Type == "E") { da.ROLLBACK_TRANSACTION(); return(lstErr); } if (objerr.Type == "A") { da.ROLLBACK_TRANSACTION(); return(lstErr); } } } if (colDeliveryDetail.Count > 0) { foreach (DeliveryDetail argDeliveryDetail in colDeliveryDetail) { argDeliveryDetail.DeliveryDocCode = Convert.ToString(strretValue); if (argDeliveryDetail.IsDeleted == 0) { objDeliveryDetailManager.SaveDeliveryDetail(argDeliveryDetail, da, lstErr); } else { objDeliveryDetailManager.DeleteDeliveryDetail(argDeliveryDetail.DeliveryDocCode, argDeliveryDetail.ItemNo, 1, argDeliveryDetail.ClientCode, da, lstErr); } } foreach (ErrorHandler objerr in lstErr) { if (objerr.Type == "E") { da.ROLLBACK_TRANSACTION(); return(lstErr); } if (objerr.Type == "A") { da.ROLLBACK_TRANSACTION(); return(lstErr); } } } if (colDeliverySerialize.Count > 0) { foreach (DeliverySerializeDetail argDeliverySerialize in colDeliverySerialize) { argDeliverySerialize.DeliveryDocCode = strretValue.Trim(); if (argDeliverySerialize.IsDeleted == 0) { objDeliverySerializeManager.SaveDeliverySerializeDetail(argDeliverySerialize, da, lstErr); } else { objDeliverySerializeManager.DeleteDeliverySerializeDetail(argDeliverySerialize.DeliveryDocCode, argDeliverySerialize.ItemNo, argDeliverySerialize.SerialNo, argDeliverySerialize.ClientCode, da, lstErr); } } foreach (ErrorHandler objerr in lstErr) { if (objerr.Type == "E") { da.ROLLBACK_TRANSACTION(); return(lstErr); } if (objerr.Type == "A") { 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); }