//Edit Article
protected void btUpdate_Click(object sender, EventArgs e)
{
string dir = fm.getArticle("Image", getIDArticle());
if (FileUploadImages.HasFile)
{
FileUploadImages.SaveAs(Server.MapPath("~/ImagesArticle/images/") + FileUploadImages.FileName);
//dir = "ImagesArticle/images/" + FileUploadImages.PostedFile.FileName;
dir = "ImagesArticle/images/" + FileUploadImages.FileName;
}
cnDb.connect();
SqlCommand cmd = new SqlCommand("updateArticle", cnDb.conn);
cmd.CommandText = "updateArticle";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@IDArticle", getIDArticle());
cmd.Parameters.AddWithValue("@Title", txtTilte.Text);
cmd.Parameters.AddWithValue("@Contents", editorContent.Text);
// var today = DateTime.Now;
//var duration = new TimeSpan(0, 0, 0, 0);
//DateTime day = today.Add(duration);
// cmd.Parameters.AddWithValue("@DateOfPost", day);
cmd.Parameters.AddWithValue("@Source", txtSource.Text);
cmd.Parameters.AddWithValue("@MapAdd", txtMapAdd.Text);
cmd.Parameters.AddWithValue("@IDCategory", ddlCategory.SelectedValue);
cmd.Parameters.AddWithValue("@IDCity", ddlCity.SelectedValue);
cmd.Parameters.AddWithValue("@UserName", Session["UserLogin"]);
cmd.Parameters.AddWithValue("@Image", dir);
cmd.ExecuteNonQuery();
cnDb.conn.Close();
fm.logTask(Session["UserLogin"].ToString(), "Edit bài viết: " + txtTilte.Text);
Response.Write("<script>alert('Bạn đã cập nhật thành công')</script>");
}
protected void updateBtn_Click(object sender, EventArgs e)
{
string userId = (string)Session["currentUserId"];
string id = Request.QueryString["pId"].ToString();
if (FileUploadImages.HasFile)
{
FileUploadImages.SaveAs(Server.MapPath("/Public/images/" + FileUploadImages.FileName));
}
using (SqlConnection sqlConn = new SqlConnection(conStr))
{
using (SqlCommand cmd = new SqlCommand())
{
sqlConn.Open();
cmd.Connection = sqlConn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "updateProduct";
cmd.Parameters.Add(new SqlParameter("@id", id));
cmd.Parameters.Add(new SqlParameter("@name", Name.Text));
cmd.Parameters.Add(new SqlParameter("@price", Price.Text));
cmd.Parameters.Add(new SqlParameter("@quantity", Quantity.Text));
cmd.Parameters.Add(new SqlParameter("@description", Description.Text));
cmd.Parameters.Add(new SqlParameter("@guarantee", DropDownListGuarantee.SelectedItem.Value));
cmd.Parameters.Add(new SqlParameter("@images", FileUploadImages.FileName));
cmd.Parameters.Add(new SqlParameter("@cateId", DropDownListCate.SelectedItem.Value));
cmd.Parameters.Add(new SqlParameter("@userId", userId));
cmd.ExecuteNonQuery();
Response.Redirect("Products.aspx");
}
}
}
protected void Submit_Click(object sender, EventArgs e)
{
string checkList = string.Empty;
foreach (ListItem item in CheckBoxListDetails.Items)
{
if (item.Selected)
{
checkList += string.Format("{0},", item.Text);
}
}
string filename = FileUploadImages.PostedFile.FileName;
FileUploadImages.SaveAs(Server.MapPath("images/" + filename));
con.Open();
MySqlDataAdapter sda = new MySqlDataAdapter("UPDATE add_property SET p_image ='" + "images/" + filename + "',p_address ='" + propertyAddress.Text + "',p_area ='" + propertyArea.Text + "',p_city ='" + city.Text + "',p_description ='" + propertyDescription.InnerText + "',p_details ='" + checkList + "',p_price ='" + propertyPrice.Text + "',p_type ='" + propertyType.SelectedItem.ToString() + "',p_contract ='" + DropDownListContract.SelectedItem.ToString() + "',p_date ='" + Date.Text + "',user_name ='" + username.Text + "',p_bed ='" + bedRoom.Text + "',p_bath ='" + bathRoom.Text + "',name ='" + name.Text + "',email ='" + email.Text + "',mobile ='" + mobile.Text + "' WHERE p_id='" + Session["New"] + "'", con);
try
{
sda.SelectCommand.ExecuteNonQuery();
con.Close();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected void Submit_Click(object sender, EventArgs e)
{
string checkList = string.Empty;
foreach (ListItem item in CheckBoxListDetails.Items)
{
if (item.Selected)
{
checkList += string.Format("{0},", item.Text);
}
}
string filename = FileUploadImages.PostedFile.FileName;
FileUploadImages.SaveAs(Server.MapPath("images/" + filename));
con.Open();
string insertQuery = "INSERT INTO add_property(p_image,p_address,p_area,p_city,p_description,p_details,p_bed,p_bath,p_price,p_type,p_contract,p_date,user_name,name,email,mobile) values (@image,@address,@area,@city,@description,@details,@bed,@bath,@price,@type,@contract,@date,@username,@name,@email,@mobile)";
try
{
MySqlCommand com = new MySqlCommand(insertQuery, con);
com.Parameters.AddWithValue("@image", "images/" + filename);
com.Parameters.AddWithValue("@address", propertyAddress.Text);
com.Parameters.AddWithValue("@area", propertyArea.Text);
com.Parameters.AddWithValue("@city", city.Text);
com.Parameters.AddWithValue("@description", propertyDescription.InnerText);
com.Parameters.AddWithValue("@details", checkList);
com.Parameters.AddWithValue("@bed", bedRoom.Text);
com.Parameters.AddWithValue("@bath", bathRoom.Text);
com.Parameters.AddWithValue("@price", propertyPrice.Text);
com.Parameters.AddWithValue("@type", propertyType.SelectedItem.ToString());
com.Parameters.AddWithValue("@contract", DropDownListContract.SelectedItem.ToString());
com.Parameters.AddWithValue("@date", Date.Text);
com.Parameters.AddWithValue("@username", username.Text);
com.Parameters.AddWithValue("@name", name.Text);
com.Parameters.AddWithValue("@email", email.Text);
com.Parameters.AddWithValue("@mobile", mobile.Text);
com.ExecuteNonQuery();
con.Close();
propertyType.SelectedValue = "1";
propertyAddress.Text = "";
propertyArea.Text = "";
city.Text = "";
propertyDescription.InnerText = "";
propertyPrice.Text = "";
bedRoom.Text = "";
bathRoom.Text = "";
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
// Add new Article
protected void btAdd_Click(object sender, EventArgs e)
{
if (!FileUploadImages.HasFile) // Null image
{
lbMessFile.Visible = true;
}
else
{
lbMessFile.Visible = false;
try
{
string dir = "ImagesArticle/images/Vietnam_Timeless_Charm.PNG";
if (FileUploadImages.HasFile)
{
FileUploadImages.SaveAs(Server.MapPath("~/ImagesArticle/images/") + FileUploadImages.FileName);
//dir = "ImagesArticle/images/" + FileUploadImages.PostedFile.FileName;
dir = "ImagesArticle/images/" + FileUploadImages.FileName;
}
cnDb.connect();
SqlCommand cmd = new SqlCommand("insertArticle", cnDb.conn);
cmd.CommandText = "insertArticle";
cmd.CommandType = CommandType.StoredProcedure;
//var today = DateTime.Now;
//var duration = new TimeSpan(0, 0, 0, 0);
//DateTime day = today.Add(duration);
cmd.Parameters.AddWithValue("@Title", txtTilte.Text);
cmd.Parameters.AddWithValue("@Contents", editorContent.Text);
//cmd.Parameters.AddWithValue("@DateOfPost", day);
cmd.Parameters.AddWithValue("@Source", txtSource.Text);
cmd.Parameters.AddWithValue("@MapAdd", txtMapAdd.Text);
cmd.Parameters.AddWithValue("@IDCategory", ddlCategory.SelectedValue);
cmd.Parameters.AddWithValue("@IDCity", ddlCity.SelectedValue);
cmd.Parameters.AddWithValue("@UserName", Session["UserLogin"]);
cmd.Parameters.AddWithValue("@Image", dir);
cmd.ExecuteNonQuery();
cnDb.conn.Close();
fm.logTask(Session["UserLogin"].ToString(), "Thêm bài viết: " + txtTilte.Text);
Response.Write("<script>alert('Bạn đã cập nhật thành công')</script>");
Response.Redirect("CP_ArticleManagement.aspx");
}
catch (Exception)
{
cnDb.conn.Close();
Response.Write("<script>alert('Không thành công. Vui lòng thử lại sau.')</script>");
}
}
}
/// <summary>
/// Event when user select upload File to Image Directory button. It uploads a file to the
/// Images directory. These image files can be used in the home, about artist, and contact pages.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void UploadImagesButton_Click(object sender, EventArgs e)
{
if (FileUploadImages.HasFile)
{
try
{
string filename = Path.GetFileName(FileUploadImages.FileName);
FileUploadImages.SaveAs(Server.MapPath("~/Images/") + filename);
ErrorLabel.Text = "Upload status: File uploaded!";
}
catch (Exception ex)
{
ErrorLabel.Text = "Upload status: The file could not be uploaded. The following error occured: " + ex.Message;
}
}
else
{
ErrorLabel.Text = "Could not find file";
}
upPayPal.Update();
}
private bool RetrieveEmployeeImage()
{
if (FileUploadImages.HasFile)
{
if (FileUploadImages.PostedFile.FileName != "")
{
try
{
string path = FileUploadImages.PostedFile.FileName;
string Filename = FileUploadImages.FileName;
string strImageExtension = "";
bool isValidExtension = false;
strImageExtension = Filename.Substring(Filename.LastIndexOf("."), (Filename.Length - Filename.LastIndexOf(".")));
string[] Imageformat = { ".jpg", ".jpeg", ".bmp", ".png" };
for (int j = 0; j <= Imageformat.Length - 1; j++)
{
if (strImageExtension == Imageformat[j].ToString())
{
isValidExtension = true;
}
}
if (!isValidExtension)
{
this.lblSaveMessages.Text = "Please Select Proper Image format i.e JPG,PNG,BMP";
lblSaveMessages.Visible = true;
mpeAddEmployee.Show();
return(false);
}
if (EPD_EMPLOYEEID.Text != "")
{
Filename = EPD_EMPLOYEEID.Text + strImageExtension;
}
imgEmployeeImage.ImageUrl = FileUploadImages.PostedFile.FileName;
FileUploadImages.SaveAs(Server.MapPath("EmpImage/" + Filename));
ImageUrl = Server.MapPath("EmpImage/" + Filename).ToString();
//imgEmployeeImage.ImageUrl = "~/Handler1.ashx";
if (ViewState["AppMode"].ToString() != "EDIT")
{
Session["ServerImagePath"] = ImageUrl;
}
else
{
Session["ServerImagePath_U"] = ImageUrl;
}
//imgEmployeeImage.ImageUrl = "~/Handler1.ashx?ImagePath=" + ImageUrl;
DisplayEmployeeImage(ImageUrl);
}
catch (Exception ex)
{
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, "EmployeeMasterView");
}
}
else
{
this.lblMessages.Text = "Please Select Proper Image format i.e JPG,PNG,BMP";
}
}
return(true);
}
