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);
}