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