/// <summary>
/// Get All Records From v_GetAllQuotationForView
/// </summary>
/// <param name="ObjectName"></param>
/// <param name="ReferenceID"></param>
/// <returns></returns>
public DataSet GetAllQutationDetails(string ObjectName, string ReferenceID, string[] conn)
{
DataSet ds = new DataSet();
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
string[] strings = new string[] { };
strings = ReferenceID.Split(',');
long[] arrayIDs = strings.Select(x => long.Parse(x)).ToArray();
//List<v_GetAllQuotationForView> ObjQuotation = new List<v_GetAllQuotationForView>();
var ListofID = from a in arrayIDs.AsEnumerable()
select new { NewID = a };
XElement QuotationHeadList = new XElement("QuotationList", from a in ListofID
join m in ce.v_GetAllQuotationForView.AsEnumerable() on a.NewID equals m.ID into NewQuotationList
from rec in NewQuotationList.DefaultIfEmpty()
select new XElement("QuotationLst",
new XElement("ID", rec.ID == null ? 0 : rec.ID),
new XElement("QuotationNo", rec.QuotationNo == null ? "0" : rec.QuotationNo),
new XElement("QuotationDate", rec.QuotationDate == null ? DateTime.Now : rec.QuotationDate),
new XElement("QuotationStatus", rec.QuotationStatus == null ? "" : rec.QuotationStatus),
new XElement("QuotationValidityDays", rec.QuotationValidityDays == null ? 0 : rec.QuotationValidityDays),
new XElement("ExpectedOrderDate", rec.ExpectedOrderDate == null ? DateTime.Now : rec.ExpectedOrderDate),
new XElement("ExpOrderAmount", rec.ExpOrderAmount == null ? 0 : rec.ExpOrderAmount),
new XElement("LeadSource", rec.LeadSource == null ? "" : rec.LeadSource),
new XElement("OtherCharges", rec.OtherCharges == null ? 0 : rec.OtherCharges),
new XElement("ProductLevelTotalDiscount", rec.ProductLevelTotalDiscount == null ? 0 : rec.ProductLevelTotalDiscount),
new XElement("Sector", rec.Sector == null ? "" : rec.Sector),
new XElement("ShippingCharges", rec.ShippingCharges == null ? 0 : rec.ShippingCharges),
new XElement("TotalAfterDiscount", rec.TotalAfterDiscount == null ? 0 : rec.TotalAfterDiscount),
new XElement("TotalAmount", rec.TotalAmount == null ? 0 : rec.TotalAmount),
new XElement("TotalDiscount", rec.TotalDiscount == null ? 0 : rec.TotalDiscount),
new XElement("TotalTax", rec.TotalTax == null ? 0 : rec.TotalTax),
new XElement("DiscountOnSubTotal", rec.DiscountOnSubTotal == null ? 0 : rec.DiscountOnSubTotal),
new XElement("CustomerName", rec.CustomerName == null ? "" : rec.CustomerName),
new XElement("DiscountOnSubTotal", rec.DiscountOnSubTotal == null ? 0 : rec.DiscountOnSubTotal),
new XElement("EmailID", rec.EmailID == null ? "" : rec.EmailID),
new XElement("AddressLine1", rec.AddressLine1 == null ? "" : rec.AddressLine1 + " " + rec.City),
new XElement("ContactPersonName", rec.Name == null ? "" : rec.CompanyName)
));
ds.ReadXml(QuotationHeadList.CreateReader());
if (ds.Tables.Count <= 0)
{
ds.Tables.Add("Quotation");
}
return(ds);
}
public DataSet GetAllRecords(string ObjectName, string ReferenceID, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
DataSet ds = new DataSet();
string[] strings = new string[] { };
strings = ReferenceID.Split(',');
long[] arrayIDs = strings.Select(x => long.Parse(x)).ToArray();
var ListofID = from a in arrayIDs.AsEnumerable()
select new { NewID = a };
XElement QuotationHeadList = new XElement("QuotationList", from a in ListofID
join m in ce.v_GetAllQuotationForViewForReport.AsEnumerable() on a.NewID equals m.ID into NewQuotationList
from rec in NewQuotationList.DefaultIfEmpty()
where a.NewID == rec.ID
select new XElement("QuotationLst",
new XElement("ID", rec.ID == null ? 0 : rec.ID),
new XElement("QuotationNo", rec.QuotationNo == null ? "0" : rec.QuotationNo),
//new XElement("QuotationDate", rec.QuotationDate == null ? DateTime.Now : rec.QuotationDate),
new XElement("QuotationStatus", rec.QuotationStatus == null ? "" : rec.QuotationStatus),
new XElement("QuotationValidityDays", rec.QuotationValidityDays == null ? 0 : rec.QuotationValidityDays),
// new XElement("ExpectedOrderDate", rec.ExpectedOrderDate == null ? DateTime.Now : rec.ExpectedOrderDate),
new XElement("ExpOrderAmount", rec.ExpOrderAmount == null ? 0 : rec.ExpOrderAmount),
new XElement("LeadSource", rec.LeadSource == null ? "" : rec.LeadSource),
new XElement("OtherCharges", rec.OtherCharges == null ? 0 : rec.OtherCharges),
new XElement("ProductLevelTotalDiscount", rec.ProductLevelTotalDiscount == null ? 0 : rec.ProductLevelTotalDiscount),
new XElement("Sector", rec.Sector == null ? "" : rec.Sector),
new XElement("ShippingCharges", rec.ShippingCharges == null ? 0 : rec.ShippingCharges),
new XElement("TotalAfterDiscount", rec.TotalAfterDiscount == null ? 0 : rec.TotalAfterDiscount),
new XElement("TotalAmount", rec.TotalAmount == null ? 0 : rec.TotalAmount),
new XElement("TotalDiscount", rec.TotalDiscount == null ? 0 : rec.TotalDiscount),
new XElement("TotalTax", rec.TotalTax == null ? 0 : rec.TotalTax),
new XElement("DiscountOnSubTotal", rec.DiscountOnSubTotal == null ? 0 : rec.DiscountOnSubTotal),
new XElement("CustomerName", rec.CustomerName == null ? "" : rec.CustomerName),
new XElement("DiscountOnSubTotal", rec.DiscountOnSubTotal == null ? 0 : rec.DiscountOnSubTotal),
new XElement("EmailID", rec.EmailID == null ? "" : rec.EmailID),
new XElement("AddressLine1", rec.AddressLine1 == null ? "" : rec.AddressLine1 + " " + rec.City),
new XElement("ContactPersonName", rec.Name == null ? "" : rec.CompanyName),
new XElement("ProductID", rec.ProductID == null ? 0 : rec.ProductID),
new XElement("ProductCode", rec.ProductCode == null ? "0" : rec.ProductCode),
new XElement("ProductName", rec.ProductName == null ? "None" : rec.ProductName),
new XElement("ProductDescription", rec.ProductDescription == null ? "None" : rec.ProductDescription),
new XElement("UOMID", rec.UOMID == null ? 0 : rec.UOMID),
new XElement("UOM", rec.UOM == null ? "0" : rec.UOM),
new XElement("ProductPrice", rec.ProductPrice == null ? 0 : rec.ProductPrice),
new XElement("PerUnitDiscount", rec.PerUnitDiscount == null ? 0 : rec.PerUnitDiscount),
new XElement("IsDiscountPercent", rec.IsDiscountPercent == null ? false : rec.IsDiscountPercent),
new XElement("DiscountID", rec.DiscountID == null ? 0 : rec.DiscountID),
new XElement("RateAfterDiscount", rec.RateAfterDiscount == null ? 0 : rec.RateAfterDiscount),
new XElement("Quantity", rec.Quantity == null ? 0 : rec.Quantity),
new XElement("AmountAfterDiscount", rec.AmountAfterDiscount == null ? 0 : rec.AmountAfterDiscount),
new XElement("TotalTaxAmount", rec.TotalTaxAmount == null ? 0 : rec.TotalTaxAmount),
new XElement("AmountAfterTax", rec.AmountAfterTax == null ? 0 : rec.AmountAfterTax),
new XElement("Remark", rec.Remark == null ? "None" : rec.Remark),
new XElement("TermAndCondition", rec.Term == null ? "None" : rec.Term + "-" + rec.Condition)
));
ds.ReadXml(QuotationHeadList.CreateReader());
if (ds.Tables.Count <= 0)
{
ds.Tables.Add("Quotation");
}
return(ds);
}