public void DeleteSlider(int id)
{
slider s = db.sliders.Find(id);
db.sliders.Remove(s);
db.SaveChanges();
}
public ActionResult Edit(HttpPostedFileBase doc, slider slider)
{
if (ModelState.IsValid)
{
slider slider_update = db.sliders.Find(slider.Slider_Id);
slider_update.Slider_Title = slider.Slider_Title;
slider_update.Slider_Status = slider.Slider_Status;
if (doc != null)
{
var filename = Path.GetFileName(doc.FileName);
var extension = Path.GetExtension(filename).ToLower();
if (extension == ".jpg" || extension == ".png")
{
var path = HostingEnvironment.MapPath(Path.Combine("~/Content/Images/", filename));
doc.SaveAs(path);
slider_update.Slider_Image = "~/Content/Images/" + filename;
}
}
slider_update.Slider_Date = DateTime.Now;
db.Entry(slider_update).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(slider));
}
public ActionResult Edit([Bind(Include = "Sliderid,Name,Description,Image,url,date")] slider slider, HttpPostedFileBase file, Helper Help)
{
if (ModelState.IsValid)
{
slider.date = System.DateTime.Now;
slider.Image = file != null?Help.uploadfile(file) : img;
#region delete file
string fullPath = Request.MapPath("~/UploadedFiles/" + img);
if (img == slider.Image)
{
}
else
{
if (System.IO.File.Exists(fullPath))
{
System.IO.File.Delete(fullPath);
}
}
#endregion
db.Entry(slider).State = EntityState.Modified;
db.SaveChanges();
TempData["Success"] = "Updated Successfully";
return(RedirectToAction("Index"));
}
return(View(slider));
}
public void SliderGuncelleDb(slider gelen, HttpPostedFileBase sliderResim, string yol)
{
string resimIsmi = "";
if (sliderResim != null && sliderResim.ContentLength > 0)
{
resimIsmi = DateTime.Now.ToString("dd/MM/yyyy hh/mm/ss") + sliderResim.FileName;
var path = Path.Combine(yol, resimIsmi);
sliderResim.SaveAs(path);
SqlConnection baglan = new SqlConnection("Server=DESKTOP-6GBHM2T\\SQLEXPRESS;Database=Insaat;Integrated Security=true;");
baglan.Open();
SqlCommand komut = new SqlCommand("update slider set baslik=@baslik,aciklama=@aciklama,resim=@resim where id=" + gelen.id, baglan);
komut.Parameters.Add("@baslik", SqlDbType.Text).Value = gelen.baslik;
komut.Parameters.Add("@aciklama", SqlDbType.Text).Value = gelen.aciklama;
komut.Parameters.Add("@resim", SqlDbType.Text).Value = resimIsmi;
komut.ExecuteNonQuery();
}
else
{
SqlConnection baglan = new SqlConnection("Server=DESKTOP-6GBHM2T\\SQLEXPRESS;Database=Insaat;Integrated Security=true;");
baglan.Open();
SqlCommand komut = new SqlCommand("update slider set baslik=@baslik,aciklama=@aciklama where id=" + gelen.id, baglan);
komut.Parameters.Add("@baslik", SqlDbType.Text).Value = gelen.baslik;
komut.Parameters.Add("@aciklama", SqlDbType.Text).Value = gelen.aciklama;
komut.Parameters.Add("@resim", SqlDbType.Text).Value = resimIsmi;
komut.ExecuteNonQuery();
}
}
public async Task <ActionResult> Edit([Bind(Include = "id,Name,Description,Image")] slider slider, HttpPostedFileBase file, Helper Help)
{
if (ModelState.IsValid)
{
slider.Image = file != null?Help.uploadfile(file) : img;
#region delete file
string fullPath = Request.MapPath("~/UploadedFiles/" + img);
if (img == slider.Image)
{
}
else
{
if (System.IO.File.Exists(fullPath))
{
System.IO.File.Delete(fullPath);
}
}
#endregion
db.Entry(slider).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(slider));
}
public override void Awake()
{
base.Awake();
signal = GetComponent <reverbSignalGenerator>();
level = GetComponentInChildren <dial>();
reverbControl = GetComponentInChildren <slider>();
}
protected void ListView1_ItemCommand(object sender, ListViewCommandEventArgs e)
{
Label IdLabel = e.Item.FindControl("IdLabel") as Label;
int id = Convert.ToInt32(IdLabel.Text);
if (e.CommandName == "sil")
{
slider ur = slider.Select(id);
if (ur == null)
{
Labelbilgi.Text = "<p class='msg error'><b>KAYIT BULUNAMADI !</b></p>";
return;
}
Result <int> sonuc = ur.Delete();
if (sonuc.HasError)
{
Labelbilgi.Text = "<p class='msg error'><b>Hata :" + sonuc.CustomErrorMessage + "</b></p>";
return;
}
else
{
Labelbilgi.Text = "<p class='msg done'><b>BAŞARIYLA SİLİNDİ...</b></p>";
AccessDataSource1.Select(DataSourceSelectArguments.Empty);
ListView1.DataBind();
}
}
else if (e.CommandName == "duzenle")
{
Response.Redirect("baner-duzenle.aspx?Id=" + id.ToString());
}
}
public ActionResult DeleteConfirmed(int id)
{
slider slider = db.sliders.Find(id);
db.sliders.Remove(slider);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
slider slider = db.sliders.Find(id);
db.sliders.Remove(slider);
db.SaveChanges();
TempData["Success"] = "Deleted Successfully";
return(RedirectToAction("Index"));
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
slider slider = await db.sliders.FindAsync(id);
db.sliders.Remove(slider);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ResponseStatus> addbanner(sliderRequest sliderRequest)
{
ResponseStatus status = new ResponseStatus();
try
{
if (sliderRequest.id == "0")
{
var guid = Guid.NewGuid();
slider slider = new slider
{
id = guid.ToString(),
code = sliderRequest.code,
deleted = false,
active = true,
fromdate = sliderRequest.fromdate,
todate = sliderRequest.todate,
orderno = sliderRequest.orderno,
createAt = DateTime.Now
};
// memoryCache.Remove("bannerlist");
appDbContex.Sliders.Add(slider);
await appDbContex.SaveChangesAsync();
status.objItem = guid.ToString();
status.status = true;
status.message = "Banner details save successfully.";
return(status);
}
else
{
var slider = appDbContex.Sliders.Where(a => a.id == sliderRequest.id).FirstOrDefault();
if (slider != null)
{
slider.code = sliderRequest.code;
slider.fromdate = sliderRequest.fromdate;
slider.todate = sliderRequest.todate;
slider.orderno = sliderRequest.orderno;
slider.updateAt = DateTime.Now;
}
// memoryCache.Remove("bannerlist");
//appDbContex.Update(slider);
await appDbContex.SaveChangesAsync();
status.status = true;
status.objItem = sliderRequest.id;
status.message = "Banner details updated successfully";
return(status);
}
// return status;
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult SliderGuncelle(int id)
{
if (Session["kullaniciAdi"] == null)
{
return(RedirectToAction("Giris", "Login"));
}
slider slidercik = sliderRepository.idyegorecek(id);
return(View(slidercik));
}
public ActionResult Edit([Bind(Include = "Id,Name,Images,Code,Status")] slider slider)
{
if (ModelState.IsValid)
{
db.Entry(slider).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(slider));
}
public ActionResult index()
{
IndexViewModel model = new IndexViewModel();
slider model2 = new slider();
calisartikContext db = new calisartikContext();
model.SonEklenenler = db.icerikler.OrderByDescending(w => w.OlusturmaTarihi).Take(5).ToList();
model.icerikID = db.icerikler.OrderByDescending(w => w.OlusturmaTarihi).Take(5).ToList();
return(View(model));
}
public ActionResult SliderEkleDb(slider gelen, HttpPostedFileBase sliderResim)
{
if (Session["kullaniciAdi"] == null)
{
return(RedirectToAction("Giris", "Login"));
}
string yol = Server.MapPath("~/resimler/slider/");
sliderRepository.SliderEkleDb(gelen, sliderResim, yol);
return(RedirectToAction("SliderListele"));
}
public void SliderSirala(string[] positions)
{
foreach (string item in positions)
{
int id = Convert.ToInt32(item.Split(',')[0]);
int order = Convert.ToInt32(item.Split(',')[1]);
slider d = db.sliders.Find(id);
d.SliderOrder = order;
db.SaveChanges();
}
}
public ActionResult Create([Bind(Include = "Id,Name,Images,Code,Status")] slider slider)
{
if (ModelState.IsValid)
{
db.sliders.Add(slider);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(slider));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
slider slider = new slider();
litSlider.Text = "";
foreach (string img in slider._images)
{
litSlider.Text += "<img src='slider/images/" + img + "' />";
}
}
}
public async Task <ActionResult> Create([Bind(Include = "id,Name,Description,Image")] slider slider, HttpPostedFileBase file, Helper Help)
{
if (ModelState.IsValid)
{
slider.Image = Help.uploadfile(file);
db.sliders.Add(slider);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(slider));
}
public ActionResult Create([Bind(Include = "Sliderid,Name,Description,Image,url,date")] slider slider, HttpPostedFileBase file, Helper Help)
{
if (ModelState.IsValid)
{
slider.date = System.DateTime.Now;
slider.Image = Help.uploadfile(file);
db.sliders.Add(slider);
db.SaveChanges();
TempData["Success"] = "Saved Successfully";
return(RedirectToAction("Index"));
}
return(View(slider));
}
// GET: /Slider/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
slider slider = db.sliders.Find(id);
if (slider == null)
{
return(HttpNotFound());
}
return(View(slider));
}
// GET: Auth/sliders/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
slider slider = await db.sliders.FindAsync(id);
if (slider == null)
{
return(HttpNotFound());
}
return(View(slider));
}
public ActionResult FormDataCreateSlider(string SLname, HttpPostedFileBase SLfile)
{
User user = Session["User"] as User;
if (user != null && user.LEVEL.Equals("10"))
{
string status;
string Name = SLname;
var file = SLfile;
if (Name == null || file == null || Name == "")
{
status = "empty";
return(new JsonResult {
Data = new { status = status }
});
}
else
{
string image = System.IO.Path.GetFileName(file.FileName);
string path = System.IO.Path.Combine(Server.MapPath("~/Assets/web/images/slider"), image);
file.SaveAs(path);
using (MemoryStream ms = new MemoryStream())
{
file.InputStream.CopyTo(ms);
byte[] array = ms.GetBuffer();
}
string idSlider = SliderDAO.GenerateIDSlider();
int numberSlider = SliderDAO.GenerateNumberSlider();
DBModel db = new DBModel();
var tableSlider = db.sliders;
slider tmpSlider = new slider();
tmpSlider.ID_SLIDER = idSlider;
tmpSlider.NAME = Name;
tmpSlider.IMAGE = file.FileName;
tmpSlider.NUMBER = numberSlider;
tmpSlider.ACTIVE = 1;
tableSlider.Add(tmpSlider);
db.SaveChangesAsync();
status = "success";
return(new JsonResult {
Data = new { status = status }
});
}
}
else
{
return(RedirectToAction("Index", "Home", new { area = "" }));
}
}
public ActionResult EditSlider(string idSlider)
{
User user = Session["User"] as User;
if (user != null && user.LEVEL.Equals("10"))
{
slider tmpSlider = SliderDAO.LoadSlider(idSlider);
ArrayList model = new ArrayList();
model.Add(tmpSlider);
return(View(model));
}
else
{
return(RedirectToAction("Index", "Home", new { area = "" }));
}
}
public slider SelectById(Int64 cid)
{
SqlDataAdapter da;
DataSet ds = new DataSet();
slider objcategory = new slider();
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "slider_SelectById";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
cmd.Parameters.AddWithValue("@cid", cid);
ConnectionString.Open();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0] != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
{
objcategory.cid = Convert.ToInt64(ds.Tables[0].Rows[0]["cid"]);
objcategory.imagename = Convert.ToString(ds.Tables[0].Rows[0]["imagename"]);
}
}
}
}
}
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
return(null);
}
finally
{
ConnectionString.Close();
}
return(objcategory);
}
public string insert_slider(slider slider)
{
try
{
ShopDBContext db = new ShopDBContext();
db.Slider.Add(slider);
db.SaveChanges();
return(slider.Name + "was successfully inserted");
}
catch (Exception e)
{
ShopDBContext db = new ShopDBContext();
return("Error" + e);
}
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
#region delete file
string fullPath = Request.MapPath("~/UploadedFiles/" + img);
if (System.IO.File.Exists(fullPath))
{
System.IO.File.Delete(fullPath);
}
#endregion
slider slider = await db.sliders.FindAsync(id);
db.sliders.Remove(slider);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public ActionResult Transition_SliderEkle(FormCollection formCollection)
{
int random_number = new Random().Next(0, 1024);
try
{
slider slide = (slider)MTranslation.BuildObject(formCollection, "slider");
// adding picture to Disk
HttpPostedFileBase file = Request.Files[0];
if (file.ContentLength > 0)
{
string filename = Path.GetFileName(file.FileName);
string path = Path.Combine(Server.MapPath("~/Files/Slider"), "" + random_number + filename);
file.SaveAs(path);
// food image_name is uploaded picture name
slide.filename = "" + random_number + filename;
slide.keywords = "akgül yemek,akgül organizasyon,akgül";
// adding food to Database
akgul_yemek_dbEntities db = new akgul_yemek_dbEntities();
db.slider.Add(slide);
db.SaveChanges();
Session["message"] = new MessageModel("Bilgi", "Slayt Resmi Ekendi.", Message_Type.Success);
return(RedirectToAction("Slider"));
}
else
{
MLog.Error("Slayt Resmi Ekenemedi.", "Slider Fotoğraf Yüklenemedi");
Session["message"] = new MessageModel("HATA", "Slider Fotoğraf Yüklenemedi", Message_Type.Error);
return(RedirectToAction("Slider"));
}
}
catch (Exception exception)
{
MLog.Error("Slider Fotoğraf Yüklenemedi", exception.Message + Environment.NewLine + exception.StackTrace);
Session["message"] = new MessageModel("HATA", "Bir hata oluştu.", Message_Type.Error);
return(RedirectToAction("Slider"));
}
}
public slider idyegorecek(int id)
{
SqlConnection baglan = new SqlConnection("Server=DESKTOP-6GBHM2T\\SQLEXPRESS;Database=Insaat;Integrated Security=true;");
baglan.Open();
SqlCommand komut = new SqlCommand("select*from slider where id=" + id, baglan);
SqlDataReader sliderdangelen = komut.ExecuteReader();
slider slidercik = new slider();
while (sliderdangelen.Read())
{
slidercik.id = Convert.ToInt32(sliderdangelen["id"]);
slidercik.baslik = sliderdangelen["baslik"].ToString();
slidercik.aciklama = sliderdangelen["aciklama"].ToString();
slidercik.resim = sliderdangelen["resim"].ToString();
}
return(slidercik);
}
public ActionResult AddSlider(HttpPostedFileBase[] Resim)
{
foreach (HttpPostedFileBase item in Resim)
{
if (item != null)
{
slider sl = new slider();
sl.Path = ResimBelgeEkle(item);
db.sliders.Add(sl);
db.SaveChanges();
}
}
ViewBag.Mesaj = " * Resimler Eklenmiştir. ";
List <slider> s = db.sliders.OrderBy(x => x.SliderOrder).ToList();
return(View(s));
}
void Start()
{
progress = GetComponent<Slider> ();
obj = this;
alert_sound = audio0.GetComponent<AudioSource> ();
alert_sound.enabled = false;
normal_music = audio1.GetComponent<AudioSource> ();
normal_music.enabled = false;
alert_music = audio2.GetComponent<AudioSource> ();
alert_music.enabled = false;
StartCoroutine (start ());
}
