public ActionResult Index(StrataBoardModel strataBoardModel)
{
ModelState["ExpiredOnTo"].Errors.Clear();
ModelState["ExpiredOnFrom"].Errors.Clear();
ModelState["Keyword"].Errors.Clear();
return(BindList(strataBoardModel));
}
public static string FncSendReminderMailToClient(string emailAddress, string AdminEmailIds, long stratasBoardId, string message)
{
try
{
StrataBoardHelper strataBoardHelper = new StrataBoardHelper();
StrataBoardModel strataBoardModel = new StrataBoardModel();
strataBoardModel = strataBoardHelper.GetStratasBoardByID(stratasBoardId);
//string url = ConfigurationManager.AppSettings["WebsiteRootPath"].ToString();
//EmailSender objClsMail = GetCommonDataForSendMail(emailAddress, "Reminder from StratasFair");
//StringBuilder mailBody = new StringBuilder();
//mailBody.Append(getConfigValue("stratasboard-reminder-mail").Replace("{NAME}", strataBoardModel.StratasBoardName));
//mailBody.Replace("{BASEPATH}", url);
//mailBody.Replace("{MESSAGE}", message);
//objClsMail.Body = mailBody.ToString();
//objClsMail.Bcc = AdminEmailIds;
//for attachment
//objClsMail.AttachmentList = new ArrayList(1);
//objClsMail.AttachmentList.Add(System.Web.HttpContext.Current.Server.MapPath(objOrder.InvoiceFilePath));
//objClsMail = FncSendMail(objClsMail);
//return objClsMail.ErrorMessage;
return("success");
}
catch
{
return("");
}
}
public ActionResult Add()
{
ViewBag.StatusList = AppLogic.BindDDStatus(1);
StrataBoardModel strataBoardModel = new StrataBoardModel();
strataBoardModel.Status = 1;
return(View(strataBoardModel));
}
public ActionResult Add(StrataBoardModel strataBoardModel)
{
if (ModelState.IsValid)
{
StrataBoardHelper strataBoardHelper = new StrataBoardHelper();
long stratasBoardId = strataBoardHelper.AddUpdate(strataBoardModel);
if (stratasBoardId > 0)
{
// stratas board admin added successfully
try
{
// send mail to stratas board admin with auto generate password.
string result = EmailSender.FncSend_StratasBoard_RegistrationMail_ToClient(stratasBoardId);
if (result == "success")
{
TempData["CommonMessage"] = AppLogic.setMessage(0, "Record added successfully.");
}
else
{
TempData["CommonMessage"] = AppLogic.setMessage(2, "Error, while sending email to stratasboard administrator. Resend mail again.");
}
}
catch (Exception ex)
{
new AppError().LogMe(ex);
}
return(RedirectToAction("Index"));
}
else if (stratasBoardId == -4)
{
TempData["CommonMessage"] = AppLogic.setMessage(1, "Stratasboard name already exists.");
ViewBag.StatusList = AppLogic.BindDDStatus(1);
return(View(strataBoardModel));
}
else if (stratasBoardId == -5)
{
TempData["CommonMessage"] = AppLogic.setMessage(1, "Unique name already exists.");
ViewBag.StatusList = AppLogic.BindDDStatus(1);
return(View(strataBoardModel));
}
else if (stratasBoardId == -6)
{
TempData["CommonMessage"] = AppLogic.setMessage(1, "Email address already exists.");
ViewBag.StatusList = AppLogic.BindDDStatus(1);
return(View(strataBoardModel));
}
else
{
ViewBag.StatusList = AppLogic.BindDDStatus(1);
TempData["CommonMessage"] = AppLogic.setMessage(2, "Error, Please try again.");
return(View(strataBoardModel));
}
}
ViewBag.StatusList = AppLogic.BindDDStatus(1);
return(View(strataBoardModel));
}
private ActionResult BindList(StrataBoardModel strataBoardModel)
{
StrataBoardHelper _Helper = new StrataBoardHelper();
var List = _Helper.GetAll(strataBoardModel);
ActiveList = List.Where(x => x.Status == 1).ToList();
InActiveList = List.Where(x => x.Status == 0).ToList();
return(View(Tuple.Create(ActiveList, InActiveList, strataBoardModel)));
}
public ActionResult Edit(long?Id)
{
StrataBoardHelper strataBoardHelper = new StrataBoardHelper();
StrataBoardModel strataBoardModel = new StrataBoardModel();
strataBoardModel = strataBoardHelper.GetStratasBoardByID(Id.Value);
ViewBag.StatusList = AppLogic.BindDDStatus(Convert.ToInt32(strataBoardModel.Status));
return(View(strataBoardModel));
}
public List <StrataBoardModel> GetAll(StrataBoardModel model)
{
var myQuery = context.vw_GetStratasBoard.ToList();
if (model.ExpiredOnFrom.Year > 1900 && model.ExpiredOnTo.Year > 1900)
{
myQuery = myQuery.Where(x => (x.ExpiryDate >= model.ExpiredOnFrom && x.ExpiryDate <= model.ExpiredOnTo)).ToList();
}
else if (model.ExpiredOnFrom.Year > 1900)
{
myQuery = myQuery.Where(x => x.ExpiryDate >= model.ExpiredOnFrom).ToList();
}
else if (model.ExpiredOnTo.Year > 1900)
{
myQuery = myQuery.Where(x => x.ExpiryDate <= model.ExpiredOnTo).ToList();
}
if (model.Keyword != null && model.Keyword != "")
{
myQuery = myQuery.Where(x => x.StratasBoardName.Contains(model.Keyword)
//|| x.FirstName.Contains(model.Keyword)
//|| x.LastName.Contains(model.Keyword)
|| x.PortalLink.Contains(model.Keyword) ||
x.EmailId.Contains(model.Keyword)
).ToList();
}
return(myQuery
//.Where(x => x.LicenseType == (model.LicenseType > 0 ? model.LicenseType : x.LicenseType))
.OrderByDescending(x => x.CreatedOn)
.Select(x => new StrataBoardModel()
{
StratasBoardId = x.StratasBoardId,
StratasBoardName = x.StratasBoardName,
PortalLink = x.PortalLink,
FirstName = x.FirstName,
LastName = x.LastName,
EmailId = x.EmailId,
ContactNumber = x.ContactNumber,
CreatedOn = x.CreatedOn.Value,
SubscriptionId = x.SubscriptionId.Value,
ExpiryDate = x.ExpiryDate.ToString(),
AllowedUser = x.AllowedUser.Value,
Status = x.STATUS.Value,
SubscriptionName = x.SubscriptionName,
ValidityText = x.ValidityText,
IsSmsForAlert = x.IsSmsForAlert.Value,
IsSmsForReminder = x.IsSmsForReminder.Value,
RequestPortalLink = x.RequestPortalLink,
RequestMessage = x.RequestMessage,
RequestCreatedOn = x.RequestCreatedOn.ToString(),
RequestCounter = x.RequestCounter,
RequestCreatedBy = x.RequestCreatedBy
}).ToList());
}
public long AddUpdate(StrataBoardModel objectModel)
{
if (objectModel.StratasBoardId > 0)
{
if (objectModel.PortalLink != objectModel.OldPortalLink &&
context.tblUserClients.Where(x => x.StratasBoardId == objectModel.StratasBoardId && x.RoleName.ToLower() != "a").Count() > 0)
{
// unique name can't be updated when a sub-admin or Owner has already assigned to this StratasBoardId.
return(-7);
}
else if (context.tblStratasBoards.Any(x => x.StratasBoardName == objectModel.StratasBoardName && x.StratasBoardId != objectModel.StratasBoardId))
{
// stratasboard name already exists
return(-4);
}
else if (context.tblStratasBoards.Any(x => x.PortalLink == objectModel.PortalLink && x.StratasBoardId != objectModel.StratasBoardId))
{
// portal link already exists
return(-5);
}
else if (context.tblUserClients.Any(x => x.EmailId == objectModel.EmailId && x.StratasBoardId != objectModel.StratasBoardId))
{
// registered emailid already exists
return(-6);
}
else
{
return(update(objectModel));
}
}
else
{
if (context.tblStratasBoards.Any(x => x.StratasBoardName == objectModel.StratasBoardName))
{
// stratasboard name already exists
return(-4);
}
else if (context.tblStratasBoards.Any(x => x.PortalLink == objectModel.PortalLink))
{
// portal link already exists
return(-5);
}
else if (context.tblUserClients.Any(x => x.EmailId == objectModel.EmailId))
{
// registered emailid already exists
return(-6);
}
else
{
return(update(objectModel));
}
}
}
public ActionResult Edit(StrataBoardModel strataBoardModel)
{
ModelState.Remove("SubscriptionId");
if (ModelState.IsValid)
{
StrataBoardHelper strataBoardHelper = new StrataBoardHelper();
long stratasBoardId = strataBoardHelper.AddUpdate(strataBoardModel);
if (stratasBoardId > 0)
{
// send mail to stratas board admin with updated unique URL.
if (strataBoardModel.OldPortalLink.Trim() != strataBoardModel.PortalLink.Trim())
{
string result = EmailSender.FncSend_StratasBoard_UniqueURLUpdate_ToClient(stratasBoardId);
}
TempData["CommonMessage"] = AppLogic.setMessage(0, "Record updated successfully.");
return(RedirectToAction("Index"));
}
else if (stratasBoardId == -4)
{
TempData["CommonMessage"] = AppLogic.setMessage(1, "Stratasboard name already exists.");
}
else if (stratasBoardId == -5)
{
TempData["CommonMessage"] = AppLogic.setMessage(1, "Unique name already exists.");
}
else if (stratasBoardId == -6)
{
TempData["CommonMessage"] = AppLogic.setMessage(1, "Email address already exists.");
}
else if (stratasBoardId == -7)
{
TempData["CommonMessage"] = AppLogic.setMessage(1, "Unique name can't be updated.");
}
else
{
TempData["CommonMessage"] = AppLogic.setMessage(2, "Error, Please try again.");
}
}
ViewBag.StatusList = AppLogic.BindDDStatus(Convert.ToInt32(strataBoardModel.Status));
return(View(strataBoardModel));
}
public int Delete(StrataBoardModel objectModel)
{
int count = -1;
// check the user exists on this strata, if exists then return...
if (context.tblUserClients.Any(o => o.StratasBoardId == objectModel.StratasBoardId && o.RoleName.ToLower() != "a"))
{
count = -2;
return(count);
}
// Delete the users on this strata
if (context.tblUserClients.Any(x => x.StratasBoardId == objectModel.StratasBoardId))
{
context.tblUserClients.RemoveRange(context.tblUserClients.Where(x => x.StratasBoardId == objectModel.StratasBoardId));
context.SaveChanges();
count = 0;
}
// Delete the subscription details on this strata
if (context.tblStratasBoardSubscriptions.Any(x => x.StratasBoardId == objectModel.StratasBoardId))
{
context.tblStratasBoardSubscriptions.RemoveRange(context.tblStratasBoardSubscriptions.Where(x => x.StratasBoardId == objectModel.StratasBoardId));
context.SaveChanges();
count = 0;
}
tblStratasBoard tblStratasBoardDb = new tblStratasBoard();
tblStratasBoardDb.StratasBoardId = objectModel.StratasBoardId;
context.Entry(tblStratasBoardDb).State = EntityState.Deleted;
count = context.SaveChanges();
if (count == 1)
{
count = 0;
}
else
{
count = -1;
}
return(count);
}
public ActionResult Deactive(long Id)
{
StrataBoardHelper strataBoardHelper = new StrataBoardHelper();
StrataBoardModel strataBoardModel = new StrataBoardModel();
strataBoardModel = strataBoardHelper.GetStratasBoardByID(Id);
strataBoardModel.Status = 0;
int count = strataBoardHelper.ActDeact(strataBoardModel);
if (count == 0)
{
TempData["CommonMessage"] = AppLogic.setMessage(count, "Record deactivated successfully.");
}
else
{
TempData["CommonMessage"] = AppLogic.setMessage(count, "Record deactivation failed.");
}
return(RedirectToAction("Index"));
}
public int ActDeact(StrataBoardModel objectModel)
{
tblStratasBoard tblStratasBoardDb = new tblStratasBoard();
tblStratasBoardDb.StratasBoardId = objectModel.StratasBoardId;
tblStratasBoardDb.Status = objectModel.Status;
context.tblStratasBoards.Attach(tblStratasBoardDb);
context.Entry(tblStratasBoardDb).Property(x => x.Status).IsModified = true;
int count = context.SaveChanges();
if (count == 1)
{
count = 0;
}
else
{
count = -1;
}
return(count);
}
public ActionResult Delete(long Id)
{
StrataBoardHelper strataBoardHelper = new StrataBoardHelper();
StrataBoardModel strataBoardModel = new StrataBoardModel();
strataBoardModel = strataBoardHelper.GetStratasBoardByID(Id);
int count = strataBoardHelper.Delete(strataBoardModel);
if (count == 0)
{
TempData["CommonMessage"] = AppLogic.setMessage(count, "Record deleted successfully.");
}
else if (count == -2)
{
TempData["CommonMessage"] = AppLogic.setMessage(count, "Record can't be deleted as other users exists.");
}
else
{
TempData["CommonMessage"] = AppLogic.setMessage(count, "Record deletion failed.");
}
return(RedirectToAction("Index"));
}
public ActionResult Index()
{
if (ClientSessionData.UserClientId != 0)
{
StrataBoardModel strataBoardModel = new StrataBoardModel();
strataBoardModel = strataBoardHelper.GetStratasBoardByID(ClientSessionData.ClientStrataBoardId);
if (ClientSessionData.ClientRoleName.ToLower() == "owner")
{
if (!ClientSessionData.ClientIsProfileCompleted)
{
return(Redirect(Url.Content("~/" + strataBoardModel.PortalLink + "/logon/completeprofile")));
}
else
{
return(Redirect(Url.Content("~/" + strataBoardModel.PortalLink + "/dashboard/dashboardowner")));
}
}
else
{
return(Redirect(Url.Content("~/" + strataBoardModel.PortalLink + "/dashboard")));
}
}
else
{
string PortalUrl = clientLoginHelper.GetPortalUrlFromCurrentUrl();
var IsExistPortalUrl = _context.tblStratasBoards.Where(x => x.PortalLink == PortalUrl && x.Status == 0);
if (IsExistPortalUrl.Count() > 0)
{
return(Redirect(Url.Content("~/" + PortalUrl + "/logon/invalidportallink")));
}
else
{
return(View());
}
}
}
public long update(StrataBoardModel objectModel)
{
long count = -2;
long stratasBoardId = 0;
long userClientId = 0;
if (objectModel.StratasBoardId > 0)
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
// Table StratasBoard
tblStratasBoard tblStratasBoardDb = new tblStratasBoard();
tblStratasBoardDb.StratasBoardId = objectModel.StratasBoardId;
tblStratasBoardDb.StratasBoardName = objectModel.StratasBoardName;
tblStratasBoardDb.BuildingName = objectModel.BuildingName;
tblStratasBoardDb.PortalLink = objectModel.PortalLink.Trim();
tblStratasBoardDb.Status = objectModel.Status;
tblStratasBoardDb.ModifiedBy = AdminSessionData.AdminUserId;
tblStratasBoardDb.ModifiedOn = DateTime.UtcNow;
tblStratasBoardDb.ModifiedFromIP = HttpContext.Current.Request.UserHostAddress;
if (objectModel.PortalLink == objectModel.RequestPortalLink)
{
tblStratasBoardDb.RequestCounter = 1;
}
context.tblStratasBoards.Attach(tblStratasBoardDb);
context.Entry(tblStratasBoardDb).Property(x => x.StratasBoardName).IsModified = true;
context.Entry(tblStratasBoardDb).Property(x => x.BuildingName).IsModified = true;
context.Entry(tblStratasBoardDb).Property(x => x.PortalLink).IsModified = true;
context.Entry(tblStratasBoardDb).Property(x => x.Status).IsModified = true;
context.Entry(tblStratasBoardDb).Property(x => x.ModifiedBy).IsModified = true;
context.Entry(tblStratasBoardDb).Property(x => x.ModifiedOn).IsModified = true;
context.Entry(tblStratasBoardDb).Property(x => x.ModifiedFromIP).IsModified = true;
context.Entry(tblStratasBoardDb).Property(x => x.RequestCounter).IsModified = true;
// Table UserClient
count = context.SaveChanges();
if (count >= 0)
{
tblUserClient tblUserClientDb = new tblUserClient();
tblUserClientDb.UserClientId = objectModel.UserClientId;
tblUserClientDb.FirstName = objectModel.FirstName;
tblUserClientDb.LastName = objectModel.LastName;
tblUserClientDb.EmailId = objectModel.EmailId;
tblUserClientDb.ContactNumber = objectModel.ContactNumber;
tblUserClientDb.ModifiedBy = AdminSessionData.AdminUserId;
tblUserClientDb.ModifiedOn = DateTime.UtcNow;
tblUserClientDb.ModifiedFromIP = HttpContext.Current.Request.UserHostAddress;
context.tblUserClients.Attach(tblUserClientDb);
context.Entry(tblUserClientDb).Property(x => x.FirstName).IsModified = true;
context.Entry(tblUserClientDb).Property(x => x.LastName).IsModified = true;
//context.Entry(tblUserClientDb).Property(x => x.EmailId).IsModified = true;
context.Entry(tblUserClientDb).Property(x => x.ContactNumber).IsModified = true;
context.Entry(tblUserClientDb).Property(x => x.ModifiedBy).IsModified = true;
context.Entry(tblUserClientDb).Property(x => x.ModifiedOn).IsModified = true;
context.Entry(tblUserClientDb).Property(x => x.ModifiedFromIP).IsModified = true;
count = context.SaveChanges();
if (count >= 0)
{
transaction.Commit();
count = objectModel.StratasBoardId;
}
else
{
transaction.Rollback();
count = -2; // any error is there
}
}
else
{
transaction.Rollback();
count = -2; // any error is there
}
}
catch (Exception ex)
{
new AppError().LogMe(ex);
transaction.Rollback();
count = -2; // any error is there
}
}
}
else
{
using (var transaction = context.Database.BeginTransaction())
{
var subscriptionDetails = context.tblSubscriptions.Where(x => x.SubscriptionId == objectModel.SubscriptionId).FirstOrDefault();
try
{
// Table StratasBoard
tblStratasBoard tblStratasBoardDb = new tblStratasBoard();
tblStratasBoardDb.StratasBoardName = objectModel.StratasBoardName;
tblStratasBoardDb.BuildingName = objectModel.BuildingName;
tblStratasBoardDb.PortalLink = objectModel.PortalLink;
tblStratasBoardDb.CreatedBy = AdminSessionData.AdminUserId;
tblStratasBoardDb.CreatedOn = DateTime.UtcNow;
tblStratasBoardDb.CreatedFromIP = HttpContext.Current.Request.UserHostAddress;
tblStratasBoardDb.Status = objectModel.Status;
context.tblStratasBoards.Add(tblStratasBoardDb);
context.SaveChanges();
stratasBoardId = tblStratasBoardDb.StratasBoardId;
if (stratasBoardId > 0)
{
// Table UserClient
tblUserClient tblUserClientDb = new tblUserClient();
tblUserClientDb.FirstName = objectModel.FirstName;
tblUserClientDb.LastName = objectModel.LastName;
tblUserClientDb.EmailId = objectModel.EmailId;
tblUserClientDb.Password = AppLogic.EncryptPassword();
tblUserClientDb.ContactNumber = objectModel.ContactNumber;
tblUserClientDb.StratasBoardId = stratasBoardId;
tblUserClientDb.RoleName = "A"; // StratasBoard Admin
tblUserClientDb.IsEmailNotification = true;
tblUserClientDb.IsSMSNotification = true;
tblUserClientDb.IsProfileComplete = false;
tblUserClientDb.Status = 1; // It will be active in both the cases
tblUserClientDb.CreatedBy = AdminSessionData.AdminUserId;
tblUserClientDb.CreatedOn = DateTime.UtcNow;
tblUserClientDb.LastLogin = DateTime.UtcNow;
tblUserClientDb.CurrentLogin = DateTime.UtcNow;
tblUserClientDb.CreatedFromIP = HttpContext.Current.Request.UserHostAddress;
context.tblUserClients.Add(tblUserClientDb);
context.SaveChanges();
userClientId = tblUserClientDb.UserClientId;
if (userClientId > 0)
{
// Table StratasBoard Subscription
tblStratasBoardSubscription tblStratasBoardSubscriptionDb = new tblStratasBoardSubscription();
tblStratasBoardSubscriptionDb.StratasBoardId = stratasBoardId;
tblStratasBoardSubscriptionDb.SubscriptionId = objectModel.SubscriptionId;
tblStratasBoardSubscriptionDb.Validity = subscriptionDetails.Validity;
tblStratasBoardSubscriptionDb.IsSmsForAlert = subscriptionDetails.IsSmsForAlert;
tblStratasBoardSubscriptionDb.IsSmsForReminder = subscriptionDetails.IsSmsForReminder;
tblStratasBoardSubscriptionDb.AllowedUser = subscriptionDetails.AllowedUser;
tblStratasBoardSubscriptionDb.ExpiryDate = AppLogic.CalculateSubscriptionExpiryDate(DateTime.UtcNow, subscriptionDetails.Validity);
tblStratasBoardSubscriptionDb.CreatedBy = AdminSessionData.AdminUserId;
tblStratasBoardSubscriptionDb.CreatedOn = DateTime.UtcNow;
tblStratasBoardSubscriptionDb.Status = 1;
context.tblStratasBoardSubscriptions.Add(tblStratasBoardSubscriptionDb);
context.SaveChanges();
int stratasBoardSubscriptionId = tblStratasBoardSubscriptionDb.StratasBoardSubscriptionId;
if (stratasBoardSubscriptionId > 0)
{
transaction.Commit();
count = stratasBoardId;
}
else
{
transaction.Rollback();
count = -2; // any error is there
}
}
else
{
transaction.Rollback();
count = -2; // any error is there
}
}
else
{
transaction.Rollback();
count = -2; // any error is there
}
}
catch (Exception ex)
{
new AppError().LogMe(ex);
transaction.Rollback();
count = -2; // any error is there
}
}
}
return(count);
}
// GET: Administrator/Client
public ActionResult Index()
{
StrataBoardModel strataBoardModel = new StrataBoardModel();
return(BindList(strataBoardModel));
}
public ActionResult ClientExportToPdf(string dfrom, string dto, string kw)
{
try
{
ConvertToPdf convertToPdf = new ConvertToPdf();
string filename = "stratasboard_" + DateTime.Now.Day.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Year.ToString() + ".pdf";
string FilePath = "~/Content/Resources/Reports/" + filename;
convertToPdf.FncDeleteFile(FilePath);
StrataBoardHelper objLedgerHelper = new StrataBoardHelper();
StrataBoardModel objLedgerModel = new StrataBoardModel
{
PageNumber = 1,
PageSize = 100000000
};
objLedgerModel.ExpiredOnFrom = DateTime.Parse(dfrom);
objLedgerModel.ExpiredOnTo = DateTime.Parse(dto);
objLedgerModel.Keyword = kw;
List <StrataBoardModel> listLedgerModel = objLedgerHelper.GetAll(objLedgerModel);
DataTable dt = new DataTable();
dt.Columns.Add("Stratasboard name");
dt.Columns.Add("Unique name");
dt.Columns.Add("Name");
dt.Columns.Add("Email address");
dt.Columns.Add("Contact number");
dt.Columns.Add("Created on");
dt.Columns.Add("Subscription name");
dt.Columns.Add("Validity");
dt.Columns.Add("Expiration date");
dt.Columns.Add("Allowed user");
dt.Columns.Add("IsSmsForAlert");
dt.Columns.Add("IsSmsForReminder");
dt.Columns.Add("Status");
if (listLedgerModel.Count() != 0)
{
foreach (var item in listLedgerModel)
{
DataRow row = dt.NewRow();
row["Stratasboard name"] = item.StratasBoardName;
row["Unique name"] = item.PortalLink;
row["Name"] = item.FirstName + " " + item.LastName;
row["Email address"] = item.EmailId;
row["Contact number"] = item.ContactNumber;
row["Created on"] = AppLogic.GetDateFromatForCsv(Convert.ToDateTime(item.CreatedOn));
row["Subscription name"] = item.SubscriptionName;
row["Validity"] = item.ValidityText;
row["Expiration date"] = AppLogic.GetDateFromatForCsv(Convert.ToDateTime(item.ExpiryDate));
row["Allowed user"] = item.AllowedUser;
row["IsSmsForAlert"] = AppLogic.GetYesNo(item.IsSmsForAlert);
row["IsSmsForReminder"] = AppLogic.GetYesNo(item.IsSmsForReminder);
row["Status"] = AppLogic.GetStatus(item.Status.ToString());
dt.Rows.Add(row);
}
}
if (dt.Rows.Count > 0)
{
FileStream fs = new FileStream(Server.MapPath(FilePath), FileMode.Create, FileAccess.Write, FileShare.None);
iTextSharp.text.Rectangle rec = new iTextSharp.text.Rectangle(PageSize.A4);
//Rectangle rec = new Rectangle(PageSize.A4.Rotate());
//rec.BackgroundColor = new BaseColor(System.Drawing.Color.WhiteSmoke);
//rec2.BackgroundColor = new CMYKColor(25, 90, 25, 0);
//72 points = 1 inch
//Left Margin: 36pt => 0.5 inch
//Right Margin: 72pt => 1 inch
//Top Margin: 108pt => 1.5 inch
//Bottom Margini: 180pt => 2.5 inch
Document doc = new Document(rec, 18, 18, 72, 72);
PdfWriter writer = PdfWriter.GetInstance(doc, fs);
doc.Open();
doc.AddTitle("stratasboard listing");
doc.AddCreator("stratafair");
//doc.AddSubject("This is an Example 4 of Chapter 1 of Book 'iText in Action'");
//doc.AddKeywords("Metadata, iTextSharp 5.4.4, Chapter 1, Tutorial");
//doc.AddAuthor("pankaj jain");
//doc.AddHeader("Nothing", "No Header");
//Paragraph para = new Paragraph("Hello World");
// Setting paragraph's text alignment using iTextSharp.text.Element class
// para.Alignment = Element.ALIGN_JUSTIFIED;
// Adding this 'para' to the Document object
// doc.Add(para);
PdfPTable table = new PdfPTable(13);
table.HorizontalAlignment = 0;
table.TotalWidth = 550f;
table.LockedWidth = true;
// Font fontHeader = FontFactory.GetFont("ARIAL", 8);
// sum must equal to Total Width of table
// number of sizes must equal to number of columns
float[] widths = new float[] { 80f, 80f, 50f, 80f, 50f, 80f, 80f, 40f, 50f, 50f, 50f, 40f, 40f };
table.SetWidths(widths);
int iColCount = dt.Columns.Count;
for (int i = 0; i < iColCount; i++)
{
//PdfPCell pdfPCell = new PdfPCell(new Phrase(new Chunk(dt.Columns[i].ToString(), fontHeader)));
//table.AddCell(pdfPCell);
ConvertToPdf.AddHeaderCell(table, dt.Columns[i].ToString(), 1, 7, "C", "C");
}
foreach (DataRow dr in dt.Rows)
{
for (int i = 0; i < iColCount; i++)
{
ConvertToPdf.AddCell(table, dr[i].ToString(), 1, 7, "C", "C");
}
}
doc.Add(table);
doc.Close();
convertToPdf.FncDownLoadPDFFile(FilePath);
}
}
catch (Exception Ex)
{
string Err = Ex.Message.ToString();
}
return(Redirect(Url.Content(ConfigurationManager.AppSettings["WebsiteRootPathAdmin"] + "securehost/rootlogin/client")));
}
public ActionResult ClientExportToCsv(string dfrom, string dto, string kw)
{
try
{
ConvertToCSV objCSV = new ConvertToCSV();
string FilePath = "~/Content/Resources/Reports/csvData.csv";
objCSV.fncDeleteFile(FilePath);
StrataBoardHelper objLedgerHelper = new StrataBoardHelper();
StrataBoardModel objLedgerModel = new StrataBoardModel
{
PageNumber = 1,
PageSize = 100000000
};
objLedgerModel.ExpiredOnFrom = DateTime.Parse(dfrom);
objLedgerModel.ExpiredOnTo = DateTime.Parse(dto);
objLedgerModel.Keyword = kw;
List <StrataBoardModel> listLedgerModel = objLedgerHelper.GetAll(objLedgerModel);
DataTable dt = new DataTable();
dt.Columns.Add("Stratasboard name");
dt.Columns.Add("Unique name");
dt.Columns.Add("Name");
dt.Columns.Add("Email address");
dt.Columns.Add("Contact number");
dt.Columns.Add("Created on");
dt.Columns.Add("Subscription name");
dt.Columns.Add("Validity");
dt.Columns.Add("Expiration date");
dt.Columns.Add("Allowed user");
dt.Columns.Add("IsSmsForAlert");
dt.Columns.Add("IsSmsForReminder");
dt.Columns.Add("Status");
if (listLedgerModel.Count() != 0)
{
foreach (var item in listLedgerModel)
{
DataRow row = dt.NewRow();
row["Stratasboard name"] = item.StratasBoardName;
row["Unique name"] = item.PortalLink;
row["Name"] = item.FirstName + " " + item.LastName;
row["Email address"] = item.EmailId;
row["Contact number"] = item.ContactNumber;
row["Created on"] = AppLogic.GetDateFromatForCsv(Convert.ToDateTime(item.CreatedOn));
row["Subscription name"] = item.SubscriptionName;
row["Validity"] = item.ValidityText;
row["Expiration date"] = AppLogic.GetDateFromatForCsv(Convert.ToDateTime(item.ExpiryDate));
row["Allowed user"] = item.AllowedUser;
row["IsSmsForAlert"] = AppLogic.GetYesNo(item.IsSmsForAlert);
row["IsSmsForReminder"] = AppLogic.GetYesNo(item.IsSmsForReminder);
row["Status"] = AppLogic.GetStatus(item.Status.ToString());
dt.Rows.Add(row);
}
}
if (dt.Rows.Count > 0)
{
objCSV.CreateCSVFile(dt, Server.MapPath("~/Content/Resources/Reports/") + "csvData.csv");
objCSV.FncDownLoadFiles("stratasboard_" + DateTime.Now.ToShortDateString() + ".csv", FilePath);
}
}
catch (Exception Ex)
{
string Err = Ex.Message.ToString();
}
return(Redirect(Url.Content(ConfigurationManager.AppSettings["WebsiteRootPath"] + "securehost/rootlogin/client")));
}
