// GET: ItemSellingPrice
public ActionResult Index()
{
ItemSellingPriceList obj = new ItemSellingPriceList();
ItemSellingPriceRepository repo = new ItemSellingPriceRepository();
obj = repo.GetItemSellingPrices(OrganizationId);
return(View(obj));
}
public ActionResult Save(ItemSellingPriceList model)
{
foreach (ItemSellingPrice item in model.ItemSellingPriceLists)
{
item.CreatedDate = System.DateTime.Now;
item.CreatedBy = UserID.ToString();
item.OrganizationId = OrganizationId;
}
var rtn = new ItemSellingPriceRepository().InsertItemSellingPrice(model.ItemSellingPriceLists);
TempData["Success"] = "Added Successfully!";
return(RedirectToAction("Index"));
}
public ActionResult Print()
{
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Reports"), "ItemSellingPrice.rpt"));
DataSet ds = new DataSet();
ds.Tables.Add("Head");
ds.Tables.Add("Items");
//-------HEAD
ds.Tables["Head"].Columns.Add("OrganizationName");
ds.Tables["Head"].Columns.Add("OrganizationRefNo");
ds.Tables["Head"].Columns.Add("DoorNo");
ds.Tables["Head"].Columns.Add("Street");
ds.Tables["Head"].Columns.Add("State");
ds.Tables["Head"].Columns.Add("Phone");
ds.Tables["Head"].Columns.Add("Fax");
ds.Tables["Head"].Columns.Add("Email");
ds.Tables["Head"].Columns.Add("ContactPerson");
ds.Tables["Head"].Columns.Add("Zip");
ds.Tables["Head"].Columns.Add("Image1");
//-------DT
ds.Tables["Items"].Columns.Add("ItemName");
ds.Tables["Items"].Columns.Add("PartNo");
ds.Tables["Items"].Columns.Add("CategoryName");
ds.Tables["Items"].Columns.Add("ItemGroupName");
ds.Tables["Items"].Columns.Add("ItemSubGroupName");
ds.Tables["Items"].Columns.Add("UnitName");
ds.Tables["Items"].Columns.Add("SellingPrice");
ds.Tables["Items"].Columns.Add("Average");
OrganizationRepository repo = new OrganizationRepository();
var Head = repo.GetOrganization(OrganizationId);
DataRow dr = ds.Tables["Head"].NewRow();
dr["OrganizationName"] = Head.OrganizationName;
dr["OrganizationRefNo"] = Head.OrganizationRefNo;
dr["DoorNo"] = Head.DoorNo;
dr["Street"] = Head.Street;
dr["State"] = Head.State;
dr["Phone"] = Head.Phone;
dr["Fax"] = Head.Fax;
dr["Email"] = Head.Email;
dr["ContactPerson"] = Head.ContactPerson;
dr["Zip"] = Head.Zip;
dr["Image1"] = Server.MapPath("~/App_images/") + Head.Image1;
ds.Tables["Head"].Rows.Add(dr);
ItemSellingPriceRepository repo1 = new ItemSellingPriceRepository();
var Items = repo1.GetItemSellingPricesReport(OrganizationId);
foreach (var item in Items)
{
DataRow dri = ds.Tables["Items"].NewRow();
dri["ItemName"] = item.ItemName;
dri["PartNo"] = item.PartNo;
dri["CategoryName"] = item.CategoryName;
dri["ItemGroupName"] = item.ItemGroupName;
dri["ItemSubGroupName"] = item.ItemSubGroupName;
dri["UnitName"] = item.UnitName;
dri["SellingPrice"] = item.SellingPrice;
dri["Average"] = item.Average;
ds.Tables["Items"].Rows.Add(dri);
}
ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "ItemSellingPrice.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("ItemSellingPrice.pdf")));
}
catch (Exception ex)
{
throw;
}
}
