public ActionResult Delete(Int32 AdsBannerId)
{
try
{
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
var AdsBannerIdPara = new SqlParameter("@adsbannerid", AdsBannerId);
AdsBanner obj_AdsBanner = context.Database.SqlQuery <AdsBanner>("sp_AdsBanner_select @adsbannerid", AdsBannerIdPara).FirstOrDefault();
obj_AdsBanner.IsDeleted = true;
context.Entry(obj_AdsBanner).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
var adsbannerSequenceidPara = new SqlParameter("@adsbannerid", obj_AdsBanner.AdsBannerID);
context.Database.ExecuteSqlCommand("sp_AdsBanner_delete @adsbannerid", AdsBannerIdPara);
TempData["AdsBannerSuccess"] = "Record has been deleted successfully.";
return(RedirectToAction("Index"));
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
TempData["AdsBannerError"] = ex.Message;
}
return(RedirectToAction("Index"));
}
}
private void cleanup()
{
if (m_adsBannerGameBottom != null)
{
Destroy(m_adsBannerGameBottom);
m_adsBannerGameBottom = null;
}
}
public override void Initialize()
{
m_adsBannerGameBottom = null;
//Debug.LogError(SceneManager.GetActiveScene().name);
SceneManager.sceneLoaded += loadedScene;
Debug.LogError("AdsManager.Initialize");
m_skitRoot.OnSkitStarted.AddListener(OnSkitStarted);
m_skitRoot.OnSkitFinished.AddListener(OnSkitFinished);
}
public ActionResult Edit(AdsBanner Obj_AdsBanner, HttpPostedFileBase AdsBannerImage)
{
try
{
string AdsBannerName = string.Empty;
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
var AdsBannerNamePara = new SqlParameter("@adsbannername", Obj_AdsBanner.AdsBannerName);
var AdsBannerVendorIdPara = new SqlParameter("@vendorid", Obj_AdsBanner.VendorID);
var AdsBannerIdPara = new SqlParameter("@adsbannerid", Obj_AdsBanner.AdsBannerID);
var result = context.Database.SqlQuery <AdsBanner>("sp_AdsBanner_CheckVendorExistsUpdate @adsbannername,@vendorid,@adsbannerid", AdsBannerNamePara, AdsBannerVendorIdPara, AdsBannerIdPara).ToList();
if (result.Count > 0)
{
ViewBag.AdsBannerExists = "Banner name is already exists.";
GetCateory();
GetVendor();
GetPosition();
return(View(Obj_AdsBanner));
}
else
{
var AdsGetBannerIdPara = new SqlParameter("@adsbannerid", Obj_AdsBanner.AdsBannerID);
AdsBanner obj_AdsBanners = context.Database.SqlQuery <AdsBanner>("sp_AdsBanner_select @adsbannerid", AdsGetBannerIdPara).FirstOrDefault();
if (SessionUtilities.SaveImage(AdsBannerImage, "AdsBanner", Obj_AdsBanner.AdsBannerName.Trim()))
{
AdsBannerName = Path.GetFileName(AdsBannerImage.FileName);
Obj_AdsBanner.AdsBannerImage = AdsBannerName;
}
else
{
Obj_AdsBanner.AdsBannerImage = obj_AdsBanners.AdsBannerImage;
}
var adsbannerSequenceidPara = new SqlParameter("@adsbannerid", Obj_AdsBanner.AdsBannerID);
var adsbannerSequencePara = new SqlParameter("@priority", Obj_AdsBanner.Priority);
context.Database.ExecuteSqlCommand("sp_AdsBanner_updateSequenceEdit @priority,@adsbannerid", adsbannerSequencePara, adsbannerSequenceidPara);
context.AdsBanners.Attach(Obj_AdsBanner);
context.Entry(Obj_AdsBanner).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
TempData["AdsBannerSuccess"] = "Record has been update successfully.";
return(RedirectToAction("Index"));
}
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
ViewBag.AdsBannerExists = ex.Message;
}
return(View(Obj_AdsBanner));
}
}
public ActionResult Create(AdsBanner Obj_AdsBanner, string command, HttpPostedFileBase AdsBannerImage)
{
try
{
string AdsBannerName = string.Empty;
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
var AdsBannerNamePara = new SqlParameter("@adsbannername", Obj_AdsBanner.AdsBannerName);
var AdsBannerVendorIdPara = new SqlParameter("@vendorid", Obj_AdsBanner.VendorID);
var result = context.Database.SqlQuery <AdsBanner>("sp_AdsBanner_CheckAdminExists @adsbannername,@vendorid", AdsBannerNamePara, AdsBannerVendorIdPara).ToList();
if (result.Count > 0)
{
ViewBag.AdsBannerExists = "Banner name is already exists.";
GetCateory();
GetVendor();
GetPosition();
return(View(Obj_AdsBanner));
}
else
{
GetCateory();
GetVendor();
GetPosition();
if (SessionUtilities.SaveImage(AdsBannerImage, "AdsBanner", Obj_AdsBanner.AdsBannerName.Trim()))
{
AdsBannerName = Path.GetFileName(AdsBannerImage.FileName);
Obj_AdsBanner.AdsBannerImage = AdsBannerName;
}
Obj_AdsBanner.CreateAt = System.DateTime.Now;
Obj_AdsBanner.IsDeleted = false;
context.AdsBanners.Add(Obj_AdsBanner);
context.SaveChanges();
var adsBannersequenceIdpara = new SqlParameter("@adsbannerid", Obj_AdsBanner.AdsBannerID);
context.Database.ExecuteSqlCommand("sp_AdsBanner_UpdateSequence @adsbannerid", adsBannersequenceIdpara);
TempData["AdsBannerSuccess"] = "Record has been added successfully.";
return(RedirectToAction("Index"));
}
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
ViewBag.AdsBannerExists = ex.Message;
}
return(View(Obj_AdsBanner));
}
}
private void setup(string _strSceneName)
{
cleanup();
switch (_strSceneName)
{
case "Command":
if (m_adsBannerGameBottom == null)
{
m_adsBannerGameBottom = gameObject.AddComponent <AdsBanner>();
}
break;
default:
break;
}
}
public ActionResult Edit(Int32?AdsBannerId)
{
try
{
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
var AdsBannerIdPara = new SqlParameter("@adsbannerid", AdsBannerId);
AdsBanner obj_AdsBanner = context.Database.SqlQuery <AdsBanner>("sp_AdsBanner_select @adsbannerid", AdsBannerIdPara).FirstOrDefault();
GetCateoryVendor();
return(View(obj_AdsBanner));
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
ViewBag.AdsBannerExists = ex.Message;
}
return(View(new AdsBanner()));
}
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "alpha" || e.CommandName == "NoFilter")
{
String value = null;
switch (e.CommandName)
{
case ("alpha"):
{
value = string.Format("{0}%", e.CommandArgument);
break;
}
case ("NoFilter"):
{
value = "%";
break;
}
}
ObjectDataSource1.SelectParameters["CompanyName"].DefaultValue = value;
ObjectDataSource1.DataBind();
RadGrid1.Rebind();
}
else if (e.CommandName == "QuickUpdate")
{
string AdsBannerID, Priority, IsAvailable;
var oAdsBanner = new AdsBanner();
foreach (GridDataItem item in RadGrid1.Items)
{
AdsBannerID = item.GetDataKeyValue("AdsBannerID").ToString();
Priority = ((RadNumericTextBox)item.FindControl("txtPriority")).Text.Trim();
IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString();
oAdsBanner.AdsBannerQuickUpdate(
AdsBannerID,
Priority,
IsAvailable
);
}
}
else if (e.CommandName == "DeleteSelected")
{
var oAdsBanner = new AdsBanner();
foreach (GridDataItem item in RadGrid1.SelectedItems)
{
string strFileName = ((HiddenField)item.FindControl("hdnFileName")).Value;
if (!string.IsNullOrEmpty(strFileName))
{
string strSavePath = Server.MapPath("~/res/advertisement/" + strFileName);
if (File.Exists(strSavePath))
{
File.Delete(strSavePath);
}
}
}
}
else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
{
var command = e.CommandName;
var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
var FileFileName = (RadUpload)row.FindControl("FileFileName");
var dpFromDate = (RadDatePicker)row.FindControl("dpFromDate");
var dpToDate = (RadDatePicker)row.FindControl("dpToDate");
string strCompanyName = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtCompanyName")).Content.Trim()));//((TextBox)row.FindControl("txtCompanyName")).Text.Trim();
//string strTitle = ((TextBox)row.FindControl("txtTitle")).Text.Trim();
//string strDescription = ((TextBox)row.FindControl("txtDescription")).Text.Trim();
string strConvertedAdsBannerName = Common.ConvertTitle(strCompanyName);
string strFileName = FileFileName.UploadedFiles.Count > 0 ? FileFileName.UploadedFiles[0].GetName() : "";
string strIsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString();
string strPriority = ((RadNumericTextBox)row.FindControl("txtPriority")).Text.Trim();
string strFromDate = dpFromDate.SelectedDate.HasValue ? dpFromDate.SelectedDate.Value.ToString("MM/dd/yyyy") : "";
string strToDate = dpToDate.SelectedDate.HasValue ? dpToDate.SelectedDate.Value.ToString("MM/dd/yyyy") : "";
string strAdsCategoryID = "10";// ((RadComboBox)row.FindControl("ddlCategory")).SelectedValue;
string strWebsite = ((TextBox)row.FindControl("txtWebsite")).Text.Trim();
double ratio = 0;
if (!string.IsNullOrEmpty(strFileName))
{
string strTempPath = Server.MapPath(FileFileName.TargetFolder + strFileName);
if (IsImageFormat(strFileName))
{
System.Drawing.Image img = System.Drawing.Image.FromFile(strTempPath);
ratio = (double)img.Width / (img.Height == 0 ? 1 : img.Height);
img.Dispose();
}
else
{
SwfParser swfParser = new SwfParser();
Rectangle rectangle = swfParser.GetDimensions(strTempPath);
ratio = (double)rectangle.Width / (rectangle.Height == 0 ? 1 : rectangle.Height);
}
string[] files = Directory.GetFiles(Server.MapPath(FileFileName.TargetFolder));
foreach (string filePath in files)
{
File.Delete(filePath);
}
}
var oAdsBanner = new AdsBanner();
if (e.CommandName == "PerformInsert")
{
strFileName = oAdsBanner.AdsBannerInsert(
strFileName,
strConvertedAdsBannerName,
strAdsCategoryID,
strCompanyName,
strWebsite,
strFromDate,
strToDate,
strPriority,
strIsAvailable,
ratio == 0 ? "" : ratio.ToString().Replace(',', '.')
);
string strFullPath = "~/res/advertisement/" + strFileName;
if (!string.IsNullOrEmpty(strFileName))
{
FileFileName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
if (IsImageFormat(strFileName))
{
//ResizeCropImage.ResizeByCondition(strFullPath, 800, 800);
}
}
RadGrid1.Rebind();
}
else
{
var dsUpdateParam = ObjectDataSource1.UpdateParameters;
var strAdsBannerID = row.GetDataKeyValue("AdsBannerID").ToString();
var strOldFileName = ((HiddenField)row.FindControl("hdnFileName")).Value;
var strOldImagePath = Server.MapPath("~/res/advertisement/" + strOldFileName);
dsUpdateParam["FileName"].DefaultValue = strFileName;
dsUpdateParam["ConvertedAdsBannerName"].DefaultValue = strConvertedAdsBannerName;
dsUpdateParam["AdsCategoryID"].DefaultValue = strAdsCategoryID;
dsUpdateParam["FromDate"].DefaultValue = strFromDate;
dsUpdateParam["ToDate"].DefaultValue = strToDate;
dsUpdateParam["IsAvailable"].DefaultValue = strIsAvailable;
dsUpdateParam["Ratio"].DefaultValue = ratio == 0 ? "" : ratio.ToString().Replace(',', '.');
if (!string.IsNullOrEmpty(strFileName))
{
var strFullPath = "~/res/advertisement/" + (string.IsNullOrEmpty(strConvertedAdsBannerName) ? "" : strConvertedAdsBannerName + "-") + strAdsBannerID + strFileName.Substring(strFileName.LastIndexOf('.'));
if (File.Exists(strOldImagePath))
{
File.Delete(strOldImagePath);
}
FileFileName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
if (IsImageFormat(strFileName))
{
//ResizeCropImage.ResizeByCondition(strFullPath, 654, 654);
}
}
}
}
if (e.CommandName == "DeleteImage")
{
var oAdsBanner = new AdsBanner();
var lnkDeleteImage = (LinkButton)e.CommandSource;
var s = lnkDeleteImage.Attributes["rel"].ToString().Split('#');
var strAdsBannerID = s[0];
var strFileName = s[1];
oAdsBanner.AdsBannerDelete(strAdsBannerID);
DeleteImage(strFileName);
RadGrid1.Rebind();
}
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "alpha" || e.CommandName == "NoFilter")
{
String value = null;
switch (e.CommandName)
{
case ("alpha"):
{
value = string.Format("{0}%", e.CommandArgument);
break;
}
case ("NoFilter"):
{
value = "%";
break;
}
}
ObjectDataSource1.SelectParameters["CompanyName"].DefaultValue = value;
ObjectDataSource1.DataBind();
RadGrid1.Rebind();
}
else if (e.CommandName == "QuickUpdate")
{
string AdsBannerID, Priority, IsAvailable;
var oAdsBanner = new AdsBanner();
foreach (GridDataItem item in RadGrid1.Items)
{
AdsBannerID = item.GetDataKeyValue("AdsBannerID").ToString();
Priority = ((RadNumericTextBox)item.FindControl("txtPriority")).Text.Trim();
IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString();
oAdsBanner.AdsBannerQuickUpdate(
AdsBannerID,
Priority,
IsAvailable
);
}
}
else if (e.CommandName == "DeleteSelected")
{
var oAdsBanner = new AdsBanner();
foreach (GridDataItem item in RadGrid1.SelectedItems)
{
string strFileName = ((HiddenField)item.FindControl("hdnFileName")).Value;
if (!string.IsNullOrEmpty(strFileName))
{
string strSavePath = Server.MapPath("~/res/advertisement/" + strFileName);
if (File.Exists(strSavePath))
File.Delete(strSavePath);
}
}
}
else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
{
var command = e.CommandName;
var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
var FileFileName = (RadUpload)row.FindControl("FileFileName");
var dpFromDate = (RadDatePicker)row.FindControl("dpFromDate");
var dpToDate = (RadDatePicker)row.FindControl("dpToDate");
string strCompanyName = ((TextBox)row.FindControl("txtCompanyName")).Text.Trim();
string strConvertedAdsBannerName = Common.ConvertTitle(strCompanyName);
string strFileName = FileFileName.UploadedFiles.Count > 0 ? FileFileName.UploadedFiles[0].GetName() : "";
string strIsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString();
string strPriority = ((RadNumericTextBox)row.FindControl("txtPriority")).Text.Trim();
string strFromDate = dpFromDate.SelectedDate.HasValue ? dpFromDate.SelectedDate.Value.ToString("MM/dd/yyyy") : "";
string strToDate = dpToDate.SelectedDate.HasValue ? dpToDate.SelectedDate.Value.ToString("MM/dd/yyyy") : "";
string strAdsCategoryID = "5";//((RadComboBox)row.FindControl("ddlCategory")).SelectedValue;
string strWebsite = ((TextBox)row.FindControl("txtWebsite")).Text.Trim();
double ratio = 0;
if (!string.IsNullOrEmpty(strFileName))
{
string strTempPath = Server.MapPath(FileFileName.TargetFolder + strFileName);
if (IsImageFormat(strFileName))
{
System.Drawing.Image img = System.Drawing.Image.FromFile(strTempPath);
ratio = (double)img.Width / (img.Height == 0 ? 1 : img.Height);
img.Dispose();
}
else
{
SwfParser swfParser = new SwfParser();
Rectangle rectangle = swfParser.GetDimensions(strTempPath);
ratio = (double)rectangle.Width / (rectangle.Height == 0 ? 1 : rectangle.Height);
}
string[] files = Directory.GetFiles(Server.MapPath(FileFileName.TargetFolder));
foreach (string filePath in files)
File.Delete(filePath);
}
var oAdsBanner = new AdsBanner();
if (e.CommandName == "PerformInsert")
{
strFileName = oAdsBanner.AdsBannerInsert(
strFileName,
strConvertedAdsBannerName,
strAdsCategoryID,
strCompanyName,
strWebsite,
strFromDate,
strToDate,
strPriority,
strIsAvailable,
ratio == 0 ? "" : ratio.ToString().Replace(',', '.')
);
string strFullPath = "~/res/advertisement/" + strFileName;
if (!string.IsNullOrEmpty(strFileName))
{
FileFileName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
if (IsImageFormat(strFileName))
{
//ResizeCropImage.ResizeByCondition(strFullPath, 935, 420);
}
}
RadGrid1.Rebind();
}
else
{
var dsUpdateParam = ObjectDataSource1.UpdateParameters;
var strAdsBannerID = row.GetDataKeyValue("AdsBannerID").ToString();
var strOldFileName = ((HiddenField)row.FindControl("hdnFileName")).Value;
var strOldImagePath = Server.MapPath("~/res/advertisement/" + strOldFileName);
dsUpdateParam["FileName"].DefaultValue = strFileName;
dsUpdateParam["ConvertedAdsBannerName"].DefaultValue = strConvertedAdsBannerName;
dsUpdateParam["AdsCategoryID"].DefaultValue = strAdsCategoryID;
dsUpdateParam["FromDate"].DefaultValue = strFromDate;
dsUpdateParam["ToDate"].DefaultValue = strToDate;
dsUpdateParam["IsAvailable"].DefaultValue = strIsAvailable;
dsUpdateParam["Ratio"].DefaultValue = ratio == 0 ? "" : ratio.ToString().Replace(',', '.');
if (!string.IsNullOrEmpty(strFileName))
{
var strFullPath = "~/res/advertisement/" + (string.IsNullOrEmpty(strConvertedAdsBannerName) ? "" : strConvertedAdsBannerName + "-") + strAdsBannerID + strFileName.Substring(strFileName.LastIndexOf('.'));
if (File.Exists(strOldImagePath))
File.Delete(strOldImagePath);
FileFileName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
if (IsImageFormat(strFileName))
{
//ResizeCropImage.ResizeByCondition(strFullPath, 935, 420);
}
}
}
}
if (e.CommandName == "DeleteImage")
{
var oAdsBanner = new AdsBanner();
var lnkDeleteImage = (LinkButton)e.CommandSource;
var s = lnkDeleteImage.Attributes["rel"].ToString().Split('#');
var strAdsBannerID = s[0];
var strFileName = s[1];
oAdsBanner.AdsBannerDelete(strAdsBannerID);
DeleteImage(strFileName);
RadGrid1.Rebind();
}
}
public override void OnEnter()
{
base.OnEnter();
banner = Owner.GetComponent <AdsBanner>();
}
