public DataTable GetVendorDetailDataTable(string xmlDoc, string spName, ref string errorMessage) { try { DataSet ds = new DataSet(); DataTaskManager dt = new DataTaskManager(); using (DataTaskManager dtManager = new DataTaskManager()) { DBParameterList dbParam = new DBParameterList(); 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)); using (ds = dtManager.ExecuteDataSet(spName, dbParam)) { errorMessage = dbParam[Common.PARAM_OUTPUT].Value.ToString(); if (errorMessage.Length != 0) //No dbError { return(null); } } } return(ds.Tables[0]); } catch (Exception ex) { Common.LogException(ex); throw; } }
/// <summary> /// Returns all currencies for a given service center including inactive /// </summary> /// <param name="dbMessage">DB Message</param> /// <param name="locationCode">ServiceCenter Code</param> /// <returns></returns> private static List <Currency> GetCurrenciesForPOS(ref string dbMessage, string locationCode) { try { DBParameterList dbParamList = new DBParameterList(); dbParamList.Add(new DBParameter("@inputParam", locationCode, DbType.String)); dbParamList.Add(new DBParameter(Common.PARAM_OUTPUT, string.Empty, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); using (DataTaskManager dtManager = new DataTaskManager()) { using (DataTable dt = dtManager.ExecuteDataTable("usp_POSCurrencySearch", dbParamList)) { if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { Currency currency = new Currency(); currency.CurrencyCode = dt.Rows[i]["CurrencyCode"].ToString(); currency.ConversionRate = Convert.ToDouble(dt.Rows[i]["ConversionRate"]); currency.CurrencyName = dt.Rows[i]["CurrencyName"].ToString(); currency.IsBaseCurrency = Convert.ToBoolean(dt.Rows[i]["IsBaseCurrency"]); s_currencyList.Add(currency); } } } // update database message dbMessage = dbParamList[Common.PARAM_OUTPUT].Value.ToString(); } return(s_currencyList); } catch (Exception ex) { throw ex; } }
public DataTable GetIndentDetailForItem(int ItemID) { List <Item> lstItemsForConsolidation = new List <Item>(); DBParameterList dbParam; try { Vinculum.Framework.Data.DataTaskManager dtManager = new DataTaskManager(); //Declare and initialize the parameter list object. dbParam = new DBParameterList(); //Add the relevant 2 parameters dbParam.Add(new DBParameter("@ItemId", ItemID, DbType.Int32)); dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, string.Empty, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); // executing procedure to save the record DataSet ds = dtManager.ExecuteDataSet(SP_APPROVEDITEM_SEARCH, dbParam); //Populate the List Item from the grid if (ds != null && ds.Tables.Count > 0) { return(ds.Tables[0]); } return(null); } catch (Exception ex) { throw ex; } }
public DataTable IndentDetailSearchDataTable() { System.Data.DataSet dSet = new DataSet(); try { string errorMessage = string.Empty; string dbMessage = string.Empty; DBParameterList dbParam = new DBParameterList(); dbParam.Add(new DBParameter("@IndentNo", this.IndentNo, DbType.String)); dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, dbMessage, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); using (DataTaskManager dt = new DataTaskManager()) { dSet = dt.ExecuteDataSet(SP_INDENT_DETAIL_SEARCH, dbParam); if (dSet == null | dSet.Tables[0].Rows.Count <= 0) { return(null); } } } catch (Exception ex) { Common.LogException(ex); } return(dSet.Tables[0]); }
/// <summary> /// Search Header & Detail and return Dataset /// </summary> /// <param name="xmlDoc"></param> /// <param name="spName"></param> /// <param name="errorMessage"></param> /// <returns></returns> public DataSet Search_Header_Detail_DatSet(string xmlDoc, string spName, ref string errorMessage) { try { DataTaskManager dt = new DataTaskManager(); DataSet ds = new DataSet(); using (DataTaskManager dtManager = new DataTaskManager()) { DBParameterList dbParam = new DBParameterList(); 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)); ds = dtManager.ExecuteDataSet(spName, dbParam); { errorMessage = dbParam[Common.PARAM_OUTPUT].Value.ToString(); if (errorMessage != string.Empty) { return(null); } } } return(ds); } catch (Exception ex) { Common.LogException(ex); throw ex; } }
public static AppUser LogInUser(string userName, string password, string locationCode) { try { AppUser loggedInUser = null; string dbMessage = string.Empty; DBParameterList dbParam = new DBParameterList(); dbParam.Add(new DBParameter(Common.PARAM_DATA, userName, DbType.String)); dbParam.Add(new DBParameter(Common.PARAM_DATA2, string.Empty, DbType.String)); dbParam.Add(new DBParameter(Common.PARAM_DATA3, string.Empty, DbType.String)); dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, string.Empty, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); using (DataTaskManager dt = new DataTaskManager()) { object returnObject = dt.ExecuteScalar(SP_USER_SEARCH, dbParam); dbMessage = (returnObject == null)? string.Empty:returnObject.ToString(); if (dbMessage != string.Empty) { if ((new CryptographyManager(CryptographyProviderType.SymmetricCryptoProvider)).Decrypt(dbMessage).CompareTo(password) == 0) { loggedInUser = AppUser.Search(userName, locationCode); } } } return(loggedInUser); } catch (Exception ex) { throw ex; } }
public List <RetVendorDetails> GetVendorDetail(string xmlDoc, string spName, ref string errorMessage) { List <RetVendorDetails> listDeatil; try { listDeatil = new List <RetVendorDetails>(); DataTaskManager dt = new DataTaskManager(); using (DataTaskManager dtManager = new DataTaskManager()) { DBParameterList dbParam = new DBParameterList(); 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)); using (DataSet ds = dtManager.ExecuteDataSet(spName, dbParam)) { errorMessage = dbParam[Common.PARAM_OUTPUT].Value.ToString(); if (errorMessage.Length == 0 && ds != null && ds.Tables.Count > 0) //No dbError { foreach (DataRow drDeatils in ds.Tables[0].Rows) { RetVendorDetails obj = new RetVendorDetails(); obj.BatchNo = Convert.ToString(drDeatils["BatchNo"]); obj.ItemDescription = Convert.ToString(drDeatils["ItemName"]); obj.ItemCode = Convert.ToString(drDeatils["ItemCode"]); obj.PODate = Convert.ToDateTime(drDeatils["PODate"]).ToString(Common.DATE_TIME_FORMAT); //obj.DisplayPODate = Convert.ToDateTime(drDeatils["PODate"]).ToString(Common.DTP_DATE_FORMAT); obj.ItemId = Convert.ToInt32(drDeatils["ItemId"]); obj.POQty = Convert.ToDouble(drDeatils["POQty"]); obj.ReturnQty = Convert.ToInt32(drDeatils["ReturnQty"]); obj.PONumber = Convert.ToString(drDeatils["PONumber"]); obj.ReturnReason = Convert.ToString(drDeatils["ReturnReason"]); obj.Bucket = Convert.ToString(drDeatils["Bucket"]); obj.BucketId = Convert.ToInt32(drDeatils["BucketId"]); obj.AvailableQty = Convert.ToInt32(drDeatils["AvailableQty"]); obj.POAmount = Convert.ToDouble(drDeatils["POAmount"]); obj.GRNInvoiceNumber = drDeatils["GRNInvoiceNo"].ToString(); obj.GRNReceivedQty = Convert.ToDouble(drDeatils["GRNReceivedQty"]); obj.GRNInvoiceType = Convert.ToInt32(drDeatils["GRNInvoiceType"]); obj.LineTaxAmount = Convert.ToDecimal(drDeatils["LineTaxAmount"]); obj.ManufactureBatchNo = drDeatils["ManufactureBatchNo"].ToString(); listDeatil.Add(obj); } } } } return(listDeatil); } catch (Exception) { throw; } }
public List <IndentDetail> GetIndentDetail() { try { List <IndentDetail> _indentDetailList = new List <IndentDetail>(); string dbMessage = string.Empty; DBParameterList dbParam = new DBParameterList(); dbParam.Add(new DBParameter("@IndentNo", this.IndentNo, DbType.String)); dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, dbMessage, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); using (DataTaskManager dt = new DataTaskManager()) { System.Data.DataSet dSet = new DataSet(); dSet = dt.ExecuteDataSet(SP_GET_INDENT_DETAIL, dbParam); if (dbMessage.Trim().Equals(string.Empty) && dSet != null && dSet.Tables.Count > 0 && dSet.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dSet.Tables[0].Rows) { IndentDetail detail = new IndentDetail(); detail.CreateIndentDetailObject(dr); detail.GetPONO(dSet.Tables[1]); detail.GetTONO(dSet.Tables[2]); _indentDetailList.Add(detail); } } } return(_indentDetailList); } catch (Exception ex) { throw ex; } }
public bool Save(ref string dbMessage) { try { bool isSuccess = false; using (DataTaskManager dtManager = new DataTaskManager()) { DBParameterList dbParam; dbParam = new DBParameterList(); dbParam.Add(new DBParameter(Common.PARAM_DATA, Common.ToXml(this), DbType.String)); dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, dbMessage, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); DataTable dt = dtManager.ExecuteDataTable(SP_LOG_SAVE, dbParam); dbMessage = dbParam[Common.PARAM_OUTPUT].Value.ToString(); if (dt != null && string.IsNullOrEmpty(dbMessage)) { isSuccess = true; this.LogNo = dt.Rows[0]["LogNo"].ToString(); } } return(isSuccess); } catch (Exception ex) { throw ex; } }
public static POSItem Search(string itemBarcode, string locationCode, bool isKitOrder, int isFirstOrder, ref string dbMessage) { try { POSItem item = null; DBParameterList dbParamList = new DBParameterList(); List <POSItem> itemList = new List <POSItem>(); dbParamList.Add(new DBParameter("@itemBarcode", itemBarcode, DbType.String)); dbParamList.Add(new DBParameter("@inputParam", locationCode, DbType.String)); dbParamList.Add(new DBParameter("@isKitOrder", isKitOrder, DbType.Boolean)); dbParamList.Add(new DBParameter("@isFirstOrder", isFirstOrder, DbType.Int32)); dbParamList.Add(new DBParameter(Common.PARAM_OUTPUT, string.Empty, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); using (DataTaskManager dtManager = new DataTaskManager()) { DataSet ds = dtManager.ExecuteDataSet(SP_BarcodeItems_Search, dbParamList); if (ds != null) { DataRow[] rows = ds.Tables[0].Select(); item = CreateItem(rows[0]); } } return(item); } catch (Exception ex) { throw ex; } }
public static bool CheckBatchForLog(string LogNo, int locationId, ref string Message, ref DataTable dtItems) { System.Data.DataTable dTable = new DataTable(); DBParameterList dbParam; try { Vinculum.Framework.Data.DataTaskManager dtManager = new DataTaskManager(); // initialize the parameter list object dbParam = new DBParameterList(); dbParam.Add(new DBParameter("@logNo", LogNo, DbType.String)); dbParam.Add(new DBParameter("@locationId", locationId, DbType.Int32)); dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, string.Empty, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); dtItems = dtManager.ExecuteDataTable(SP_CI_LOGCHECK, dbParam); Message = dbParam[Common.PARAM_OUTPUT].Value.ToString(); // if an error returned from the database if (string.IsNullOrEmpty(Message)) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } }
public void getFromLocationStock(int Locationid, int ItemId) { System.Data.DataSet dSet = new DataSet(); try { string errorMessage = string.Empty; string dbMessage = string.Empty; DBParameterList dbParam = new DBParameterList(); dbParam.Add(new DBParameter("@Locationid", Locationid, DbType.Int16)); dbParam.Add(new DBParameter("@Itemid", ItemId, DbType.Int16)); dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, dbMessage, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); using (DataTaskManager dt = new DataTaskManager()) { dSet = dt.ExecuteDataSet(SP_ITEMWHLOCATION_STOCKDETAIL, dbParam); if (dSet == null | dSet.Tables[0].Rows.Count <= 0) { return; } this.whLocatinStock = Convert.ToDouble(dSet.Tables[0].Rows[0]["AvailableQuantity"]); } } catch (Exception ex) { Common.LogException(ex); } }
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 DataTable GetLocationCodes(int promoCategory, int conditionOn, DateTime startDate, DateTime endDate, ref string errorMessage) { DataTable dtLocationCodes = null; DBParameterList dbParam; using (DataTaskManager dtManager = new DataTaskManager()) { dbParam = new DBParameterList(); dbParam.Add(new DBParameter(Common.PARAM_DATA, promoCategory, DbType.Int32)); dbParam.Add(new DBParameter(Common.PARAM_DATA2, conditionOn, DbType.Int32)); dbParam.Add(new DBParameter(Common.PARAM_DATA3, startDate, DbType.DateTime)); dbParam.Add(new DBParameter(Common.PARAM_DATA4, endDate, DbType.DateTime)); dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, errorMessage, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); DataTable dt = dtManager.ExecuteDataTable("usp_PromotionCondtionCodes", dbParam); errorMessage = dbParam[Common.PARAM_OUTPUT].Value.ToString(); if (string.IsNullOrEmpty(errorMessage)) { if (dt.Rows.Count > 0) { dtLocationCodes = dt.Copy(); } } } return(dtLocationCodes); }
public bool CheckForValidReturnQty(string xmlDoc, ref string errorMessage) { bool isValid = true; System.Globalization.NumberFormatInfo nfi = new System.Globalization.NumberFormatInfo(); nfi.PercentDecimalDigits = Common.DisplayAmountRounding; string strRoundingZeroesFormat = Common.GetRoundingZeroes(Common.DisplayQtyRounding); //"0.00"; DataTaskManager dtDataMgr = new DataTaskManager(); using (DataTaskManager dtManager = new DataTaskManager()) { DBParameterList dbParam = new DBParameterList(); 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)); using (DataSet ds = dtDataMgr.ExecuteDataSet(SP_CHECK_RET_QTY, dbParam)) { string tempErrCode = dbParam[Common.PARAM_OUTPUT].Value.ToString(); if (!string.IsNullOrEmpty(tempErrCode)) { //errorMessage = Common.GetMessage(tempErr); DataTable dtTemp = ds.Tables[0]; decimal totGRNRecQty = Convert.ToDecimal(dtTemp.Rows[0]["TotalRemainingQty"].ToString()); errorMessage = Common.GetMessage(tempErrCode, totGRNRecQty.ToString(strRoundingZeroesFormat, nfi)); isValid = false; } } } return(isValid); }
public List <GiftVoucherDistributor> Search() { List <GiftVoucherDistributor> VoucherList = new List <GiftVoucherDistributor>(); System.Data.DataTable dTable = new DataTable(); try { string errorMessage = string.Empty; DBParameterList dbParam = new DBParameterList(); dbParam.Add(new DBParameter("@VoucherCode", GiftVoucherCode, DbType.String)); dbParam.Add(new DBParameter("@DistributorID", IssueTo, DbType.Int32)); dbParam.Add(new DBParameter("@Availed", Availed, DbType.Int32)); dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, string.Empty, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); dTable = GetSelectedRecords(dbParam, SP_GIFTVOUCHER_DISTRIBUTOR_SEARCH, ref errorMessage); if (dTable != null) { foreach (System.Data.DataRow drow in dTable.Rows) { GiftVoucherDistributor _voucher = CreateVoucherObject(drow); VoucherList.Add(_voucher); } } } catch (Exception ex) { throw ex; } return(VoucherList); }
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 List <RetVendorHeader> GetHeaderDetails(string xmlDoc, string spName, ref string errorMessage) { try { List <RetVendorHeader> listRetVendorHeader = new List <RetVendorHeader>(); DataTaskManager dt = new DataTaskManager(); using (DataTaskManager dtManager = new DataTaskManager()) { DBParameterList dbParam = new DBParameterList(); 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)); using (DataSet ds = dtManager.ExecuteDataSet(spName, dbParam)) { errorMessage = dbParam[Common.PARAM_OUTPUT].Value.ToString(); if (errorMessage.Length == 0 && ds != null && ds.Tables.Count > 0) //No dbError { foreach (DataRow drRetVendorHeader in ds.Tables[0].Rows) { RetVendorHeader objRetVendorHeader = new RetVendorHeader(); objRetVendorHeader.ReturnNo = Convert.ToString(drRetVendorHeader["ReturnNo"]); objRetVendorHeader.RetVendorDate = Convert.ToDateTime(drRetVendorHeader["RetVendorDate"]).ToString(Common.DATE_TIME_FORMAT); //objRetVendorHeader.DisplayRetVendorDate = Convert.ToDateTime(drRetVendorHeader["RetVendorDate"]).ToString(Common.DTP_DATE_FORMAT); objRetVendorHeader.ModifiedDate = Convert.ToDateTime(drRetVendorHeader["ModifiedDate"]).ToString(Common.DATE_TIME_FORMAT); objRetVendorHeader.LocationId = Convert.ToInt32(drRetVendorHeader["LocationId"]); objRetVendorHeader.VendorId = Convert.ToInt32(drRetVendorHeader["VendorId"]); objRetVendorHeader.Remarks = Convert.ToString(drRetVendorHeader["Remarks"]); objRetVendorHeader.Quantity = Convert.ToInt32(drRetVendorHeader["Quantity"]); objRetVendorHeader.ShippingDetails = Convert.ToString(drRetVendorHeader["ShippingDetails"]); objRetVendorHeader.ShipmentDate = drRetVendorHeader["ShipmentDate"].ToString().Trim() == string.Empty ? string.Empty : Convert.ToDateTime(drRetVendorHeader["ShipmentDate"]).ToString(Common.DATE_TIME_FORMAT); objRetVendorHeader.StatusName = Convert.ToString(drRetVendorHeader["StatusName"]); objRetVendorHeader.StatusId = Convert.ToInt32(drRetVendorHeader["StatusId"]); objRetVendorHeader.DebitNoteNumber = Convert.ToString(drRetVendorHeader["DebitNoteNumber"]); objRetVendorHeader.DebitNoteAmount = Math.Round(Convert.ToDouble(drRetVendorHeader["DebitNoteAmount"]), 2); objRetVendorHeader.TotalAmount = Math.Round(Convert.ToDouble(drRetVendorHeader["TotalAmount"]), 2); objRetVendorHeader.VendorName = Convert.ToString(drRetVendorHeader["VendorName"]); listRetVendorHeader.Add(objRetVendorHeader); } } } } return(listRetVendorHeader); } catch (Exception) { throw; } }
/// <summary> /// Get indent consolidation Data /// </summary> /// <param name="indentConsolidationRequest"></param> /// <param name="errorMessage"></param> /// <returns></returns> public DataSet GetIndentConsolidationData(IndentConsolidationRequest indentConsolidationRequest, ref String errorMessage) { string SP_NAME = "usp_GetIndentConsolidationData"; DataSet dsTemp = new DataSet(); //Get Items and Warehouse items detail 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, Common.ToXml(indentConsolidationRequest), DbType.String)); dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, string.Empty, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); dsTemp = dtManager.ExecuteDataSet(SP_NAME, dbParam); errorMessage = dbParam[Common.PARAM_OUTPUT].Value.ToString(); if (string.IsNullOrEmpty(errorMessage)) { if (dsTemp.Tables.Count > 0) { if (dsTemp.Tables[0].Rows.Count > 0) { foreach (DataRow drRow in dsTemp.Tables[0].Rows) { if (!string.IsNullOrEmpty(drRow["ApprovedQty"].ToString())) { drRow["ApprovedQty"] = Math.Round(Convert.ToDouble(drRow["ApprovedQty"].ToString()), Common.DisplayQtyRounding, MidpointRounding.AwayFromZero).ToString(); } if (!string.IsNullOrEmpty(drRow["TOIQty"].ToString())) { drRow["TOIQty"] = Math.Round(Convert.ToDouble(drRow["TOIQty"].ToString()), Common.DisplayQtyRounding, MidpointRounding.AwayFromZero).ToString(); } if (!string.IsNullOrEmpty(drRow["POQty"].ToString())) { drRow["POQty"] = Math.Round(Convert.ToDouble(drRow["POQty"].ToString()), Common.DisplayQtyRounding, MidpointRounding.AwayFromZero).ToString(); } if (!string.IsNullOrEmpty(drRow["WarehouseQtySum"].ToString())) { drRow["WarehouseQtySum"] = Math.Round(Convert.ToDouble(drRow["WarehouseQtySum"].ToString()), Common.DisplayAmountRounding, MidpointRounding.AwayFromZero).ToString(); } } } } } } return(dsTemp); }
public CODetail GetCODetail(string OrderNo, string ItemCode, int itemID, ref string errorMessage) { try { CODetail order = null; if (!OrderNo.Equals(string.Empty) && (!ItemCode.Equals(string.Empty) || itemID > 0)) { System.Data.DataTable dTable = new DataTable(); DBParameterList dbParam; try { Vinculum.Framework.Data.DataTaskManager dtManager = new DataTaskManager(); // initialize the parameter list object dbParam = new DBParameterList(); dbParam.Add(new DBParameter("@OrderNo", OrderNo, DbType.String)); dbParam.Add(new DBParameter("@ItemCode", ItemCode, DbType.String)); dbParam.Add(new DBParameter("@ItemID", itemID, DbType.Int32)); dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, string.Empty, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); // executing procedure to save the record dTable = dtManager.ExecuteDataTable(SP_CODETAIL_SEARCH, dbParam); // update database message errorMessage = dbParam[Common.PARAM_OUTPUT].Value.ToString(); // if an error returned from the database if (errorMessage != string.Empty) { return(null); } else if (dTable != null && dTable.Rows.Count == 1) { order = new CODetail(); order.CreateCODetailObject(dTable.Rows[0]); } } catch (Exception ex) { throw ex; } } return(order); } catch (Exception ex) { throw ex; } }
public string GetPromotionImage(int promotionID, string spName) { string fileName = null; DBParameterList dbParam; try { Vinculum.Framework.Data.DataTaskManager dtManager = new DataTaskManager(); // initialize the parameter list object dbParam = new DBParameterList(); // add the relevant 2 parameters dbParam.Add(new DBParameter("promotionID", promotionID, DbType.Int32)); // executing procedure to save the record DataTable dt = dtManager.ExecuteDataTable(spName, dbParam); if (dt == null || dt.Rows.Count <= 0) { return(null); } fileName = Convert.ToString(dt.Rows[0]["WebImage"]); } catch (Exception ex) { throw ex; } return(fileName); }
/// <summary> /// Method to fetch Parameter Data /// </summary> /// <param name="key">Parameter Identifier</param> /// <param name="filter">Parameter Filter Criteria</param> /// <returns></returns> /// //public static public static DataTable TaxLookup(TaxEnum key) { DBParameterList dbParam = null; try { dbParam = new DBParameterList(); dbParam.Add(new DBParameter("@TaxParameter", (int)key, DbType.Int16)); dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, string.Empty, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); using (DataTaskManager dtManager = new DataTaskManager()) { return(dtManager.ExecuteDataTable(SP_TAX_SEARCH, dbParam)); } } catch { throw; } }
public static List <POSPayments> Search(ref string dbMessage) { try { DBParameterList dbParamList = new DBParameterList(); List <POSPayments> paymentList = new List <POSPayments>(); int Mode = 1; if (Common.IsMiniBranchLocation == 1) { Mode = 2; } else { Mode = 1; } //dbParamList.Add(new DBParameter("@businessLineId", Common.BusinessLine, DbType.String)); dbParamList.Add(new DBParameter(Common.PARAM_MODE, Mode, DbType.Int32)); dbParamList.Add(new DBParameter(Common.PARAM_OUTPUT, string.Empty, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); using (DataTaskManager dtManager = new DataTaskManager()) { DataTable dt = dtManager.ExecuteDataTable(SP_PAYMENT_TYPES_SEARCH, dbParamList); if (dt != null) { DataRow[] firstLevelRows = dt.Select("Level = 1"); foreach (DataRow dr in firstLevelRows) { //POSTypes serviceType = new POSTypes(dr["Id"].ToString(), dr["ShortDescription"].ToString(), dr["CustomerTypeId"].ToString(), dr["ReceiptDisplay"].ToString(), dr["ParentType"].ToString(), Convert.ToUInt16(dr["Level"]), Convert.ToDecimal(dr["Price"])); POSPayments payment = CreatePayment(dr); DataRow[] childRows = dt.Select("ParentType = '" + payment.PaymentModeId + "'"); if (childRows.Length > 0) { AddPaymentHierarchy(childRows, payment, dt); } paymentList.Add(payment); } } } return(paymentList); } catch (Exception ex) { throw ex; } }
// Added By Garima (11 Dec 2009) public List <Item> GetAppovedItemsForConsolidation() { List <Item> lstItemsForConsolidation = new List <Item>(); DBParameterList dbParam; try { Vinculum.Framework.Data.DataTaskManager dtManager = new DataTaskManager(); //Declare and initialize the parameter list object. dbParam = new DBParameterList(); //Add the relevant 2 parameters dbParam.Add(new DBParameter("@ItemId", -1, DbType.Int32)); dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, string.Empty, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); // executing procedure to save the record DataSet ds = dtManager.ExecuteDataSet(SP_APPROVEDITEM_SEARCH, dbParam); //Populate the List Item from the grid if (ds != null && ds.Tables.Count > 0) { if (ds.Tables[0] != null) { foreach (DataRow drRow in ds.Tables[0].Rows) { Item tmpApprovedItem = new Item(); tmpApprovedItem.ItemId = Convert.ToInt32(drRow["ITEMID"]); tmpApprovedItem.ItemCode = drRow["ITEMCODE"].ToString(); tmpApprovedItem.ItemName = drRow["ITEMNAME"].ToString(); tmpApprovedItem.Selected = false; tmpApprovedItem.IsComposite = Convert.ToBoolean(drRow["ISCOMPOSITE"]); tmpApprovedItem.ApprovedQty = Convert.ToDecimal(drRow["APPROVEDQTY"]); lstItemsForConsolidation.Add(tmpApprovedItem); } } } return(lstItemsForConsolidation); } catch (Exception ex) { throw ex; } }
public DataTable GetPODetails(RetVendorDetails objDetails, string xmlDoc, string spName, ref string errorMessage) { try { DataTable dtVendor = new DataTable(); DataTaskManager dt = new DataTaskManager(); using (DataTaskManager dtManager = new DataTaskManager()) { DBParameterList dbParam = new DBParameterList(); 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)); using (DataSet ds = dtManager.ExecuteDataSet(spName, dbParam)) { errorMessage = dbParam[Common.PARAM_OUTPUT].Value.ToString(); if (errorMessage.Length == 0 && ds != null && ds.Tables.Count > 0) //No dbError { dtVendor = ds.Tables[0]; if (ds.Tables[0].Rows.Count == 1) { objDetails.PODate = Convert.ToDateTime(ds.Tables[0].Rows[0]["PODate"]).ToString(Common.DATE_TIME_FORMAT); //objDetails.DisplayPODate = Convert.ToDateTime(ds.Tables[0].Rows[0]["PODate"]).ToString(Common.DTP_DATE_FORMAT); objDetails.PONumber = Convert.ToString(ds.Tables[0].Rows[0]["PONumber"]); objDetails.POQty = Convert.ToInt32(ds.Tables[0].Rows[0]["POQty"]); objDetails.POAmount = Convert.ToDouble(ds.Tables[0].Rows[0]["MRP"]); } else { } } } } return(dtVendor); } catch (Exception) { throw; } }
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 static List <POSItem> Search(string locationCode, bool isKitOrder, int isFirstOrder, ref string dbMessage) { try { DBParameterList dbParamList = new DBParameterList(); List <POSItem> itemList = new List <POSItem>(); dbParamList.Add(new DBParameter("@inputParam", locationCode, DbType.String)); dbParamList.Add(new DBParameter("@isKitOrder", isKitOrder, DbType.Boolean)); dbParamList.Add(new DBParameter("@isFirstOrder", isFirstOrder, DbType.Int32)); dbParamList.Add(new DBParameter("@forSkinCareItem", Common.ForSkinCareItem, DbType.Boolean)); dbParamList.Add(new DBParameter(Common.PARAM_OUTPUT, string.Empty, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); using (DataTaskManager dtManager = new DataTaskManager()) { DataSet ds = dtManager.ExecuteDataSet(SP_ITEMS_SEARCH, dbParamList); if (ds != null) { if (ds.Tables.Count > 2) { int min = Convert.ToInt32(ds.Tables[0].Rows[0]["Min"]); int max = Convert.ToInt32(ds.Tables[0].Rows[0]["Max"]); DataRow[] rows = ds.Tables[1].Select("Level = " + min); for (int i = 0; i < rows.Length; i++) { POSItem item = CreateItem(rows[i]); AddHierarchyChildren(item, ds, ds.Tables[1], max); if (item.POSItems.Count > 0) { itemList.Add(item); } } } } } return(itemList); } catch (Exception ex) { throw ex; } }
public DataTable SearchForPOandTO(int indentConsolidationId, ref string errorMessage) { string USP_INDENT_SEARCH = "usp_IndentConsolidationSearch"; DBParameterList dbParam; DataTable dt = null; using (DataTaskManager dtManager = new DataTaskManager()) { dbParam = new DBParameterList(); dbParam.Add(new DBParameter(Common.PARAM_DATA, string.Empty, DbType.String)); dbParam.Add(new DBParameter(Common.PARAM_DATA2, indentConsolidationId, DbType.Int32)); dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, errorMessage, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); dt = dtManager.ExecuteDataTable(USP_INDENT_SEARCH, dbParam); errorMessage = dbParam[Common.PARAM_OUTPUT].Value.ToString(); } return(dt); }