public bool Save(ref string errorMessage) { DataTaskManager dtManager = null; try { DBParameterList dbParam; bool isSuccess = false; using (dtManager = new DataTaskManager()) { try { dtManager.BeginTransaction(); { string xmlDoc = Common.ToXml(this); dbParam = new DBParameterList(); dbParam.Add(new DBParameter(Common.PARAM_DATA, xmlDoc, DbType.String)); dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, errorMessage, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); DataTable dt = dtManager.ExecuteDataTable(SP_CI_SAVE, dbParam); errorMessage = dbParam[Common.PARAM_OUTPUT].Value.ToString(); { if (errorMessage.Length > 0) { isSuccess = false; dtManager.RollbackTransaction(); } else { isSuccess = true; dtManager.CommitTransaction(); this.InvoiceNo = Convert.ToString(dt.Rows[0]["InvoiceNo"]); } } } } catch (Exception ex) { if (dtManager != null) { dtManager.RollbackTransaction(); } throw ex; } } return(isSuccess); } catch (Exception ex) { throw ex; } }
/// <summary> /// save pack/unpack details /// </summary> /// <param name="xmlDoc"></param> /// <param name="spName"></param> /// <param name="errorMessage"></param> /// <returns></returns> public bool PUSave(string xmlDoc, string spName, ref string errorMessage) { bool isSuccess = false; try { using (DataTaskManager dtManager = new DataTaskManager()) { //Declare and initialize the parameter list object DBParameterList dbParam = new DBParameterList(); //Add the relevant 2 parameters dbParam.Add(new DBParameter(Common.PARAM_DATA, xmlDoc, DbType.String)); dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, string.Empty, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); try { //Begin the transaction and executing procedure to save the record(s) dtManager.BeginTransaction(); // executing procedure to save the record DataSet ds; ds = dtManager.ExecuteDataSet(spName, dbParam); //Update database message errorMessage = dbParam[Common.PARAM_OUTPUT].Value.ToString(); //If an error returned from the database if (errorMessage.Length > 0) { dtManager.RollbackTransaction(); isSuccess = false; } else { dtManager.CommitTransaction(); isSuccess = true; } } catch (Exception ex) { dtManager.RollbackTransaction(); throw ex; } } } catch (Exception ex) { throw ex; } return(isSuccess); }
public virtual bool RetVendorSave(string xmlDoc, string spName, ref string errorMessage) { bool isSuccess = false; try { DBParameterList dbParam; using (DataTaskManager dtManager = new DataTaskManager()) { try { // initialize the parameter list object dbParam = new DBParameterList(); // add the relevant 2 parameters dbParam.Add(new DBParameter(Common.PARAM_DATA, xmlDoc, DbType.String)); dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, string.Empty, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); // begin the transaction dtManager.BeginTransaction(); // executing procedure to save the record DataTable dt = dtManager.ExecuteDataTable(spName, dbParam); // update database message errorMessage = dbParam[Common.PARAM_OUTPUT].Value.ToString(); // if an error returned from the database if (errorMessage != string.Empty) { isSuccess = false; dtManager.RollbackTransaction(); } else { this.ReturnNo = dt.Rows[0]["ReturnNo"].ToString(); this.ModifiedDate = (dt.Rows[0]["ModifiedDate"]).ToString(); this.DebitNoteNo = dt.Rows[0]["DebitNoteNumber"].ToString(); this.ShippingDate = dt.Rows[0]["ShippingDate"].ToString(); dtManager.CommitTransaction(); isSuccess = true; } } catch (Exception ex) { Common.LogException(ex); dtManager.RollbackTransaction(); } } } catch (Exception ex) { Common.LogException(ex); } return(isSuccess); }
public bool Save(string xmlDoc, string spName, ref Int32 promotionId, ref string errorMessage) { DBParameterList dbParam; bool isSuccess = false; using (DataTaskManager dtManager = new DataTaskManager()) { dtManager.BeginTransaction(); { dbParam = new DBParameterList(); dbParam.Add(new DBParameter(Common.PARAM_DATA, xmlDoc, DbType.String)); dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, errorMessage, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); DataTable dt = dtManager.ExecuteDataTable(spName, dbParam); errorMessage = dbParam[Common.PARAM_OUTPUT].Value.ToString(); if (errorMessage.Length > 0) { isSuccess = false; dtManager.RollbackTransaction(); } else { isSuccess = true; promotionId = Convert.ToInt32(dt.Rows[0]["PromotionId"]); dtManager.CommitTransaction(); } } } return(isSuccess); }
public bool Save(ref string errorMessage, bool amend) { try { DBParameterList dbParam; using (DataTaskManager dtManager = new DataTaskManager()) { try { dtManager.BeginTransaction(); string xmlDoc = Common.ToXml(this); dbParam = new DBParameterList(); dbParam.Add(new DBParameter(Common.PARAM_DATA, xmlDoc, DbType.String)); dbParam.Add(new DBParameter("@amend", amend, DbType.Boolean)); dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, errorMessage, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); DataTable dt = dtManager.ExecuteDataTable(SP_PO_SAVE, dbParam); errorMessage = dbParam[Common.PARAM_OUTPUT].Value.ToString(); if (errorMessage.Length > 0) { dtManager.RollbackTransaction(); return(false); } else { this.PONumber = Convert.ToString(dt.Rows[0]["PoNo"]); dtManager.CommitTransaction(); return(true); } } catch (Exception ex) { dtManager.RollbackTransaction(); throw ex; } } } catch (Exception ex) { throw ex; } }
public bool ProcessLog(string logNo, int LocationID, int userID, List <CO> lstCo, ref String ErrorCode) { try { bool isSuccess = false; bool isValid = true; string errorMessage = string.Empty; //Check Batch Qty Not Available for all Items of orders //isValid = CI.CheckBatchForLog(logNo, LocationID, ref errorMessage); //if (isValid) { List <CI> CIList = new List <CI>(); errorMessage = string.Empty; if (lstCo != null && lstCo.Count > 0) { DataTaskManager dtManager = null; try { using (dtManager = new DataTaskManager()) { //dtManager.BeginTransaction(); try { foreach (CO o in lstCo) { dtManager.BeginTransaction(); CO COrder = new CO(); COrder.GetCOAllDetails(o.CustomerOrderNo, -1); errorMessage = string.Empty; List <CIBatchDetail> ListBatch = CIBatchDetail.GetDefaultBatch(COrder.CustomerOrderNo, LocationID, ref errorMessage); CI invoice = CreateInvoiceObject(COrder, ListBatch, userID); if (invoice != null) { string ValidationCode = string.Empty; isValid = invoice.ValidateInvoice(COrder.CODetailList, ListBatch, ref ValidationCode); errorMessage = errorMessage + ValidationCode; if (isValid) { bool isSaved = invoice.Save(ref ValidationCode); if (!isSaved) { isSuccess = false; ErrorCode = ValidationCode; dtManager.RollbackTransaction(); //return isSuccess; } else { dtManager.CommitTransaction(); ErrorCode = string.Empty; isSuccess = true; } } else { if (ValidationCode == "40007") { // Not sufficent Batch Qty present ErrorCode = "40008"; } else { ErrorCode = ValidationCode; } isSuccess = false; dtManager.RollbackTransaction(); //break; } } else { ErrorCode = "40029," + COrder.CustomerOrderNo; isSuccess = false; dtManager.RollbackTransaction(); break; } } //dtManager.CommitTransaction(); //ErrorCode = string.Empty; //isSuccess = true; //return isSuccess; } catch (Exception ex) { throw ex; } } //return isSuccess; } catch (Exception ex) { Common.LogException(ex); } } else { //No Order found in confirmed status ErrorCode = "40011"; } } // Error in batch qty check ////else if (!errorMessage.Trim().Equals(string.Empty)) //{ // if (errorMessage.Trim().IndexOf("30001:") >= 0) // { // throw new Exception(errorMessage.Trim()); // } // else // { // ErrorCode = errorMessage.Trim(); // } //} if (!errorMessage.Equals("")) { MessageBox.Show(errorMessage, Common.GetMessage("10004"), MessageBoxButtons.OK, MessageBoxIcon.Information); } return(isSuccess); } catch (Exception ex) { throw ex; } }
public bool ProcessLog(string logNo, int LocationID, int userID, ref String ErrorCode, ref DataTable dtItems) { try { bool isSuccess = false; bool isValid = true; string errorMessage = string.Empty; //Check Batch Qty Not Available for all Items of orders isValid = CI.CheckBatchForLog(logNo, LocationID, ref errorMessage, ref dtItems); if (isValid) { List <CI> CIList = new List <CI>(); CO order = new CO(); order.LogNo = logNo; order.Status = (int)Common.OrderStatus.Confirmed; errorMessage = string.Empty; List <CO> lstCo = order.Search(ref errorMessage); if (errorMessage.Equals(string.Empty) && lstCo != null && lstCo.Count > 0) { DataTaskManager dtManager = null; try { using (dtManager = new DataTaskManager()) { dtManager.BeginTransaction(); try { foreach (CO o in lstCo) { CO m_Order = new CO(); m_Order.GetCOAllDetails(o.CustomerOrderNo, -1); errorMessage = string.Empty; List <CIBatchDetail> ListBatch = CIBatchDetail.GetDefaultBatch(m_Order.CustomerOrderNo, LocationID, ref errorMessage); CI invoice = CreateInvoiceObject(m_Order, ListBatch, userID); if (invoice != null) { string ValidationCode = string.Empty; isValid = invoice.ValidateInvoice(m_Order.CODetailList, ListBatch, ref ValidationCode); if (isValid) { bool isSaved = invoice.Save(ref ValidationCode); if (!isSaved) { isSuccess = false; dtManager.RollbackTransaction(); } } else { if (ValidationCode == "40007") { // Not sufficent Batch Qty present ErrorCode = "40008"; } else { ErrorCode = ValidationCode; } isSuccess = false; dtManager.RollbackTransaction(); break; } } else { ErrorCode = "40029," + m_Order.CustomerOrderNo; isSuccess = false; dtManager.RollbackTransaction(); break; } } dtManager.CommitTransaction(); ErrorCode = string.Empty; isSuccess = true; } catch (Exception ex) { throw ex; } } } catch (Exception ex) { Common.LogException(ex); } } else { //No Order found in confirmed status ErrorCode = "40011"; } } // Error in batch qty check else if (!errorMessage.Trim().Equals(string.Empty)) { if (errorMessage.Trim().IndexOf("30001:") >= 0) { throw new Exception(errorMessage.Trim()); } else { ErrorCode = errorMessage.Trim(); } } return(isSuccess); } catch (Exception ex) { throw ex; } }