public void FillItem()
{
var repo = new OpeningStockRepository();
var list = repo.FillItem();
ViewBag.Itemlist = new SelectList(list, "Id", "Name");
}
public ActionResult OpeningStockList(int?stockpointId)
{
FillItem();
FillPartNo();
OpeningStock OpeningStock = new OpeningStock();
OpeningStock.OpeningStockItem = new List <OpeningStockItem>();
if (stockpointId == null || stockpointId == 0)
{
var OpeningStockItem = new OpeningStockItem {
Quantity = 0
};
OpeningStock.OpeningStockItem.Add(OpeningStockItem);
}
else
{
var repo = new OpeningStockRepository();
OpeningStock.OpeningStockItem = repo.GetItem(stockpointId).ToList();
}
if (OpeningStock.OpeningStockItem.Count == 0)
{
OpeningStock.OpeningStockItem.Add(new OpeningStockItem());
}
return(PartialView("OpeningStockList", OpeningStock));
}
public RepositoryFactory()
{
Repository bankRepository = new Repository(new Bank());
CurrencyRepository ccyRepository = new CurrencyRepository();
Repository divRepository = new Repository(new Division());
Repository empRepository = new EmployeeRepository(new Employee());
Repository topRepository = new Repository(new TermOfPayment());
Repository unitRepository = new Repository(new Unit());
Repository cuscatRepository = new Repository(new CustomerCategory());
Repository supcatRepository = new Repository(new SupplierCategory());
Repository pricecatRepository = new Repository(new PriceCategory());
Repository taxRepository = new Repository(new Tax());
Repository prtGroupRepository = new Repository(new PartGroup());
Repository warehouseRepository = new Repository(new Warehouse());
Repository prtCategoryRepository = new Repository(new PartCategory());
Repository docTypeRepository = new Repository(new DocumentType());
Repository excRateRepository = new Repository(new ExchangeRate());
CustomerRepository customerRepository = new CustomerRepository();
SupplierRepository supplierRepository = new SupplierRepository();
Repository yearRepository = new YearRepository();
Repository partRepository = new PartRepository(new Part());
StockTakingRepository stocktakingRepository = new StockTakingRepository();
UserRepository userRepository = new UserRepository(new User());
GeneralSetupRepository generalsetupRepository = new GeneralSetupRepository();
PurchaseOrderRepository poRepository = new PurchaseOrderRepository();
PeriodRepository periodRepository = new PeriodRepository();
UserSettingsRepository usRepository = new UserSettingsRepository();
GoodReceiveNoteRepository grnRepository = new GoodReceiveNoteRepository();
PurchaseReturnRepository prRepository = new PurchaseReturnRepository();
SupplierInvoiceRepository siRepository = new SupplierInvoiceRepository();
SupplierOutStandingInvoiceRepository soiRepository = new SupplierOutStandingInvoiceRepository();
SupplierInvoiceJournalRepository sijRepository = new SupplierInvoiceJournalRepository();
PaymentRepository payRepository = new PaymentRepository();
APDebitNoteRepository apdnRepository = new APDebitNoteRepository();
ProcessTransactionRepository prtrRepository = new ProcessTransactionRepository();
SalesOrderRepository slsorderRepository = new SalesOrderRepository();
DeliveryOrderRepository doRepository = new DeliveryOrderRepository();
SalesReturnRepository srRepository = new SalesReturnRepository();
CustomerOutStandingInvoiceRepository coirRepository = new CustomerOutStandingInvoiceRepository();
CustomerInvoiceRepository cirRepository = new CustomerInvoiceRepository();
ReceiptRepository rcptRepository = new ReceiptRepository();
ARCreditNoteRepository arcrRepository = new ARCreditNoteRepository();
CustomerInvoiceJournalRepository cijRepository = new CustomerInvoiceJournalRepository();
OpeningStockRepository opstRepository = new OpeningStockRepository();
POSRepository posRepository = new POSRepository();
m_listService.Add(BANK_REPOSITORY, bankRepository);
m_listService.Add(CURRENCY_REPOSITORY, ccyRepository);
m_listService.Add(DIVISION_REPOSITORY, divRepository);
m_listService.Add(EMPLOYEE_REPOSITORY, empRepository);
m_listService.Add(TOP_REPOSITORY, topRepository);
m_listService.Add(UNIT_REPOSITORY, unitRepository);
m_listService.Add(CUSTOMER_CATEGORY_REPOSITORY, cuscatRepository);
m_listService.Add(SUPPLIER_CATEGORY_REPOSITORY, supcatRepository);
m_listService.Add(PRICE_CATEGORY_REPOSITORY, pricecatRepository);
m_listService.Add(TAX_REPOSITORY, taxRepository);
m_listService.Add(PART_GROUP_REPOSITORY, prtGroupRepository);
m_listService.Add(WAREHOUSE_REPOSITORY, warehouseRepository);
m_listService.Add(PART_CATEGORY_REPOSITORY, prtCategoryRepository);
m_listService.Add(DOC_TYPE_REPOSITORY, docTypeRepository);
m_listService.Add(EXCHANGE_RATE_REPOSITORY, excRateRepository);
m_listService.Add(CUSTOMER_REPOSITORY, customerRepository);
m_listService.Add(SUPPLIER_REPOSITORY, supplierRepository);
m_listService.Add(YEAR_REPOSITORY, yearRepository);
m_listService.Add(PART_REPOSITORY, partRepository);
m_listService.Add(STOCKTAKING_REPOSITORY, stocktakingRepository);
m_listService.Add(USER_REPOSITORY, userRepository);
m_listService.Add(GENERAL_SETUP_REPOSITORY, generalsetupRepository);
m_listService.Add(PURCHASEORDER_REPOSITORY, poRepository);
m_listService.Add(PERIOD_REPOSITORY, periodRepository);
m_listService.Add(USER_SETTING_REPOSITORY, usRepository);
m_listService.Add(GOODRECEIVENOTE_REPOSITORY, grnRepository);
m_listService.Add(PURCHASE_RETURN_REPOSITORY, prRepository);
m_listService.Add(SUPPLIERINVOICE_REPOSITORY, siRepository);
m_listService.Add(SUPPLIERINVOICE_JOURNAL_REPOSITORY, sijRepository);
m_listService.Add(SUPPLIER_OUTSTANDING_INVOICE_REPOSITORY, soiRepository);
m_listService.Add(PAYMENT_REPOSITORY, payRepository);
m_listService.Add(APDEBITNOTE_REPOSITORY, apdnRepository);
m_listService.Add(PROCESS_TRANSACTION_REPOSITORY, prtrRepository);
m_listService.Add(SALES_ORDER_REPOSITORY, slsorderRepository);
m_listService.Add(DELIVERY_ORDER_REPOSITORY, doRepository);
m_listService.Add(SALES_RETURN_REPOSITORY, srRepository);
m_listService.Add(CUSTOMER_OUTSTANDING_INVOICE_REPOSITORY, coirRepository);
m_listService.Add(CUSTOMERINVOICE_REPOSITORY, cirRepository);
m_listService.Add(RECEIPT_REPOSITORY, rcptRepository);
m_listService.Add(ARCREDITNOTE_REPOSITORY, arcrRepository);
m_listService.Add(CUSTOMERINVOICE_JOURNAL_REPOSITORY, cijRepository);
m_listService.Add(OPENING_STOCK_REPOSITORY, opstRepository);
m_listService.Add(POS_REPOSITORY, posRepository);
}
public ActionResult Print(string Spname = "", int Spid = 0, int ItmCatid = 0, string ItmCatname = "", string Itmid = "", int ItmGroup = 0, string ItmGroupname = "", int ItmSubGroup = 0, string ItmSubGroupname = "", string PartNo = "")
{
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Reports"), "OpeningStockReport.rpt"));
DataSet ds = new DataSet();
ds.Tables.Add("Head");
ds.Tables.Add("Items");
// //-------HEAD
ds.Tables["Head"].Columns.Add("Stkpoint");
ds.Tables["Head"].Columns.Add("ItemCat");
ds.Tables["Head"].Columns.Add("Item");
ds.Tables["Head"].Columns.Add("OrganizationName");
ds.Tables["Head"].Columns.Add("Image1");
ds.Tables["Head"].Columns.Add("PartNum");
ds.Tables["Head"].Columns.Add("Group");
ds.Tables["Head"].Columns.Add("SubGroup");
ds.Tables["Head"].Columns.Add("ItemCategory");
//-------DT
ds.Tables["Items"].Columns.Add("Item");
ds.Tables["Items"].Columns.Add("PartNo");
ds.Tables["Items"].Columns.Add("OpeningStk");
ds.Tables["Items"].Columns.Add("GroupG");
ds.Tables["Items"].Columns.Add("SubGroupG");
ds.Tables["Items"].Columns.Add("Unit");
OrganizationRepository repo = new OrganizationRepository();
var Head = repo.GetOrganization(OrganizationId);
DataRow dr = ds.Tables["Head"].NewRow();
dr["Stkpoint"] = Spname;
dr["ItemCat"] = ItmCatname;
dr["Item"] = Itmid;
dr["OrganizationName"] = Head.OrganizationName;
dr["Image1"] = Server.MapPath("~/App_images/") + Head.Image1;
dr["PartNum"] = PartNo;
dr["Group"] = ItmGroupname;
dr["SubGroup"] = ItmSubGroupname;
dr["ItemCategory"] = ItmCatname;
ds.Tables["Head"].Rows.Add(dr);
OpeningStockRepository repo1 = new OpeningStockRepository();
//var Items = repo1.GetSOVarianceDataDTPrint(from, to, itmid, itmName, SupId, SupName);
var Items = repo1.GetClosingStockDataDTPrint(stockPointId: Spid, itemCategoryId: ItmCatid, itemId: Itmid, itmGroup: ItmGroup, itmSubgroup: ItmSubGroup, OrganizationId: OrganizationId, partno: PartNo);
foreach (var item in Items)
{
var SupplyOrderRegItem = new OpeningStockReport
{
ItemName = item.ItemName,
PartNo = item.PartNo,
Quantity = item.Quantity,
UnitName = item.UnitName,
ItemGroupName = item.ItemGroupName,
ItemSubGroupName = item.ItemSubGroupName,
};
DataRow dri = ds.Tables["Items"].NewRow();
dri["Item"] = SupplyOrderRegItem.ItemName;
dri["PartNo"] = SupplyOrderRegItem.PartNo;
dri["OpeningStk"] = SupplyOrderRegItem.Quantity;
dri["Unit"] = SupplyOrderRegItem.UnitName;
dri["GroupG"] = SupplyOrderRegItem.ItemGroupName;
dri["SubGroupG"] = SupplyOrderRegItem.ItemSubGroupName;
ds.Tables["Items"].Rows.Add(dri);
}
ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "OpeningStockReport.xml"), XmlWriteMode.WriteSchema);
rd.SetDataSource(ds);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
try
{
Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "application/pdf", String.Format("OpeningStockReport.pdf")));
}
catch (Exception ex)
{
throw;
}
}
