public IActionResult Delete(SocialMediaModel m)
{
_applicationDbContext.SocialMedia.Remove(m);
_applicationDbContext.SaveChanges();
return(RedirectToAction("Index"));
}
private MainComponentsModel GetMainComponentsModel(long id)
{
try
{
MainComponentsModel mainComponents = new MainComponentsModel();
Main main = db.Mains.Where(x => x.id == id).SingleOrDefault();
if (main != null)
{
mainComponents.hoverColor = main.hoverColor;
mainComponents.logo = main.logo;
mainComponents.textColor = main.textColor;
mainComponents.title = main.title;
mainComponents.titleColor = main.titleColor;
List <SocialMediaLink> socialMediaLinks = db.SocialMediaLinks.Where(x => x.userID == id).ToList();
if (socialMediaLinks != null)
{
List <SocialMediaModel> socialMediaModels = new List <SocialMediaModel>();
foreach (SocialMediaLink socialMediaLink in socialMediaLinks)
{
SocialMediaModel socialMediaModel = new SocialMediaModel();
socialMediaModel.socialMedia = db.SocialMedias.Where(x => x.id == socialMediaLink.socialMedia).SingleOrDefault().code;
socialMediaModel.link = socialMediaLink.link;
socialMediaModels.Add(socialMediaModel);
}
mainComponents.socialMediaList = socialMediaModels;
}
}
return(mainComponents);
}
catch (Exception e)
{
Console.WriteLine(e);
return(null);
}
}
public ActionResult EditSocial(int socialMediaId)
{
CommonDataService cds = new CommonDataService();
CommonModel cm = new CommonModel();
cm = cds.GenerateCommonModel();
Session["FaceBook"] = cm.FaceBook;
Session["Twitter"] = cm.Twitter;
Session["Youtube"] = cm.Youtube;
Session["Instagram"] = cm.Instagram;
Session["PhoneNumber"] = cm.PhoneNumber;
Session["Email"] = cm.Email;
Session["ShoppingHours"] = cm.ShoppingHours;
try
{
ContactDataService dataService = new ContactDataService();
SocialMediaModel model = new SocialMediaModel();
model = dataService.GenerateSocialMediaModelById(socialMediaId);
return(View(model));
}
catch (Exception ex)
{
throw ex;
}
}
public static SocialMediaModel MergeViewWithModelSocialMedia(SocialMediaModel model, SocialMediaView view)
{
model.Link = view.Link;
model.Name = view.Name;
model.FontAwesome = view.FontAwesome;
return(model);
}
public ActionResult Edit(SocialMediaModel model)
{
model.LoginID = User.Identity.GetUserId();
IDBConnector db = DBConnectorFactory.GetDBConnector();
db.UpdateSocialMedia(model);
return(RedirectToAction("Edit", "Profile"));
}
public ActionResult Edit(int id)
{
IDBConnector db = DBConnectorFactory.GetDBConnector();
SocialMediaModel model = db.SelectSocialMedia(id);
ViewBag.SocialMediaOptions = DropDownGenerator.GetSocialMediaDropDown(model.SocialMediaID);
return(View(model));
}
/// <summary>
/// Load ViewModel items asynchronous
/// </summary>
public async Task LoadDataAsync(bool forceRefresh = false)
{
var loadTasks = new Task[]
{
FastAccessModel.LoadItemsAsync(forceRefresh),
SocialMediaModel.LoadItemsAsync(forceRefresh),
VAWHotlinesModel.LoadItemsAsync(forceRefresh),
};
await Task.WhenAll(loadTasks);
}
public static SocialMediaModel ConvertToModelSocialMedia(SocialMediaView result)
{
var socialMediaModel = new SocialMediaModel
{
Name = result.Name,
Link = result.Link,
FontAwesome = result.FontAwesome
};
return(socialMediaModel);
}
public static SocialMediaView ConvertToViewSocialMedia(SocialMediaModel result)
{
var socialMediaView = new SocialMediaView
{
Id = result.Id,
Name = result.Name,
Link = result.Link,
FontAwesome = result.FontAwesome
};
return(socialMediaView);
}
public void UpdateSocialMedia(SocialMediaModel socialMedia)
{
List <SocialMediaModel> accounts = new List <SocialMediaModel>()
{
socialMedia
};
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(connectionString))
{
connection.Execute("WebsiteData.spSocialMedia_Update @UserSocialMediaID, @SocialMediaID, @Address, @AlternateText", accounts);
}
}
public ActionResult EditSocial(SocialMediaModel model)
{
CommonDataService cds = new CommonDataService();
CommonModel cm = new CommonModel();
cm = cds.GenerateCommonModel();
Session["FaceBook"] = cm.FaceBook;
Session["Twitter"] = cm.Twitter;
Session["Youtube"] = cm.Youtube;
Session["Instagram"] = cm.Instagram;
Session["PhoneNumber"] = cm.PhoneNumber;
Session["Email"] = cm.Email;
Session["ShoppingHours"] = cm.ShoppingHours;
ContactDataService dataService = new ContactDataService();
try
{
string id = (string)Request.Form["id"];
if (ModelState.IsValid)
{
dataService.UpdateSocialMedia(int.Parse(id), model.SocialMediaUrl);
return(RedirectToAction("Edit", "Contact"));
}
else
{
model = new SocialMediaModel();
model.SocialMediaId = int.Parse(id);
model.SocialMediaUrl = model.SocialMediaUrl;
return(View(model));
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dataService = null;
}
}
public SocialMediaModel GenerateSocialMediaModelById(int id)
{
try
{
SocialMediaModel model = new SocialMediaModel();
using (VenturadaDataContext vdc = new VenturadaDataContext())
{
var table = from p in vdc.SocialMedias.ToList()
where p.SocialMediaId == id
select p;
model = new SocialMediaModel();
model.SocialMediaId = table.FirstOrDefault().SocialMediaId;
model.SocialMediaType = table.FirstOrDefault().SocialMediaType;
model.SocialMediaUrl = table.FirstOrDefault().SocialMediaUrl;
return(model);
}
}
catch (Exception ex)
{
throw ex;
}
}
public IActionResult Delete(long Id)
{
SocialMediaModel prdtct = _applicationDbContext.SocialMedia.FirstOrDefault(o => o.Id == Id);
return(View(prdtct));
}
public async Task <bool> UpdateSocialMedia(SocialMediaModel socialMedia)
{
_context.SocialMedias.Update(socialMedia);
return(await _context.SaveChangesAsync() > 0);
}
public async Task <bool> CreateSocialMedia(SocialMediaModel socialMedia)
{
await _context.SocialMedias.AddAsync(socialMedia);
return(await _context.SaveChangesAsync() > 0);
}
public ActionResult Delete(SocialMediaModel model)
{
return(View(model));
}
