public ActionResult GetAllClients()
{
try
{
using (var dbcontext = new shreayaaSysEntities())
{
var list = dbcontext.Clients.Select(c => new { Id = c.Id, Name = c.Name }).ToList();
string tempClient = string.Empty;
foreach (var client in list)
{
tempClient += "<div class='col-lg-5 col-lg-offset-1'><div class='client-edit animation animated fadeInDown' data-animation='fadeInDown' data-animation-delay='0s' style='animation-delay: 0s;'><table style='width:100%'><tr style='padding-left:10px;' ><td><span class='fa fa-arrow-right client-listing'></span><span class='clients-txt-overflow' title='" + client.Name + "'>" + client.Name + "</span></td>";
if (User.Identity.IsAuthenticated)
{
tempClient += "<td style='text-align:right'><span class='fa fa-edit data-client-edit' style='cursor:pointer' title='Edit' data-client-name='" + client.Name + "' data-id='" + client.Id + "'></span></td>";
}
tempClient += "</tr></table></div></div>";
}
return(Json(new { result = "success", htmlData = tempClient }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
WriteLogs.Write(ex);
return(Json(new { result = "error" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddUpdateClients(int id, string name)
{
try
{
using (var dbcontext = new shreayaaSysEntities())
{
var client = dbcontext.Clients.Where(cli => cli.Id == id).FirstOrDefault();
if (client != null)
{
client.Name = name;
}
else
{
dbcontext.Clients.Add(new Client {
Id = id, Name = name
});
}
dbcontext.SaveChanges();
return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
WriteLogs.Write(ex);
return(Json(new { result = "error" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddUpdateService(Service s)
{
try
{
using (var dbContext = new shreayaaSysEntities())
{
if (s.Id == 0)
{
dbContext.Services.Add(s);
}
else
{
var serviceObj = dbContext.Services.Where(ss => ss.Id == s.Id).FirstOrDefault();
serviceObj.Name = s.Name;
serviceObj.HtmlContent = s.HtmlContent;
}
dbContext.SaveChanges();
return(Json(new { result = "success", obj = s }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
WriteLogs.Write(ex);
return(Json(new { result = "error" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddUpdateOffer(Offer o)
{
try
{
using (var dbContext = new shreayaaSysEntities())
{
if (o.Id == 0)
{
dbContext.Offers.Add(o);
}
else
{
var serviceObj = dbContext.Offers.Where(oo => oo.Id == o.Id).FirstOrDefault();
serviceObj.Name = o.Name;
serviceObj.StartDate = o.StartDate;
serviceObj.EndDate = o.EndDate;
serviceObj.HtmlContent = o.HtmlContent;
}
dbContext.SaveChanges();
return(Json(new { result = "success", newId = o.Id }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
WriteLogs.Write(ex);
return(Json(new { result = "error" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Services(int?id)
{
using (var dbContext = new shreayaaSysEntities())
{
if (id == null)
{
if (dbContext.Services.Count() > 0)
{
id = dbContext.Services.OrderBy(s => s.Id).FirstOrDefault().Id;
}
}
var obj = dbContext.Services.Where(s => s.Id == id).Select(s =>
new Services
{
Id = s.Id, Name = s.Name, HtmlContent = s.HtmlContent
}).FirstOrDefault();
return(View(obj));
}
}
public ActionResult GetAllServices()
{
try
{
using (var dbContext = new shreayaaSysEntities())
{
var list = dbContext.Services.Select(s =>
new Services
{
Id = s.Id,
Name = s.Name,
}).ToList();
return(Json(new { result = "success", list = list }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
WriteLogs.Write(ex);
return(Json(new { result = "error" }, JsonRequestBehavior.AllowGet));
}
}
public string GetAnOfferDetails(int?id)
{
string tempOffers = string.Empty;
try
{
using (var dbContext = new shreayaaSysEntities())
{
var offersList = dbContext.Offers.Where(o => (id == null ? o.Id != 0 : o.Id == id)).Select(s =>
new
{
Id = s.Id,
Name = s.Name,
StartDate = s.StartDate.Value,
EndDate = s.EndDate.Value,
HtmlContent = s.HtmlContent
}).OrderByDescending(o => o.EndDate).Take(1).ToList();
if (offersList != null)
{
offersList = offersList.Select(o => new
{
Id = o.Id,
Name = o.Name,
StartDate = o.StartDate,
EndDate = o.EndDate,
HtmlContent = o.HtmlContent
}).ToList();
string offerStatus = string.Empty, totalRemainingDays = string.Empty, offerEndsIn = string.Empty, expiryClass = string.Empty;
int remainingDays = 0;
bool offerIsActive = false;
//string offerIsActive = false;
foreach (var offer in offersList)
{
offerIsActive = offer.StartDate < DateTime.Now && DateTime.Now < offer.EndDate;
offerStatus = offerIsActive ? "label-success" : "label-danger";
remainingDays = (offer.EndDate - DateTime.Now).Days;
totalRemainingDays = remainingDays == 1 ? remainingDays + " day" : remainingDays + " days";
offerEndsIn = offerIsActive ? "Ends in " + totalRemainingDays : "Expired";
tempOffers += "<!-- timeline item --> <li><i id='liOfferId' data-id='" + offer.Id + "' class='fa fa-gift bg-blue'></i><div class='timeline-item'><span class='time label label-info ' style='margin-left:5px;'>";
if (User.Identity.IsAuthenticated)
{
tempOffers += "<i class='fa fa-edit' title='Edit' data-offer-id='" + offer.Id + "'></i>";
}
tempOffers += "</span> <span class='time label " + offerStatus + "' title='" + offer.EndDate.ToString("dd-MM-yyyy") + "'><i class='fa fa-clock-o' ></i> " + offerEndsIn + "</span><h3 class='timeline-header' id='divOfferEdit" + offer.Id + "'>" + offer.Name + "</h3><div data-start-date='" + offer.StartDate + "' data-end-date='" + offer.EndDate + "' id='divOffer" + offer.Id + "' class='timeline-body'>" + offer.HtmlContent + "</div>";
if (offerIsActive)
{
tempOffers += "<div class='timeline-footer'><div class=''><table style='margin-right: -120px;;float:right'><tr><td><div class='fb-share-button' data-href='/home/offers/" + offer.Id + "' data-layout='button_count' data-size='large' data-mobile-iframe='true'><a class='fb-xfbml-parse-ignore' target='_blank' href='/home/offers/" + offer.Id + "'>Share</a></div></td><td> <div class='g-plus' data-action='share' data-width='200' data-height='30' data-href='/home/offers/" + offer.Id + "'></div></td></tr></table> </div> </div></div>";
}
tempOffers += "</li>";
}
return(tempOffers);
}
else
{
return(string.Empty);
}
}
}
catch (Exception ex)
{
WriteLogs.Write(ex);
return(string.Empty);
}
}
