public bool EditPostReport(ReportVM r)
{
r.ModifiedBy = 1;
r.ModifiedDate = DateTime.Now;
bool flag = false;
if (r.ReportUrl == null)
{
r.ReportUrl = ModernMarketResearch.Areas.Admin.Models.Common.GenerateSlug(r.ReportTitle) + "-" + r.ReportId;
}
if (IsSameReportData(r))
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
var report = serializer.Serialize(r);
ReportMaster repo = serializer.Deserialize <ReportMaster>(report);
db.Entry(repo).State = EntityState.Modified;
db.SaveChanges();
flag = true;
}
else
{
flag = false;
}
return(flag);
}
public bool EditPostReport(ReportVM r)
{
r.ModifiedBy = 1;
r.ModifiedDate = DateTime.Now;
bool flag = false;
if (r.ReportUrl == null)
{
r.ReportUrl = ExcellentMarketResearch.Areas.Admin.Models.Common.GenerateSlug(r.ReportTitle) + "-" + r.ReportId;
}
if (IsSameReportData(r))
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
var report = serializer.Serialize(r);
ReportMaster repo = serializer.Deserialize <ReportMaster>(report);
repo.LongDescritpion = r.FullDescription;
repo.SinglePrice = r.PriceSingleUser;
repo.MultiUserPrice = r.PriceMultiUser;
repo.CorporateUserPrice = r.PriceCUL;
repo.NumberOfPages = r.NumberOfPage;
repo.PublishereId = r.PublisherId;
repo.ReportDeliveryTypeId = r.DeliveryTypeId;
db.Entry(repo).State = EntityState.Modified;
db.SaveChanges();
flag = true;
}
else
{
flag = false;
}
return(flag);
}
public ActionResult DeleteConfirmed(int id)
{
ReportMaster reportMaster = db.ReportMasters.Find(id);
db.ReportMasters.Remove(reportMaster);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public XDocument GetReport(long masterreportId, List <ReportXMLPrintParameterModel> filters)
{
this.masterReport_Id = masterreportId;
this.repo = new BuildReportRepository();
XDocument result = this.repo.GetReportXml(this.masterReport_Id);
ReportMaster reportMaster = this.repo.GetReportMaster(this.masterReport_Id);
return(this.GetReport(result, null, reportMaster, filters));
}
public ReportMaster GetReportMasterData(int reportID)
{
ReportMaster reportMaster = new ReportMaster();
var tmpReportData = dbContext.GetReportMasterData(reportID);
reportMaster = (from m in tmpReportData
select new ReportMaster
{
ReportID = m.reportID,
ReportDatasetName = m.rptDataSetName
}).FirstOrDefault();
return(reportMaster);
}
public ReportMasterModel GetReportMasterByPrimaryKey(Int64 MasterReport_Id)
{
ReportMaster result = this.dataContext
.ReportsMaster
.FirstOrDefault(pk => pk.MasterReport_Id == MasterReport_Id);
if (result == null)
{
return(null);
}
return(result.CopyToObject(new ReportMasterModel()) as ReportMasterModel);
}
// GET: Business/ReportMasters/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ReportMaster reportMaster = db.ReportMasters.Find(id);
if (reportMaster == null)
{
return(HttpNotFound());
}
return(View(reportMaster));
}
public void InsertReport(ReportVM r)
{
r.CreatedBy = 1;
r.CreatedDate = DateTime.Now;
JavaScriptSerializer serializer = new JavaScriptSerializer();
var s = serializer.Serialize(r);
ReportMaster re = serializer.Deserialize <ReportMaster>(s);
db.ReportMasters.Add(re);
db.SaveChanges();
re.ReportUrl = re.ReportUrl + "-" + re.ReportId;
db.Entry(re).State = EntityState.Modified;
db.SaveChanges();
}
public ActionResult Edit([Bind(Include = "Id,BusinessId,ServiceId,ProviderId,PracticeId,RepId,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy")] ReportMaster reportMaster)
{
if (ModelState.IsValid)
{
reportMaster.UpdatedBy = CurrentUserId;
reportMaster.UpdatedOn = System.DateTime.UtcNow;
db.Entry(reportMaster).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ServiceId = new SelectList(db.LookupEnrolledServices.Where(a => a.BusinessId == CurrentBusinessId), "Id", "ServiceName", reportMaster.ServiceId);
ViewBag.PracticeId = new SelectList(db.Practices, "Id", "PracticeName", reportMaster.PracticeId);
ViewBag.ProviderId = new SelectList(db.Providers, "Id", "FirstName", reportMaster.ProviderId);
ViewBag.RepId = new SelectList(db.Users.Where(a => a.BusinessId == CurrentBusinessId && a.IsActive == true), "Id", "FirstName", reportMaster.RepId);
return(View(reportMaster));
}
// GET: Business/ReportMasters/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ReportMaster reportMaster = db.ReportMasters.Find(id);
if (reportMaster == null)
{
return(HttpNotFound());
}
ViewBag.ServiceId = new SelectList(db.LookupEnrolledServices.Where(a => a.BusinessId == CurrentBusinessId), "Id", "ServiceName", reportMaster.ServiceId);
ViewBag.PracticeId = new SelectList(db.Practices, "Id", "PracticeName", reportMaster.PracticeId);
ViewBag.ProviderId = new SelectList(db.Providers, "Id", "FirstName", reportMaster.ProviderId);
ViewBag.RepId = new SelectList(db.Users.Where(a => a.BusinessId == CurrentBusinessId && a.IsActive == true), "Id", "FirstName", reportMaster.RepId);
return(View(reportMaster));
}
public void UpdateReportMaster(ReportMasterModel model)
{
ReportMaster existing = this.dataContext
.ReportsMaster
.Where(rx => rx.MasterReport_Id == model.MasterReport_Id)
.FirstOrDefault();
if (existing == null)
{
existing = model.CopyToObject(new ReportMaster()) as ReportMaster;
this.dataContext.ReportsMaster.Add(existing);
}
else
{
existing = model.CopyToObject(existing) as ReportMaster;
}
this.dataContext.SaveChanges();
model = existing.CopyToObject(model) as ReportMasterModel;
}
public void InsertReport(ReportVM r)
{
r.CreatedBy = 1;
r.CreatedDate = DateTime.Now;
JavaScriptSerializer serializer = new JavaScriptSerializer();
var s = serializer.Serialize(r);
ReportMaster re = serializer.Deserialize <ReportMaster>(s);
re.LongDescritpion = r.FullDescription;
re.SinglePrice = r.PriceSingleUser;
re.MultiUserPrice = r.PriceMultiUser;
re.CorporateUserPrice = r.PriceCUL;
re.NumberOfPages = r.NumberOfPage;
re.PublishereId = r.PublisherId;
re.ReportDeliveryTypeId = r.DeliveryTypeId;
db.ReportMasters.Add(re);
db.SaveChanges();
re.ReportUrl = re.ReportUrl + "-" + re.ReportId;
db.Entry(re).State = EntityState.Modified;
db.SaveChanges();
}
public void CreateReport(DataSet ds)
{
DataTable dtReport = CreateDataSet();
DataSet dsReport = new DataSet();
ReportMaster r = new ReportMaster();
List <ReportMaster> reportlist = new List <ReportMaster>();
string HTMLTable = "<table border='1'>";
for (int tables = 0; tables < ds.Tables.Count; tables++)
{
#region rowdata
for (int rows = 0; rows < ds.Tables[tables].Rows.Count; rows++)
{
int _SerialNumber;
int SerialNumber = 0;
int _CategoryID;
int _PublisherID;
int _DeliveryFormatID;
DateTime _PublishedDate;
int _NumberOfPages;
Decimal _SingleUserPrice;
Decimal _MultiUserPrice;
Decimal _CorporateUserPrice;
bool IsVaidate = true;
string Message = "";
string ReportTitleTemp = string.Empty;
for (int columns = 0; columns < ds.Tables[tables].Columns.Count; columns++)
{
if (ds.Tables[tables].Columns[columns].ToString() == "Serial Number")
{
if (Int32.TryParse(ds.Tables[tables].Rows[rows][columns].ToString().Trim(), out _SerialNumber))
{
SerialNumber = _SerialNumber;
}
else
{
IsVaidate = false; Message += "Serial Number<br />";
}
}
else if (ds.Tables[tables].Columns[columns].ToString() == "Category ID")
{
if (Int32.TryParse(ds.Tables[tables].Rows[rows][columns].ToString().Trim(), out _CategoryID))
{
r.CategoryId = _CategoryID;
}
else
{
IsVaidate = false; Message += "Category ID <br />";
}
}
else if (ds.Tables[tables].Columns[columns].ToString() == "Publisher ID")
{
if (Int32.TryParse(ds.Tables[tables].Rows[rows][columns].ToString().Trim(), out _PublisherID))
{
r.PublishereId = _PublisherID;
}
else
{
IsVaidate = false; Message += "Publisher ID <br />";
}
}
else if (ds.Tables[tables].Columns[columns].ToString() == "Delivery Format ID")
{
if (Int32.TryParse(ds.Tables[tables].Rows[rows][columns].ToString().Trim(), out _DeliveryFormatID))
{
r.ReportDeliveryTypeId = _DeliveryFormatID;
}
else
{
IsVaidate = false; Message += "Delivery Format ID <br />";
}
}
else if (ds.Tables[tables].Columns[columns].ToString() == "Title")
{
ReportTitleTemp = Convert.ToString(ds.Tables[tables].Rows[rows][columns].ToString().Trim());
if (db.ReportMasters.Count(g => g.ReportTitle == ReportTitleTemp) > 0 ? true : false)
{
IsVaidate = false; Message += "Title <br />";
}
else
{
r.ReportTitle = ds.Tables[tables].Rows[rows][columns].ToString().Trim().Replace(" ", " ").Replace(" ", " ").Replace(" ", " ");
}
r.ReportUrl = ExcellentMarketResearch.Areas.Admin.Models.Common.GenerateSlug(ds.Tables[tables].Rows[rows][columns].ToString().Trim());
if (db.ReportMasters.Count(url => url.ReportUrl == r.ReportUrl.ToLower()) > 0 ? true : false)
{
r.ReportUrl = ""; IsVaidate = false; Message += "Long URL <br />";
}
}
else if (ds.Tables[tables].Columns[columns].ToString() == "Published Date")
{
if (DateTime.TryParse(ds.Tables[tables].Rows[rows][columns].ToString().Trim(), out _PublishedDate))
{
r.PublishingDate = _PublishedDate;
}
else
{
IsVaidate = false; Message += "Published Date <br />";
}
}
else if (ds.Tables[tables].Columns[columns].ToString() == "Number Of Pages")
{
if (Int32.TryParse(ds.Tables[tables].Rows[rows][columns].ToString().Trim(), out _NumberOfPages))
{
r.NumberOfPages = _NumberOfPages;
}
else
{
IsVaidate = false; Message += "Number Of Pages <br />";
}
}
else if (ds.Tables[tables].Columns[columns].ToString() == "Long Description")
{
if (ds.Tables[tables].Rows[rows][columns].ToString().Trim() != "")
{
r.LongDescritpion = "<pre>" + ds.Tables[tables].Rows[rows][columns].ToString().Trim() + "</pre>";
}
else
{
IsVaidate = false; Message += "Long Description \n";
}
}
else if (ds.Tables[tables].Columns[columns].ToString() == "Long Table Of Content")
{
r.TableOfContent = "<pre>" + ds.Tables[tables].Rows[rows][columns].ToString().Trim() + "</pre>";
}
else if (ds.Tables[tables].Columns[columns].ToString() == "Single User Price")
{
if (Decimal.TryParse(ds.Tables[tables].Rows[rows][columns].ToString().Trim() == "" ? "0" : ds.Tables[tables].Rows[rows][columns].ToString().Trim(), out _SingleUserPrice))
{
r.SinglePrice = _SingleUserPrice;
}
else
{
IsVaidate = false; Message += "Single User Price <br />";
}
}
else if (ds.Tables[tables].Columns[columns].ToString() == "Multi User Price")
{
if (Decimal.TryParse(ds.Tables[tables].Rows[rows][columns].ToString().Trim() == "" ? "0" : ds.Tables[tables].Rows[rows][columns].ToString().Trim(), out _MultiUserPrice))
{
r.MultiUserPrice = _MultiUserPrice;
}
else
{
IsVaidate = false; Message += "Multi User Price <br />";
}
}
else if (ds.Tables[tables].Columns[columns].ToString() == "Corporate User Price")
{
if (Decimal.TryParse(ds.Tables[tables].Rows[rows][columns].ToString().Trim() == "" ? "0" : ds.Tables[tables].Rows[rows][columns].ToString().Trim(), out _CorporateUserPrice))
{
r.CorporateUserPrice = _CorporateUserPrice;
}
else
{
IsVaidate = false; Message += "Corporate User Price <br />";
}
}
else if (ds.Tables[tables].Columns[columns].ToString() == "Meta Title")
{
r.MetaTitle = ds.Tables[tables].Rows[rows][columns].ToString().Trim();
}
else if (ds.Tables[tables].Columns[columns].ToString() == "Meta Description")
{
r.MetaDescription = ds.Tables[tables].Rows[rows][columns].ToString().Trim();
}
else if (ds.Tables[tables].Columns[columns].ToString() == "Meta Keywords")
{
r.Keywords = ds.Tables[tables].Rows[rows][columns].ToString().Trim();
}
}
if (r.SinglePrice <= 0 && r.MultiUserPrice <= 0 && r.CorporateUserPrice <= 0)
{
IsVaidate = false; Message += "Add Atleast one Price <br />";
}
//Save data in Database.
if (IsVaidate)
{
r.ReportImage = null;
// r.ListOfCharts = null;
// r.FreeAnalysis = null;
// r.Summary = "null";
// r.Methodology = null;
// r.DiscountPrice = 0;
r.IsActive = true;
// r.IsUpcomming = true;
r.ReportTypeId = r.ReportDeliveryTypeId;
r.CreatedBy = 1;//Convert.ToInt32(QYGroupRepository.Areas.Admin.Models.CommonCode.MySession());
r.CreatedDate = DateTime.Now;
reportlist.Add(r);
db.ReportMasters.Add(r);
db.SaveChanges();
var repturl = r.ReportUrl + ".html";
r.ReportUrl = repturl;
db.Entry(r).State = EntityState.Modified;
db.SaveChanges();
//PriceMaster p = new PriceMaster();
//p.PriceType = "Single User Price ";
//p.Price = r.PriceSingleUser;
//db.PriceMasters.Add(p);
//db.SaveChanges();
//p.PriceType = "Multi User Price ";
//p.Price = r.PriceMultiUser;
//db.PriceMasters.Add(p);
//db.SaveChanges();
//p.PriceType = "Corporate User Price ";
//p.Price = r.PriceCUL;
//db.PriceMasters.Add(p);
//db.SaveChanges();
Message += "Inserted <br/>";
}
HTMLTable += "<tr><td>" + SerialNumber + "</td><td>" + ReportTitleTemp + "</td><td>" + r.ReportUrl + "</td><td>" + Message + "</td></tr>";
}
HTMLTable += "</table>";
ViewData.Add("HTMLTable", HTMLTable);
#endregion rows
}
//return View();
}
public XDocument GetReport(
XDocument xmlReport,
DatabaseModel connection,
ReportMaster reportMaster,
List <ReportXMLPrintParameterModel> filters)
{
if (filters.Count > 0 && filters.Any(p => p.IsRequired.IsTrue() && p.FilterValue.IsNullEmptyOrWhiteSpace()))
{
throw new ApplicationException("One or more required filters was not passed with a value. Report Print canceled.");
}
if (this.repo == null)
{
this.repo = new BuildReportRepository();
}
if (filters.Count == 0)
{
this.tableFilters = new Dictionary <string, List <ReportXMLPrintParameterModel> >();
}
else
{
this.tableFilters = filters
.GroupBy(g => g.TableName)
.ToDictionary(t => t.Key, c => c.ToList());
}
this.dataAccessConnection = connection;
Dictionary <string, XElement[]> sqlOrderBy = xmlReport
.Root
.Descendants("ReportObject")
.Where(ro => ro.IsDataObject() && ro.Attribute("UseInOrderBy").Value == "true")
.GroupBy(tn => tn.Attribute("ObjectTable").Value)
.ToDictionary(td => td.Key, td => td.ToArray());
Dictionary <string, string> orderByDictionary = new Dictionary <string, string>();
foreach (KeyValuePair <string, XElement[]> orderKey in sqlOrderBy)
{
string[] orderString = orderKey.Value
.Select(x => x.Attribute("ObjectColumn").Value)
.ToArray();
this.orderByDictionary.Add(orderKey.Key, orderString.Concatenate(","));
}
string reportTypeValue = xmlReport.Root.Element("ReportSettings").Attribute("ReportTypeEnum").Value;
#region BUILD REPORT DATA
ReportTypeEnum reportType = (ReportTypeEnum)reportTypeValue.ToInt32();
if (reportType == ReportTypeEnum.ReportContent)
{
this.CreateConnectionObject();
XElement dataNode = new XElement("ReportData");
this.dataSections = xmlReport.Root
.Descendants("ReportSection")
.Where(st => st.Attribute("SectionType").Value == "5") // SectionTypeEnum.TableData
.ToDictionary(d => d.Attribute("SectionIndex").Value.ToInt32());
this.sectionIndex = 1;
this.DoSectionSetup();
this.BuildReportData(dataNode);
xmlReport.Root.Add(dataNode);
}
#endregion
foreach (XElement reportSum in xmlReport.Root.Descendants().Where(a => a.Attribute("ObjectType") != null &&
a.Attribute("ObjectType").Value == "ReportSum"))
{
int parentSetionGroupIndex = reportSum.Attribute("ParentSectionGroupIndex").Value.ToInt32();
int sectionGroupIndex = reportSum.Attribute("SectionGroupIndex").Value.ToInt32();
string sumColumn = reportSum.Attribute("SumColumn").Value;
if (sumColumn.IsNullEmptyOrWhiteSpace())
{ // The user did not perfom a full setup
continue;
}
foreach (XElement tableRow in xmlReport.Root
.Element("ReportData")
.Descendants()
.Where(pg => pg.Attribute("SectionGroupIndex") != null &&
pg.Attribute("SectionGroupIndex").Value.ToInt32() == parentSetionGroupIndex))
{
IEnumerable <XElement> sumItems = parentSetionGroupIndex == sectionGroupIndex?
tableRow
.Elements()
.Elements()
.Where(ln => ln.Name.LocalName == sumColumn)
:
tableRow
.Descendants()
.Where(ln => ln.Name.LocalName == sumColumn &&
ln.Parent.Parent.Attribute("SectionGroupIndex") != null &&
ln.Parent.Parent.Attribute("SectionGroupIndex").Value.ToInt32() == sectionGroupIndex);
decimal result = 0;
if (sumItems.Count() != 0)
{
result = sumItems.Sum(si =>
{
decimal?innerResult = si.Value.TryToDecimal().Value;
return(innerResult.HasValue ? innerResult.Value : 0);
});
}
XElement sumElemet = new XElement(sumColumn);
sumElemet.Add(new XAttribute("Value", result));
sumElemet.Add(new XAttribute("TableRowIndex", tableRow.Attribute("TableRowIndex").Value));
reportSum.Add(sumElemet);
}
}
#region PAGE OPTIONS
if (reportMaster.FinalPage_Id.HasValue && reportMaster.FinalPage_Id.Value > 0)
{
XDocument finalPage = this.repo.GetReportXml(reportMaster.FinalPage_Id.Value);
if (finalPage != null)
{
xmlReport.Root.AddFirst(finalPage.Root.Elements());
}
}
if (reportMaster.HeaderAndFooterPage_Id.HasValue && reportMaster.HeaderAndFooterPage_Id.Value > 0)
{
XDocument headerAndFooterPage = this.repo.GetReportXml(reportMaster.HeaderAndFooterPage_Id.Value);
if (headerAndFooterPage != null)
{
xmlReport.Root.AddFirst(headerAndFooterPage.Root.Elements());
}
}
if (reportMaster.CoverPage_Id.HasValue && reportMaster.CoverPage_Id.Value > 0)
{
XDocument coverPage = this.repo.GetReportXml(reportMaster.CoverPage_Id.Value);
if (coverPage != null)
{
xmlReport.Root.AddFirst(coverPage.Root.Elements());
}
}
#endregion
#region PAGE SETUP
XElement pageSetup = new XElement("PageSetup");
pageSetup.Add(new XAttribute("PaperKindEnum", reportMaster.PaperKindEnum));
pageSetup.Add(new XAttribute("PageOrientationEnum", reportMaster.PageOrientationEnum));
pageSetup.Add(new XAttribute("PageMarginBottom", reportMaster.PageMarginBottom));
pageSetup.Add(new XAttribute("PageMarginLeft", reportMaster.PageMarginLeft));
pageSetup.Add(new XAttribute("PageMarginRight", reportMaster.PageMarginRight));
pageSetup.Add(new XAttribute("PageMarginTop", reportMaster.PageMarginTop));
xmlReport.Root.AddFirst(pageSetup);
#endregion
this.repo.UpdateXmlPrinteCount(reportMaster.MasterReport_Id);
this.RunUpdateStements(xmlReport);
return(xmlReport);
}
static void Main(string[] args)
{
ReportMaster rm = new ReportMaster(args[0], args[1], args[2]);
rm.Run();
}
public ActionResult SearchedReports(int?pageno, string searchkey, ReportMaster r, string sortby)
{
/* Report Search by its ReportTitle */
searchkey = searchkey.Trim();
if (!string.IsNullOrEmpty(searchkey))
{
#region ReportTitleOnly
var pricesort = sortby;
var SearchedReport = (from x in db.ReportMasters
join c in db.CategoryMasters
on x.CategoryId equals c.CategoryId
join p in db.PublisherMasters
on x.PublishereId equals p.PublisherId
where x.ReportTitle.Contains(searchkey)
orderby x.PublishingDate descending
select new ReportVM
{
ReportTitle = x.ReportTitle,
ReportUrl = x.ReportUrl,
FullDescription = x.LongDescritpion.Substring(0, 300),
NumberOfPage = x.NumberOfPages,
PriceSingleUser = x.SinglePrice,
PublishingDate = x.PublishingDate,
CategoryName = c.CategoryName,
CategoryUrl = c.CategoryUrl,
PublisherName = p.ContactName,
PublisherId = p.PublisherId,
PublishingUrl = p.publisherUrl,
CategoryId = c.CategoryId,
ReportImage = ""
}).ToList();
foreach (var item in SearchedReport)
{
item.ReportImage = DDLGetparents(item.CategoryId);
}
var Reports = (from z in SearchedReport
select new ReportVM
{
ReportTitle = z.ReportTitle,
ReportUrl = z.ReportUrl,
FullDescription = Regex.Replace(z.FullDescription, @"<[^>]+>| ", "").Trim(),
NumberOfPage = z.NumberOfPage,
PriceSingleUser = z.PriceSingleUser,
PublishingDate = z.PublishingDate,
CategoryName = z.CategoryName,
CategoryUrl = z.CategoryUrl,
PublisherId = z.PublisherId,
PublisherName = z.PublisherName,
PublishingUrl = z.PublishingUrl,
ReportImage = z.ReportImage
}).ToPagedList(pageno ?? 1, 10);
if (Reports.Count > 0)
{
//var z = new StaticPagedList<ReportDetails>(Reports, pageno ?? 1, 10, Reports.TotalItemCount);
ViewBag.TotalReports = Reports.Count;
ViewBag.SearchedKeyword = searchkey;
return(View(Reports));
}
else
{
ViewBag.NoReport = "Reports not found for such keyword !....";
return(View());
}
#endregion ReportTitle
}
else
{
// return View(r);
return(HttpNotFound());
}
}
// [CustomAuthentication("ReportUploader", "Create,Edit,Delete")]
public ActionResult Import(HttpPostedFileBase excelfile)
{
string Value = string.Empty;
List <ReportMaster> reportlist = new List <ReportMaster>();
// Excelimport (excelfile);
if (excelfile == null || excelfile.ContentLength == 0)
{
ViewBag.Error = "Upload the excel file !....";
return(View("Index"));
}
else
{
if (excelfile.FileName.EndsWith("xsl") || excelfile.FileName.EndsWith("xlsx"))
{
string path = "";
// string path = Server.MapPath("~/Content/" + excelfile.FileName + DateTime.Now.ToString("MM.dd.yyyy-hh.mm.ss"));
try
{
//path = Server.MapPath("~/UploadSheet/" + excelfile.FileName + DateTime.Now.ToString("MM.dd.yyyy"));
path = Server.MapPath("~/UploadSheet/");
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
excelfile.SaveAs(path + Path.GetFileName(excelfile.FileName));
path = path + Path.GetFileName(excelfile.FileName);
string sFileExtention = Path.GetExtension(path);
ISheet sheet;
using (var stream = new FileStream(path, FileMode.Open))
{
stream.Position = 0;
if (sFileExtention == ".xls")
{
HSSFWorkbook hSSFWorkbook = new HSSFWorkbook(stream);
sheet = hSSFWorkbook.GetSheetAt(0);
}
else
{
XSSFWorkbook sSFWorkbook = new XSSFWorkbook(stream);
sheet = sSFWorkbook.GetSheetAt(0);
}
IRow hrow = sheet.GetRow(0);
int lastcell = hrow.LastCellNum;
string HTMLTable = "<table border='1'>";
for (int i = 1; i <= sheet.LastRowNum; i++)
{
IRow row1 = sheet.GetRow(i);
ReportMaster r = new ReportMaster();
int _SerialNumber;
int SerialNumber = 0;
int _CategoryID;
int _PublisherID;
int _DeliveryFormatID;
DateTime _PublishedDate;
int _NumberOfPages;
Decimal _SingleUserPrice;
Decimal _MultiUserPrice;
Decimal _CorporateUserPrice;
bool IsVaidate = true;
string _MetaTitle = "";
string Message = "";
string ReportTitleTemp = string.Empty;
for (int j = 0; j < lastcell; j++)
{
if (Convert.ToString(hrow.Cells[j]) == "Serial Number")
{
if (Int32.TryParse(row1.Cells[j].ToString().Trim(), out _SerialNumber))
{
SerialNumber = _SerialNumber;
}
else
{
IsVaidate = false; Message += "Serial Number<br />";
}
}
else if (Convert.ToString(hrow.Cells[j]) == "Category ID")
{
if (Int32.TryParse(row1.Cells[j].ToString().Trim(), out _CategoryID))
{
r.CategoryId = _CategoryID;
}
else
{
IsVaidate = false; Message += "Category ID <br />";
}
}
else if (hrow.Cells[j].ToString() == "Publisher ID")
{
if (Int32.TryParse(row1.Cells[j].ToString().Trim(), out _PublisherID))
{
r.PublishereId = _PublisherID;
}
else
{
IsVaidate = false; Message += "Publisher ID <br />";
}
}
else if (hrow.Cells[j].ToString() == "Delivery Format ID")
{
if (Int32.TryParse(row1.Cells[j].ToString().Trim(), out _DeliveryFormatID))
{
r.ReportDeliveryTypeId = _DeliveryFormatID;
}
else
{
IsVaidate = false; Message += "Delivery Format ID <br />";
}
}
else if (hrow.Cells[j].ToString() == "Title")
{
ReportTitleTemp = Convert.ToString(row1.Cells[j].ToString().Trim());
if (db.ReportMasters.Count(g => g.ReportTitle == ReportTitleTemp) > 0 ? true : false)
{
IsVaidate = false; Message += "Title <br />";
}
else
{
r.ReportTitle = row1.Cells[j].ToString().Trim().Replace(" ", " ").Replace(" ", " ").Replace(" ", " ");
}
r.ReportUrl = ExcellentMarketResearch.Areas.Admin.Models.Common.GenerateSlug(row1.Cells[j].ToString().Trim());
if (db.ReportMasters.Count(url => url.ReportUrl == r.ReportUrl.ToLower()) > 0 ? true : false)
{
r.ReportUrl = ""; IsVaidate = false; Message += "Long URL <br />";
}
}
else if (hrow.Cells[j].ToString() == "Published Date")
{
if (DateTime.TryParse(row1.Cells[j].ToString().Trim(), out _PublishedDate))
{
r.PublishingDate = _PublishedDate;
}
else
{
IsVaidate = false; Message += "Published Date <br />";
}
}
else if (hrow.Cells[j].ToString() == "Number Of Pages")
{
if (Int32.TryParse(row1.Cells[j].ToString().Trim(), out _NumberOfPages))
{
r.NumberOfPages = _NumberOfPages;
}
else
{
IsVaidate = false; Message += "Number Of Pages <br />";
}
}
else if (hrow.Cells[j].ToString() == "Long Description")
{
if (row1.Cells[j].ToString().Trim() != "")
{
r.LongDescritpion = "<pre>" + row1.Cells[j].ToString().Trim() + "</pre>";
}
else
{
IsVaidate = false; Message += "Long Description \n";
}
}
else if (hrow.Cells[j].ToString() == "Long Table Of Content")
{
r.TableOfContent = "<pre>" + row1.Cells[j].ToString().Trim() + "</pre>";
}
else if (hrow.Cells[j].ToString() == "Single User Price")
{
if (Decimal.TryParse(row1.Cells[j].ToString().Trim() == "" ? "0" : row1.Cells[j].ToString().Trim(), out _SingleUserPrice))
{
r.SinglePrice = _SingleUserPrice;
}
else
{
IsVaidate = false; Message += "Single User Price <br />";
}
}
else if (hrow.Cells[j].ToString() == "Multi User Price")
{
if (Decimal.TryParse(row1.Cells[j].ToString().Trim() == "" ? "0" : row1.Cells[j].ToString().Trim(), out _MultiUserPrice))
{
r.MultiUserPrice = _MultiUserPrice;
}
else
{
IsVaidate = false; Message += "Multi User Price <br />";
}
}
else if (hrow.Cells[j].ToString() == "Corporate User Price")
{
if (Decimal.TryParse(row1.Cells[j].ToString().Trim() == "" ? "0" : row1.Cells[j].ToString().Trim(), out _CorporateUserPrice))
{
r.CorporateUserPrice = _CorporateUserPrice;
}
else
{
IsVaidate = false; Message += "Corporate User Price <br />";
}
}
}
if (r.SinglePrice <= 0 && r.MultiUserPrice <= 0 && r.CorporateUserPrice <= 0)
{
IsVaidate = false; Message += "Add Atleast one Price <br />";
}
if (IsVaidate)
{
r.ReportImage = null;
r.IsActive = true;
r.ReportTypeId = r.ReportDeliveryTypeId;
r.CreatedBy = 1; //Convert.ToInt32(QYGroupRepository.Areas.Admin.Models.CommonCode.MySession());
r.CreatedDate = DateTime.Now;
//reportlist.Add(r);
db.ReportMasters.Add(r);
db.SaveChanges();
var repturl = r.ReportUrl + ".html";
r.ReportUrl = repturl;
db.Entry(r).State = EntityState.Modified;
db.SaveChanges();
Message += "Inserted <br/>";
}
HTMLTable += "<tr><td>" + SerialNumber + "</td><td>" + ReportTitleTemp + "</td><td>" + r.ReportUrl + "</td><td>" + Message + "</td></tr>";
}
HTMLTable += "</table>";
ViewBag.Html = HTMLTable;
return(View());
//ViewData.Add("HTMLTable", HTMLTable);
//ViewData["HTMLTable"] = HTMLTable;
}
}
catch (Exception ex)
{
var x = "<br />Report status: The file could not be processed. The following error occured: " + ex.Message;
}
finally
{
}
}
}
return(View());
}
