public ActionResult Edit(InvoiceItem InvoiceItem)
{
InvoiceItem oInvoiceItem = new InvoiceItem();
oInvoiceItem.InvoiceID = System.Convert.ToInt32(InvoiceItem.InvoiceID);
oInvoiceItem.InvoiceItemID = System.Convert.ToInt32(InvoiceItem.InvoiceItemID);
oInvoiceItem = InvoiceItemData.Select_Record(InvoiceItem);
if (ModelState.IsValid)
{
bool bSucess = false;
bSucess = InvoiceItemData.Update(oInvoiceItem, InvoiceItem);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Update");
}
}
// ComboBox
ViewData["InvoiceID"] = new SelectList(InvoiceItem_InvoiceData.List(), "InvoiceID", "InvoiceID", InvoiceItem.InvoiceID);
return(View(InvoiceItem));
}
} // Map function closer
public List <SqlParameter> MapParamsForUpsert(InvoiceItemData entity)
{
var sql_params = new List <SqlParameter>();
sql_params.Add(new SqlParameter("@invoice_item_key", entity.InvoiceItemKey));
sql_params.Add(new SqlParameter("@invoice_key", entity.InvoiceKey));
sql_params.Add(new SqlParameter("@invoice_item_seq", entity.InvoiceItemSeq));
sql_params.Add(new SqlParameter("@product_key", entity.ProductKey));
sql_params.Add(new SqlParameter("@product_name", entity.ProductName));
sql_params.Add(new SqlParameter("@product_desc", entity.ProductDesc));
sql_params.Add(new SqlParameter("@invoice_item_quantity", entity.InvoiceItemQuantity));
sql_params.Add(new SqlParameter("@shipto_addr_key", entity.ShiptoAddrKey));
sql_params.Add(new SqlParameter("@billto_addr_key", entity.BilltoAddrKey));
sql_params.Add(new SqlParameter("@invoice_item_entry_date", entity.InvoiceItemEntryDate));
sql_params.Add(new SqlParameter("@order_item_ship_date", entity.OrderItemShipDate));
sql_params.Add(new SqlParameter("@invoice_item_complete_date", entity.InvoiceItemCompleteDate));
sql_params.Add(new SqlParameter("@invoice_item_price_per", entity.InvoiceItemPricePer));
sql_params.Add(new SqlParameter("@invoice_item_line_sum", entity.InvoiceItemLineSum));
sql_params.Add(new SqlParameter("@invoice_item_account_rep_key", entity.InvoiceItemAccountRepKey));
sql_params.Add(new SqlParameter("@invoice_item_sales_rep_key", entity.InvoiceItemSalesRepKey));
sql_params.Add(new SqlParameter("@invoice_item_status_key", entity.InvoiceItemStatusKey));
sql_params.Add(new SqlParameter("@order_item_key", entity.OrderItemKey));
sql_params.Add(GetOutParam());
return(sql_params);
}
public List <InvoiceItem> GetAllInvoiceItemsByOrderID(int orderid)
{
List <InvoiceItem> invoiceItems = new List <InvoiceItem>();
try
{
InvoiceItemData data = new InvoiceItemData();
List <QSRDataObjects.InvoiceItem> dataInvoiceItems = data.GetAllInvoiceItemsByOrderID(orderid);
foreach (QSRDataObjects.InvoiceItem dataItem in dataInvoiceItems)
{
InvoiceItem item = new InvoiceItem();
item.ProdCode = dataItem.ProductCode;
item.ProdName = dataItem.ProductName;
item.ProdDesc = dataItem.ProductDescription;
item.Msrp = Convert.ToDouble(dataItem.MSRP);
item.Quantity = dataItem.Quantity.Value;
item.Tax = dataItem.TaxAmount.Value;
invoiceItems.Add(item);
}
}
catch (Exception ex)
{
ErrorRoutine(ex, "InvoiceItem", "GetAllInvoiceItemsByOrderID");
}
return(invoiceItems);
}
// GET: /InvoiceItem/Delete/<id>
public ActionResult Delete(
Int32?InvoiceID
, Int32?InvoiceItemID
)
{
if (
InvoiceID == null ||
InvoiceItemID == null
)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
dtInvoice = InvoiceItem_InvoiceData.SelectAll();
InvoiceItem InvoiceItem = new InvoiceItem();
InvoiceItem.InvoiceID = System.Convert.ToInt32(InvoiceID);
InvoiceItem.InvoiceItemID = System.Convert.ToInt32(InvoiceItemID);
InvoiceItem = InvoiceItemData.Select_Record(InvoiceItem);
InvoiceItem.Invoice = new Invoice()
{
InvoiceID = (Int32)InvoiceItem.InvoiceID
};
if (InvoiceItem == null)
{
return(HttpNotFound());
}
return(View(InvoiceItem));
}
// GET: /InvoiceItem/Edit/<id>
public ActionResult Edit(
Int32?InvoiceID
, Int32?InvoiceItemID
)
{
if (
InvoiceID == null ||
InvoiceItemID == null
)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
InvoiceItem InvoiceItem = new InvoiceItem();
InvoiceItem.InvoiceID = System.Convert.ToInt32(InvoiceID);
InvoiceItem.InvoiceItemID = System.Convert.ToInt32(InvoiceItemID);
InvoiceItem = InvoiceItemData.Select_Record(InvoiceItem);
if (InvoiceItem == null)
{
return(HttpNotFound());
}
// ComboBox
ViewData["InvoiceID"] = new SelectList(InvoiceItem_InvoiceData.List(), "InvoiceID", "InvoiceID", InvoiceItem.InvoiceID);
return(View(InvoiceItem));
}
public ActionResult Create([Bind(Include =
"InvoiceID"
+ "," + "InvoiceItemID"
+ "," + "Description"
+ "," + "Quantity"
+ "," + "Rate"
+ "," + "DiscountAmount"
+ "," + "CGSTRate"
+ "," + "SGSTRate"
+ "," + "IGSTRate"
)] InvoiceItem InvoiceItem)
{
if (ModelState.IsValid)
{
bool bSucess = false;
bSucess = InvoiceItemData.Add(InvoiceItem);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Insert");
}
}
// ComboBox
ViewData["InvoiceID"] = new SelectList(InvoiceItem_InvoiceData.List(), "InvoiceID", "InvoiceID", InvoiceItem.InvoiceID);
return(View(InvoiceItem));
}
private InvoiceItem Map(InvoiceItemData invoice_item_data)
{
var invoiceItem = _invoice_item_se.Map(invoice_item_data);
invoiceItem.OrderItemShipToAddress = _address_be.GetAddressByID(invoice_item_data.ShiptoAddrKey);
invoiceItem.OrderItemBillToAddress = _address_be.GetAddressByID(invoice_item_data.BilltoAddrKey);
invoiceItem.InvoiceItemProduct = _product_be.GetProductByID(invoice_item_data.ProductKey);
invoiceItem.AccountRep = _employee_be.GetSalesRepByKey(invoice_item_data.InvoiceItemAccountRepKey);
invoiceItem.SalesRep = _employee_be.GetAccountRepByKey(invoice_item_data.InvoiceItemSalesRepKey);
return(invoiceItem);
}
public InvoiceItem(InvoiceItemData invoiceItemData)
{
InvoiceKey = invoiceItemData.InvoiceKey;
InvoiceItemSeq = invoiceItemData.InvoiceItemSeq;
InvoiceItemKey = invoiceItemData.InvoiceItemKey;
ProductKey = invoiceItemData.ProductKey;
ProductName = invoiceItemData.ProductName;
ProductDesc = invoiceItemData.ProductDesc;
InvoiceItemQuantity = invoiceItemData.InvoiceItemQuantity;
OrderItemShipDate = invoiceItemData.OrderItemShipDate;
InvoiceItemCompleteDate = invoiceItemData.InvoiceItemCompleteDate;
ItemPricePer = invoiceItemData.InvoiceItemPricePer;
InvoiceItemLineSum = invoiceItemData.InvoiceItemLineSum;
AddedUserID = invoiceItemData.AuditAddUserId;
AddedDateTime = invoiceItemData.AuditAddDatetime;
UpdateUserID = invoiceItemData.AuditUpdateUserId;
UpdateDateTime = invoiceItemData.AuditUpdateDatetime;
InvoiceItemStatus = (QIQOInvoiceItemStatus)invoiceItemData.InvoiceItemStatusKey;
FromEntityKey = invoiceItemData.OrderItemKey;
}
public InvoiceItem Map(InvoiceItemData invoice_item_data)
{
return(new InvoiceItem()
{
InvoiceKey = invoice_item_data.InvoiceKey,
InvoiceItemSeq = invoice_item_data.InvoiceItemSeq,
InvoiceItemKey = invoice_item_data.InvoiceItemKey,
ProductKey = invoice_item_data.ProductKey,
ProductName = invoice_item_data.ProductName,
ProductDesc = invoice_item_data.ProductDesc,
InvoiceItemQuantity = invoice_item_data.InvoiceItemQuantity,
OrderItemShipDate = invoice_item_data.OrderItemShipDate,
InvoiceItemCompleteDate = invoice_item_data.InvoiceItemCompleteDate,
ItemPricePer = invoice_item_data.InvoiceItemPricePer,
InvoiceItemLineSum = invoice_item_data.InvoiceItemLineSum,
AddedUserID = invoice_item_data.AuditAddUserId,
AddedDateTime = invoice_item_data.AuditAddDatetime,
UpdateUserID = invoice_item_data.AuditUpdateUserId,
UpdateDateTime = invoice_item_data.AuditUpdateDatetime,
InvoiceItemStatus = (QIQOInvoiceItemStatus)invoice_item_data.InvoiceItemStatusKey,
FromEntityKey = invoice_item_data.OrderItemKey
});
}
public ActionResult DeleteConfirmed(
Int32?InvoiceID
, Int32?InvoiceItemID
)
{
InvoiceItem InvoiceItem = new InvoiceItem();
InvoiceItem.InvoiceID = System.Convert.ToInt32(InvoiceID);
InvoiceItem.InvoiceItemID = System.Convert.ToInt32(InvoiceItemID);
InvoiceItem = InvoiceItemData.Select_Record(InvoiceItem);
bool bSucess = false;
bSucess = InvoiceItemData.Delete(InvoiceItem);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Delete");
}
return(null);
}
public List <SqlParameter> MapParamsForDelete(InvoiceItemData entity)
{
return(MapParamsForDelete(entity.InvoiceItemKey));
}
// GET: /InvoiceItem/
public ActionResult Index(string sortOrder,
String SearchField,
String SearchCondition,
String SearchText,
String Export,
int?PageSize,
int?page,
string command)
{
if (command == "Show All")
{
SearchField = null;
SearchCondition = null;
SearchText = null;
Session["SearchField"] = null;
Session["SearchCondition"] = null;
Session["SearchText"] = null;
}
else if (command == "Add New Record")
{
return(RedirectToAction("Create"));
}
else if (command == "Export")
{
Session["Export"] = Export;
}
else if (command == "Search" | command == "Page Size")
{
if (!string.IsNullOrEmpty(SearchText))
{
Session["SearchField"] = SearchField;
Session["SearchCondition"] = SearchCondition;
Session["SearchText"] = SearchText;
}
}
if (command == "Page Size")
{
Session["PageSize"] = PageSize;
}
ViewData["SearchFields"] = GetFields((Session["SearchField"] == null ? "Invoice I D" : Convert.ToString(Session["SearchField"])));
ViewData["SearchConditions"] = Library.GetConditions((Session["SearchCondition"] == null ? "Contains" : Convert.ToString(Session["SearchCondition"])));
ViewData["SearchText"] = Session["SearchText"];
ViewData["Exports"] = Library.GetExports((Session["Export"] == null ? "Pdf" : Convert.ToString(Session["Export"])));
ViewData["PageSizes"] = Library.GetPageSizes();
ViewData["CurrentSort"] = sortOrder;
ViewData["InvoiceIDSortParm"] = sortOrder == "InvoiceID_asc" ? "InvoiceID_desc" : "InvoiceID_asc";
ViewData["InvoiceItemIDSortParm"] = sortOrder == "InvoiceItemID_asc" ? "InvoiceItemID_desc" : "InvoiceItemID_asc";
ViewData["DescriptionSortParm"] = sortOrder == "Description_asc" ? "Description_desc" : "Description_asc";
ViewData["QuantitySortParm"] = sortOrder == "Quantity_asc" ? "Quantity_desc" : "Quantity_asc";
ViewData["RateSortParm"] = sortOrder == "Rate_asc" ? "Rate_desc" : "Rate_asc";
ViewData["DiscountAmountSortParm"] = sortOrder == "DiscountAmount_asc" ? "DiscountAmount_desc" : "DiscountAmount_asc";
ViewData["CGSTRateSortParm"] = sortOrder == "CGSTRate_asc" ? "CGSTRate_desc" : "CGSTRate_asc";
ViewData["SGSTRateSortParm"] = sortOrder == "SGSTRate_asc" ? "SGSTRate_desc" : "SGSTRate_asc";
ViewData["IGSTRateSortParm"] = sortOrder == "IGSTRate_asc" ? "IGSTRate_desc" : "IGSTRate_asc";
dtInvoiceItem = InvoiceItemData.SelectAll();
dtInvoice = InvoiceItem_InvoiceData.SelectAll();
try
{
if (!string.IsNullOrEmpty(Convert.ToString(Session["SearchField"])) & !string.IsNullOrEmpty(Convert.ToString(Session["SearchCondition"])) & !string.IsNullOrEmpty(Convert.ToString(Session["SearchText"])))
{
dtInvoiceItem = InvoiceItemData.Search(Convert.ToString(Session["SearchField"]), Convert.ToString(Session["SearchCondition"]), Convert.ToString(Session["SearchText"]));
}
}
catch { }
var Query = from rowInvoiceItem in dtInvoiceItem.AsEnumerable()
join rowInvoice in dtInvoice.AsEnumerable() on rowInvoiceItem.Field <Int32>("InvoiceID") equals rowInvoice.Field <Int32>("InvoiceID")
select new InvoiceItem()
{
Invoice = new Invoice()
{
InvoiceID = rowInvoice.Field <Int32>("InvoiceID")
}
, InvoiceItemID = rowInvoiceItem.Field <Int32>("InvoiceItemID")
, Description = rowInvoiceItem.Field <String>("Description")
, Quantity = rowInvoiceItem.Field <Decimal>("Quantity")
, Rate = rowInvoiceItem.Field <Decimal>("Rate")
, DiscountAmount = rowInvoiceItem.Field <Decimal>("DiscountAmount")
, CGSTRate = rowInvoiceItem.Field <Decimal>("CGSTRate")
, SGSTRate = rowInvoiceItem.Field <Decimal>("SGSTRate")
, IGSTRate = rowInvoiceItem.Field <Decimal>("IGSTRate")
};
switch (sortOrder)
{
case "InvoiceID_desc":
Query = Query.OrderByDescending(s => s.Invoice.InvoiceID);
break;
case "InvoiceID_asc":
Query = Query.OrderBy(s => s.Invoice.InvoiceID);
break;
case "InvoiceItemID_desc":
Query = Query.OrderByDescending(s => s.InvoiceItemID);
break;
case "InvoiceItemID_asc":
Query = Query.OrderBy(s => s.InvoiceItemID);
break;
case "Description_desc":
Query = Query.OrderByDescending(s => s.Description);
break;
case "Description_asc":
Query = Query.OrderBy(s => s.Description);
break;
case "Quantity_desc":
Query = Query.OrderByDescending(s => s.Quantity);
break;
case "Quantity_asc":
Query = Query.OrderBy(s => s.Quantity);
break;
case "Rate_desc":
Query = Query.OrderByDescending(s => s.Rate);
break;
case "Rate_asc":
Query = Query.OrderBy(s => s.Rate);
break;
case "DiscountAmount_desc":
Query = Query.OrderByDescending(s => s.DiscountAmount);
break;
case "DiscountAmount_asc":
Query = Query.OrderBy(s => s.DiscountAmount);
break;
case "CGSTRate_desc":
Query = Query.OrderByDescending(s => s.CGSTRate);
break;
case "CGSTRate_asc":
Query = Query.OrderBy(s => s.CGSTRate);
break;
case "SGSTRate_desc":
Query = Query.OrderByDescending(s => s.SGSTRate);
break;
case "SGSTRate_asc":
Query = Query.OrderBy(s => s.SGSTRate);
break;
case "IGSTRate_desc":
Query = Query.OrderByDescending(s => s.IGSTRate);
break;
case "IGSTRate_asc":
Query = Query.OrderBy(s => s.IGSTRate);
break;
default: // Name ascending
Query = Query.OrderBy(s => s.InvoiceID);
break;
}
if (command == "Export")
{
GridView gv = new GridView();
DataTable dt = new DataTable();
dt.Columns.Add("Invoice I D", typeof(string));
dt.Columns.Add("Invoice Item I D", typeof(string));
dt.Columns.Add("Description", typeof(string));
dt.Columns.Add("Quantity", typeof(string));
dt.Columns.Add("Rate", typeof(string));
dt.Columns.Add("Discount Amount", typeof(string));
dt.Columns.Add("C G S T Rate", typeof(string));
dt.Columns.Add("S G S T Rate", typeof(string));
dt.Columns.Add("I G S T Rate", typeof(string));
foreach (var item in Query)
{
dt.Rows.Add(
item.Invoice.InvoiceID
, item.InvoiceItemID
, item.Description
, item.Quantity
, item.Rate
, item.DiscountAmount
, item.CGSTRate
, item.SGSTRate
, item.IGSTRate
);
}
gv.DataSource = dt;
gv.DataBind();
ExportData(Export, gv, dt);
}
int pageNumber = (page ?? 1);
int?pageSZ = (Convert.ToInt32(Session["PageSize"]) == 0 ? 5 : Convert.ToInt32(Session["PageSize"]));
return(View(Query.ToPagedList(pageNumber, (pageSZ ?? 5))));
}
public InvoiceItem Map(InvoiceItemData ent) => new InvoiceItem(ent);
