public ActionResult GetRfqItems(string id)
{
var masterdetails = _context.OfferMasters.FirstOrDefault(o => o.OfferId == id);
int masterid = masterdetails.Id;
var supplier = _context.Suppliers.FirstOrDefault(s => s.Id == masterdetails.SupplierId);
var formData = HttpContext.Request.Form;
using (var db = new DataTables.Database("sqlserver", @"Data Source=192.168.2.4;Initial Catalog=AppaMVC; User=PLANET; Password=PLANET74110;"))
{
var response = new Editor(db, "SupplierPriceLineItems")
.Model <SupplierEditModel>()
.Field(new Field("SupplierPriceLineItems.Id", "supplierlineid")
)
.Field(new Field("LineItems.Id", "lineitemid")
)
.Field(new Field("LineItems.Number")
.Validator(Validation.NotEmpty())
)
.Field(new Field("LineItems.Impa")
.Validator(Validation.NotEmpty())
)
.Field(new Field("LineItems.Description"))
.Field(new Field("LineItems.Unit")
.Validator(Validation.NotEmpty())
)
.Field(new Field("LineItems.Qtty")
.Validator(Validation.Numeric())
.SetFormatter(Format.IfEmpty(null))
)
.Field(new Field("SupplierPriceLineItems.SupplierPrice")
)
.Field(new Field("SupplierPriceLineItems.Comment"))
.Field(new Field("SupplierPriceLineItems.Currency"))
.Field(new Field("SupplierPriceLineItems.Vat"))
.Where("Deleted", 0)
.Where("OfferMasterId", masterid)
.LeftJoin("LineItems", "SupplierPriceLineItems.LineItemId", "=", "LineItems.id")
.Process(formData)
.Data();
return(Json(response, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetRfqItems(int id)
{
var formData = HttpContext.Request.Form;
using (var db = new DataTables.Database("sqlserver", @"Data Source=192.168.2.4;Initial Catalog=AppaMVC; User=PLANET; Password=PLANET74110;"))
{
var response = new Editor(db, "LineItems")
.Model <LineItemEditModel>()
.Field(new Field("Number")
.Validator(Validation.NotEmpty())
)
.Field(new Field("Impa")
.Validator(Validation.NotEmpty())
)
.Field(new Field("Description"))
.Field(new Field("Unit")
.Validator(Validation.NotEmpty())
)
.Field(new Field("Qtty")
.Validator(Validation.Numeric())
.SetFormatter(Format.IfEmpty(null))
)
.Field(new Field("Price")
)
.Field(new Field("Remark"))
.Field(new Field("AltUnit"))
.Field(new Field("AltQtty"))
.Field(new Field("AltPrice"))
.Field(new Field("SelectedSupplierName"))
.Field(new Field("SelectedSupplierCalculatedPrice")
.Validator(Validation.Numeric())
.SetFormatter(Format.IfEmpty(null))
)
.Field(new Field("SelectedSupplierRemark"))
.Where("IsRemoved", 0)
.Where("ReferanceNumberId", id)
.Process(formData)
.Data();
return(Json(response, JsonRequestBehavior.AllowGet));
}
}
