public ActionResult Create()
{
SalesmanViewModel salesman = new SalesmanViewModel();
using (DB5Entities5 db = new DB5Entities5())
{
salesman.CompanyCollection = db.Comapnies.ToList <Comapny>();
}
return(View(salesman));
}
// GET: Sells/Create
public ActionResult Create()
{
SellsViewModel sells = new SellsViewModel();
using (DB5Entities5 db = new DB5Entities5())
{
sells.MedicineCollection = db.Medicines.ToList <Medicine>();
sells.StaffData = db.Staffs.ToList <Staff>();
}
return(View(sells));
}
// GET: SalaryStatus/Create
public ActionResult Create()
{
SalaryStatusViewModel salary = new SalaryStatusViewModel();
using (DB5Entities5 db = new DB5Entities5())
{
salary.SalaryCollection = db.Salaries.ToList <Salary>();
salary.StaffCollection = db.Staffs.ToList <Staff>();
}
return(View(salary));
}
public ActionResult Create()
{
MedicineViewModel medicine = new MedicineViewModel();
using (DB5Entities5 db = new DB5Entities5())
{
medicine.StockCollection = db.Stocks.ToList <Stock>();
medicine.CategoryCollection = db.Categories.ToList <Category>();
}
return(View(medicine));
}
/*public ActionResult MYReport()
* {
* var id = (int)Session["OwnerId"];
* using (var context = new DB5Entities5())
* {
* var courses = context.CompanyRecord(id).ToList();
* CompanyRecordrpt rpt = new CompanyRecordrpt();
* rpt.Load();
* rpt.SetDataSource(courses);
* Stream s = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
* return File(s, "application/pdf");
* }
* }
* public ActionResult Attendence_Per_day()
* {
* var id = (int)Session["OwnerId"];
* DateTime Day = Convert.ToDateTime(Request["date"].ToString());
* using (var context = new DB5Entities5())
* {
* var courses = context.Attendence_Per_day(Day,id).ToList();
* AttendencePerDayReport rpt = new AttendencePerDayReport();
* rpt.Load();
* rpt.SetDataSource(courses);
* Stream s = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
* return File(s, "application/pdf");
* }
* }
* public ActionResult Attendence_Per_Month()
* {
* int Year = Convert.ToInt32(Request["MyYear"].ToString());
* int Month = Convert.ToInt32(Request["MyMonth"].ToString());
* var id = (int)Session["OwnerId"];
* using (var context = new DB5Entities5())
* {
* var Att = context.Attendence_Per_Month(Month,Year,id).ToList();
* AttendancePerMonth rpt = new AttendancePerMonth();
* rpt.Load();
* rpt.SetDataSource(Att);
* Stream s = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
* return File(s, "application/pdf");
* }
* }
* public ActionResult Medicine_sold_per_day()
* {
* var id = (int)Session["OwnerId"];
* DateTime Day = Convert.ToDateTime(Request["date"].ToString());
* using (var context = new DB5Entities5())
* {
* var courses = context.Medicine_sold_per_DAy(Day, id).ToList();
* MedicinePerDayReport rpt = new MedicinePerDayReport();
* rpt.Load();
* rpt.SetDataSource(courses);
* Stream s = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
* return File(s, "application/pdf");
* }
* }
* public ActionResult Medicine_sold_per_Month()
* {
* int Year = Convert.ToInt32(Request["MyYear"].ToString());
* int Month = Convert.ToInt32(Request["MyMonth"].ToString());
* var id = (int)Session["OwnerId"];
* using (var context = new DB5Entities5())
* {
* var Att = context.Medicine_sold_per_Month(Year, Month, id).ToList();
* MedicineSoldPerMonth rpt = new MedicineSoldPerMonth();
* rpt.Load();
* rpt.SetDataSource(Att);
* Stream s = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
* return File(s, "application/pdf");
* }
* }*/
public ActionResult StaffData()
{
var Ownerid = (int)Session["OwnerId"];
using (var context = new DB5Entities5())
{
var courses = context.AllStaffs(Ownerid).ToList();
StaffRecords rpt = new StaffRecords();
rpt.Load();
rpt.SetDataSource(courses);
Stream s = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
return(File(s, "application/pdf"));
}
}
public ActionResult MonthlyStaffSalary()
{
var id = (int)Session["OwnerId"];
DateTime Day = Convert.ToDateTime(Request["PaidDate"].ToString());
using (var context = new DB5Entities5())
{
var monthly = context.MonthlySalaryReport(Day, id).ToList();
MonthlyStaffSalary rpt = new MonthlyStaffSalary();
rpt.Load();
rpt.SetDataSource(monthly);
Stream s = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
return(File(s, "application/pdf"));
}
}
public ActionResult CompanyWiseStock()
{
var id = (int)Session["OwnerId"];
int Companyid = Convert.ToInt32(Request["CompanyID"]);
// DateTime Day = Convert.ToDateTime(Request["PaidDate"].ToString());
using (var context = new DB5Entities5())
{
var company = context.CompanyWiseStock(Companyid, id).ToList();
CompanyRecordrpt rpt = new CompanyRecordrpt();
rpt.Load();
rpt.SetDataSource(company);
Stream s = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
return(File(s, "application/pdf"));
}
}
public ActionResult CategoryWiseMedicine()
{
string name = Request["CategoryOfMedicine"];
var id = (int)Session["OwnerId"];
using (var context = new DB5Entities5())
{
var Att = context.CategoryWiseMedicine(id, name).ToList();
CategoryWiseMedicine rpt = new CategoryWiseMedicine();
rpt.Load();
rpt.SetDataSource(Att);
Stream s = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
return(File(s, "application/pdf"));
}
}
public ActionResult StaffPosted()
{
string Post = Request["PostList"];
var id = (int)Session["OwnerId"];
using (var context = new DB5Entities5())
{
var Att = context.PostedStaffs(id, Post).ToList();
PostWiseStaffReport rpt = new PostWiseStaffReport();
rpt.Load();
rpt.SetDataSource(Att);
Stream s = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
return(File(s, "application/pdf"));
}
}
