protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
BLOG rec = DALBlog.Get(Int32.Parse(Request.QueryString["ID"]));
if (rec != null)
{
DALBlog.Delete(rec.ID);
}
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "ClosePage", "CloseModal(true);", true);
NotificationAdd(NotificationType.success, "Kayıt Silindi.");
}
catch (Exception ex)
{
if (ex is SqlException)
{
if ((ex as SqlException).Number == 547)
{
NotificationAdd(NotificationType.error, "Kayıt başka yerlerde kullanıdı.");
}
}
else
{
throw ex;
}
}
}
protected void rptrBlog_ItemCommand(object source, RepeaterCommandEventArgs e)
{
switch (e.CommandName)
{
case "Down":
{
BLOG self = DALBlog.Get(Int32.Parse(e.CommandArgument.ToString()));
BLOG upper = DALBlog.GetBySort(self.SORT + 1);
self.SORT++;
upper.SORT--;
DALBlog.Update(self);
DALBlog.Update(upper);
fillBlog();
break;
}
case "Up":
{
BLOG self = DALBlog.Get(Int32.Parse(e.CommandArgument.ToString()));
BLOG upper = DALBlog.GetBySort(self.SORT - 1);
self.SORT--;
upper.SORT++;
DALBlog.Update(self);
DALBlog.Update(upper);
fillBlog();
break;
}
}
}
protected void btnUploadFile_Click(object sender, EventArgs e)
{
if (fuImage.HasFile)
{
string path = Server.MapPath("~") + "Admin\\assets\\images\\";
string extension = Path.GetExtension(fuImage.FileName);
string orgImagePath = string.Empty;
string[] name = fuImage.FileName.Split(new string[] { extension }, StringSplitOptions.None);
IMAGE = name[0];
if (DALBlog.HasImage(IMAGE))
{
// once orjinal dosyayi bir kaydedelim
orgImagePath = path + IMAGE + extension;
fuImage.SaveAs(orgImagePath);
// simdi sizelara gore kaydedelim
SaveImage(orgImagePath, Convert.ToInt32(GetPrameterValue("DISEASESWIDTH")), Convert.ToInt32(GetPrameterValue("DISEASESHEIGHT")), "_l");
SaveImage(orgImagePath, Convert.ToInt32(GetPrameterValue("SLIDERADMINWIDTH")), Convert.ToInt32(GetPrameterValue("SLIDERADMINHEIGHT")), "_s");
tdImage.Visible = false;
tdImagePreview.Visible = true;
imgImage.ImageUrl = Functions.SITEURL.PathAndQuery + "Admin/assets/images/" + IMAGE + "_s" + extension;
imgImage.Width = new Unit(GetPrameterValue("SLIDERADMINWIDTH"));
imgImage.Height = new Unit(GetPrameterValue("SLIDERADMINHEIGHT"));
}
else
{
NotificationAdd(NotificationType.error, "Lütfen Resmin Adını Değiştiriniz");
}
}
}
private void InitializePage()
{
if (!string.IsNullOrEmpty(Request.QueryString["ID"]))
{
RECid = Convert.ToInt16(Request.QueryString["ID"]);
BLOG item = DALBlog.Get(RECid);
if (item != null)
{
if (string.IsNullOrEmpty(item.IMAGE))
{
tdImage.Visible = true;
}
else
{
tdImage.Visible = true;
tdImagePreview.Visible = true;
}
imgImage.ImageUrl = Functions.SITEURL.PathAndQuery + "Admin/assets/images/" + item.IMAGE + "_s.jpg";
imgImage.Width = new Unit(GetPrameterValue("SLIDERADMINWIDTH"));
imgImage.Height = new Unit(GetPrameterValue("SLIDERADMINHEIGHT"));
if (drpCatergori.Items.Count >= 1)
{
drpCatergori.SelectedValue = item.CATEGORIESID.ToString();
}
txtVideo.Text = item.VIDEOCODE;
txtAlt.Text = item.ALT;
hdnDescription.Value = Server.HtmlDecode(item.MAINTEXT);
txtTitle.Text = item.TITLE;
chkActive.Checked = item.ISACTIVE;
btnDelete.Visible = true;
if (!string.IsNullOrEmpty(item.VIDEOCODE))
{
item.ISIMAGE = false;
item.ISVIDEO = true;
item.ISARTICLE = false;
}
else if (!string.IsNullOrEmpty(item.IMAGE))
{
item.ISIMAGE = true;
item.ISVIDEO = false;
item.ISARTICLE = false;
}
else
{
item.ISIMAGE = false;
item.ISVIDEO = false;
item.ISARTICLE = true;
}
btnSave.Text = "Güncelle";
}
}
else
{
tdImage.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (RouteData.Values["TITLE"] != null)
{
title = RouteData.Values["TITLE"].ToString();
isQuestion();
}
rptrCategories.Bind(DALCategories.GetAll());
rptLastPost.Bind(DALBlog.GetLastCount(3));
}
public static BlogEntity ToBLLEntity(this DALBlog item)
{
if (ReferenceEquals(item, null))
{
return(null);
}
return(new BlogEntity()
{
Id = item.Id,
UserId = item.UserID
});
}
protected void Page_Load(object sender, EventArgs e)
{
string title = "";
if (RouteData.Values["TITLE"] != null)
{
title = RouteData.Values["TITLE"].ToString();
CATEGORIES c = DALCategories.GetTitle(title);
rptPostTitle.Bind(DALBlog.GetByCategoriesID(c.ID));
}
rptrCategories.Bind(DALCategories.GetAll());
rptLastPost.Bind(DALBlog.GetLastCount(3));
}
protected void Page_Load(object sender, EventArgs e)
{
//creating a table manually
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("BlogID", Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("BlogText", Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("Mood", Type.GetType("System.String")));
dt.Rows.Add(dt.NewRow());
dt.Rows.Add(dt.NewRow());
dt.Rows.Add(dt.NewRow());
dt.Rows[0]["BlogID"] = "FirstID";
dt.Rows[0]["BlogText"] = "Awesome!";
dt.Rows[0]["Mood"] = "This is for awesome people";
dt.Rows[1]["BlogID"] = "SecondID";
dt.Rows[1]["BlogText"] = "Take it easy...";
dt.Rows[1]["Mood"] = "Stop messing";
dt.Rows[2]["BlogID"] = "ThirdID";
dt.Rows[2]["BlogText"] = "Great!";
dt.Rows[2]["Mood"] = "Well done";
dt.PrimaryKey = new DataColumn[] { dt.Columns["BlogID"] };
GV3.DataSource = dt;
GV3.DataBind();
DataSet ds = new DataSet();
ds.Tables.Add(dt);
GV4.DataSource = ds.Tables[0];
GV4.DataBind();
DALBlog blogDAL = new DALBlog("cheeseConnectionString");
GV1.DataSource = blogDAL.GetDataTable("SELECT * FROM Blogs", "Blog");
GV1.DataBind();
Database db = DatabaseFactory.CreateDatabase("cheeseConnectionString");
GV2.DataSource = db.ExecuteDataSet(db.GetSqlStringCommand("SELECT * FROM Blogs"));
GV2.DataBind();
}
static void Main(string[] args)
{
DALBase <BLOG> dalBlog = new DALBlog();
var retornoBlog = dalBlog.Executar();
DALBase <Corretora> dalCorretora = new DALCorretora();
var retornoCorretora = dalCorretora.Executar();
var dalCliente = new DALCliente();
var retorno = dalCliente.Executar();
var dalAcao = new DALACAO();
var retornoAcao = dalAcao.Executar();
Console.ReadKey();
}
private void fillBlog()
{
rptCountBlog = DALBlog.getCount();
rptrBlog.Bind(DALBlog.GetAll().OrderBy(p => p.SORT));
lblCountImages.Text = "(" + rptCountBlog.ToString() + ")";
foreach (RepeaterItem item in rptrBlog.Items)
{
HiddenField hdn = item.FindControl("hdnImage") as HiddenField;
Image img = item.FindControl("imgImage") as Image;
if (string.IsNullOrEmpty(hdn.Value))
{
img.ImageUrl = Functions.SITEURL.PathAndQuery + "Admin/assets/images/noimage.png";
}
else
{
img.ImageUrl = Functions.SITEURL.PathAndQuery + "Admin/assets/images/" + hdn.Value + "_s.jpg";
}
img.Width = new Unit(GetPrameterValue("SLIDERADMINWIDTH"));
img.Height = new Unit(GetPrameterValue("SLIDERADMINHEIGHT"));
}
}
static void Main(string[] args)
{
DALBase<BLOG> dalBlog = new DALBlog();
var retornoBlog = dalBlog.Executar();
DALBase<Corretora> dalCorretora = new DALCorretora();
var retornoCorretora = dalCorretora.Executar();
var dalCliente = new DALCliente();
var retorno = dalCliente.Executar();
var dalAcao = new DALACAO();
var retornoAcao = dalAcao.Executar();
Console.ReadKey();
}
protected void Page_Load(object sender, EventArgs e)
{
//creating a table manually
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("BlogID", Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("BlogText", Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("Mood", Type.GetType("System.String")));
dt.Rows.Add(dt.NewRow());
dt.Rows.Add(dt.NewRow());
dt.Rows.Add(dt.NewRow());
dt.Rows[0]["BlogID"] = "FirstID";
dt.Rows[0]["BlogText"] = "Awesome!";
dt.Rows[0]["Mood"] = "This is for awesome people";
dt.Rows[1]["BlogID"] = "SecondID";
dt.Rows[1]["BlogText"] = "Take it easy...";
dt.Rows[1]["Mood"] = "Stop messing";
dt.Rows[2]["BlogID"] = "ThirdID";
dt.Rows[2]["BlogText"] = "Great!";
dt.Rows[2]["Mood"] = "Well done";
dt.PrimaryKey = new DataColumn[] { dt.Columns["BlogID"] };
GV3.DataSource = dt;
GV3.DataBind();
DataSet ds = new DataSet();
ds.Tables.Add(dt);
GV4.DataSource = ds.Tables[0];
GV4.DataBind();
DALBlog blogDAL = new DALBlog("cheeseConnectionString");
GV1.DataSource = blogDAL.GetDataTable("SELECT * FROM Blogs", "Blog");
GV1.DataBind();
Database db = DatabaseFactory.CreateDatabase("cheeseConnectionString");
GV2.DataSource = db.ExecuteDataSet(db.GetSqlStringCommand("SELECT * FROM Blogs"));
GV2.DataBind();
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (ValidateItem())
{
BLOG rec = new BLOG();
if (RECid > 0)
{
rec = DALBlog.Get(RECid);
if (!string.IsNullOrEmpty(IMAGE))
{
rec.IMAGE = IMAGE;
}
if (!string.IsNullOrEmpty(txtVideo.Text))
{
rec.ISIMAGE = false;
rec.ISVIDEO = true;
rec.ISARTICLE = false;
}
else if (!string.IsNullOrEmpty(rec.IMAGE))
{
rec.ISIMAGE = true;
rec.ISVIDEO = false;
rec.ISARTICLE = false;
}
else
{
rec.ISIMAGE = false;
rec.ISVIDEO = false;
rec.ISARTICLE = true;
}
if (drpCatergori.Items.Count >= 1)
{
rec.CATEGORIESID = Int32.Parse(drpCatergori.SelectedItem.Value);
}
else
{
rec.CATEGORIESID = -1;
}
rec.EDITOR = ONLINEUSER.NAME;
rec.ALT = txtAlt.Text;
rec.ISACTIVE = chkActive.Checked;
rec.MAINTEXT = Server.HtmlEncode(hdnDescription.Value);
rec.TITLE = txtTitle.Text;
rec.URLSEO = Code.Helper.SEOUrl(txtTitle.Text);
rec.VIDEOCODE = txtVideo.Text;
DALBlog.Update(rec);
}
else
{
if (!string.IsNullOrEmpty(txtVideo.Text))
{
rec.ISIMAGE = false;
rec.ISVIDEO = true;
rec.ISARTICLE = false;
}
else if (!string.IsNullOrEmpty(IMAGE))
{
rec.ISIMAGE = true;
rec.ISVIDEO = false;
rec.ISARTICLE = false;
}
else
{
rec.ISIMAGE = false;
rec.ISVIDEO = false;
rec.ISARTICLE = true;
}
if (drpCatergori.Items.Count >= 1)
{
rec.CATEGORIESID = Int32.Parse(drpCatergori.SelectedItem.Value);
}
else
{
rec.CATEGORIESID = -1;
}
rec.VIDEOCODE = txtVideo.Text;
rec.EDITOR = ONLINEUSER.NAME;
rec.IMAGE = IMAGE;
rec.SORT = Convert.ToInt16(DALBlog.GetLastSort() + 1);
rec.ALT = txtAlt.Text;
rec.ISACTIVE = chkActive.Checked;
rec.MAINTEXT = Server.HtmlEncode(hdnDescription.Value);
rec.TITLE = txtTitle.Text;
rec.URLSEO = Code.Helper.SEOUrl(txtTitle.Text);
rec.DATE = DateTime.Now;
DALBlog.Insert(rec);
}
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "ClosePage", "CloseModal(true);", true);
btnDelete.Visible = false;
btnCancel.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
rptrCategories.Bind(DALCategories.GetAll());
rptPost.Bind(DALBlog.GetLastCount(1));
rptLastPost.Bind(DALBlog.GetLastCount(3));
}
protected void Page_Load(object sender, EventArgs e)
{
rptrCategories.Bind(DALCategories.GetAll());
rptLastPost.Bind(DALBlog.GetLastCount(3));
rptQuestion.Bind(DALQUESTION.GetAll2().OrderBy(p => p.SORT));
}
protected void Page_Load(object sender, EventArgs e)
{
this.AsyncMode = true;
rptrCategories.Bind(DALCategories.GetAll());
rptLastPost.Bind(DALBlog.GetLastCount(3));
}
