public async Task <ManageBannersModel> GetBannerById(Guid BannerId)
{
var Banner = new ManageBannersModel();
SqlParameter Ban = new SqlParameter("@BannerId", ToDBNull(BannerId));
using (var connection = _context.Database.Connection)
{
connection.Open();
var command = connection.CreateCommand();
command.CommandText = "USPGetBannersById";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(Ban);
using (var reader = await command.ExecuteReaderAsync())
{
Banner =
((IObjectContextAdapter)_context)
.ObjectContext
.Translate <ManageBannersModel>(reader)
.SingleOrDefault();
reader.NextResult();
Banner.ImgDetails = ((IObjectContextAdapter)_context)
.ObjectContext
.Translate <ManageBannerUploadModel>(reader)
.ToList();
}
}
return(Banner);
}
public async Task <ResponseModel> AddUpdateBanner(ManageBannersModel Banner)
{
string xml = "";
if (Banner.ImgDetails != null)
{
XmlSerializer ImgDetails = new XmlSerializer(Banner.ImgDetails.GetType());
using (var sww = new StringWriter())
{
using (XmlWriter writer = XmlWriter.Create(sww))
{
ImgDetails.Serialize(writer, Banner.ImgDetails);
xml = sww.ToString();
}
}
xml = xml.Replace("<?xml version=\"1.0\" encoding=\"utf-16\"?>", "");
}
List <SqlParameter> sp = new List <SqlParameter>();
SqlParameter param = new SqlParameter("@BannerId", ToDBNull(Banner.BannerId));
sp.Add(param);
param = new SqlParameter("@CompId", ToDBNull(Banner.CompanyId));
sp.Add(param);
param = new SqlParameter("@Title", ToDBNull(Banner.Title));
sp.Add(param);
param = new SqlParameter("@Name", ToDBNull(Banner.Name));
sp.Add(param);
param = new SqlParameter("@Extra1", ToDBNull(Banner.Extra1));
sp.Add(param);
param = new SqlParameter("@Extra2", ToDBNull(Banner.Extra2));
sp.Add(param);
param = new SqlParameter("@PageId", ToDBNull(Banner.PageId));
sp.Add(param);
param = new SqlParameter("@SectionId", ToDBNull(Banner.SectionId));
sp.Add(param);
param = new SqlParameter("@IsActive", (object)(Banner.IsActive));
sp.Add(param);
param = new SqlParameter("@User", ToDBNull(Banner.UserId));
sp.Add(param);
param = new SqlParameter("@ImgUpload", ToDBNull(xml));
param.SqlDbType = SqlDbType.Xml;
sp.Add(param);
param = new SqlParameter("@Action", (object)Banner.EventAction);
sp.Add(param);
var sql = "USPInsertUpdateBanners @BannerId,@CompId,@Title,@Name,@Extra1,@Extra2,@PageId,@SectionId,@IsActive,@User,@ImgUpload,@Action";
var res = await _context.Database.SqlQuery <ResponseModel>(sql, sp.ToArray()).SingleOrDefaultAsync();
if (res.ResponseCode == 0)
{
res.IsSuccess = true;
}
else
{
res.IsSuccess = false;
}
return(res);
}
public async Task <ActionResult> Create()
{
var filter = new FilterModel {
CompId = CurrentUser.CompanyId
};
var Banner = new ManageBannersModel();
Banner.ImgDetails = new List <ManageBannerUploadModel>();
Banner.PageNameList = new SelectList(await CommonModel.GetLookup("Page"), "Value", "Text");
Banner.SectionNameList = new SelectList(Enumerable.Empty <SelectList>());
return(View(Banner));
}
public async Task <ActionResult> Create(ManageBannersModel Banner)
{
var ImageDetail = Request.Params["ImgDetail"];
Banner = JsonConvert.DeserializeObject <ManageBannersModel>(ImageDetail);
int i = 0;
string directory = "~/TempFiles/Banners/" + Banner.Name;
string path = Server.MapPath(directory);
foreach (var ban in Banner.ImgDetails)
{
ban.BannerFile = Request.Files["SlideImg" + i];
if (ban.BannerFile != null)
{
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
if (ban.BannerFile != null)
{
ban.BannerFileName = "SlideImg" + i + Path.GetExtension(Path.Combine(directory, ban.BannerFile.FileName));
}
if (System.IO.File.Exists(path + "/" + ban.BannerFileName))
{
System.IO.File.Delete(path + "/" + ban.BannerFileName);
}
ban.BannerFile.SaveAs(path + "/" + ban.BannerFileName);
ban.BannerFile = null;
}
i++;
}
Banner.UserId = CurrentUser.UserId;
Banner.CompanyId = CurrentUser.CompanyId;
ResponseModel response = new ResponseModel();
if (Banner.BannerId == null)
{
Banner.EventAction = 'I';
response = await _Banner.AddUpdateBanner(Banner);
}
else
{
Banner.EventAction = 'U';
response = await _Banner.AddUpdateBanner(Banner);
}
return(Json("Ok", JsonRequestBehavior.AllowGet));
}
