protected void btnSubmit_Click(object sender, EventArgs e)
{
if (upImg.HasFile)
{
string sql;
Class.dbConfig db = new Class.dbConfig();
string fileName = upImg.FileName.ToString();
string Generation = "รุ่นที่ " + txtGen.Text;
string Category = convert2TextCat(Int16.Parse(ddlCategory.SelectedValue));
string uploadFolderPath = "~/Img/" + Category + "/" + Generation + "/";
string filePath = HttpContext.Current.Server.MapPath(uploadFolderPath);
bool exists = System.IO.Directory.Exists(Server.MapPath(uploadFolderPath));
if (!exists)
{
System.IO.Directory.CreateDirectory(Server.MapPath(uploadFolderPath));
}
upImg.SaveAs(filePath + "\\" + fileName);
string urlImg = uploadFolderPath + "/" + upImg.FileName.ToString();
sql = "insert into [mitruam_SchoolDrive].[mitruam_sp].[Img] (CategoryID,Generation,ImgName,ImgDTL,ImgURL) ";
sql += "VALUES ( ";
sql += "" + ddlCategory.SelectedValue + ",";
sql += "" + txtGen.Text + ",";
sql += "'" + fileName + "',";
sql += "'" + txtDtlImg.Text + "',";
sql += "'" + urlImg + "')";
if (db.ExecuteSQL(sql))
{
Response.Write("<script> alert('Upload Image Complete') </script>");
}
else
{
Response.Write("<script> alert('Upload Image Fail') </script>");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Class.dbConfig db = new Class.dbConfig();
DataSet ds;
string sql;
int count;
System.Web.UI.HtmlControls.HtmlGenericControl myh4;
System.Web.UI.HtmlControls.HtmlGenericControl imgDiv = new System.Web.UI.HtmlControls.HtmlGenericControl("DIV");
System.Web.UI.HtmlControls.HtmlImage img;
string tmp = "";
sql = "select * ";
sql += "from [mitruam_SchoolDrive].[mitruam_sp].[Img] ";
sql += "where CategoryID = '5' ";
sql += "order by Generation ";
ds = db.getData(sql);
count = ds.Tables[0].Rows.Count;
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < count; i++)
{
if (i == 0 || tmp != ds.Tables[0].Rows[i]["Generation"].ToString())
{
myh4 = new System.Web.UI.HtmlControls.HtmlGenericControl("h4");
myh4.InnerText = "รุ่นที่ " + ds.Tables[0].Rows[i]["Generation"];
myh4.Style.Add("margin-left", "100px");
myh4.Style.Add("font-weight", "bold");
containImg.Controls.Add(myh4);
imgDiv = new System.Web.UI.HtmlControls.HtmlGenericControl("DIV");
imgDiv.Style.Add("text-align", "center");
imgDiv.Style.Add("margin-top", "10px;");
imgDiv.Style.Add("margin-bottom", "10px;");
}
img = new System.Web.UI.HtmlControls.HtmlImage();
img.Src = ds.Tables[0].Rows[i]["ImgURL"].ToString();
img.Alt = ds.Tables[0].Rows[i]["ImgDTL"].ToString();
img.Attributes["class"] = "img_showCase";
imgDiv.Controls.Add(img);
containImg.Controls.Add(imgDiv);
tmp = ds.Tables[0].Rows[i]["Generation"].ToString();
}
}
}
private void getCategory()
{
ListItem li;
string sql;
Class.dbConfig db = new Class.dbConfig();
DataSet ds;
int count;
sql = "select * ";
sql += "from [mitruam_SchoolDrive].[mitruam_sp].[Category] ";
ds = db.getData(sql);
count = ds.Tables[0].Rows.Count;
for (int i = 0; i < count; i++)
{
li = new ListItem(ds.Tables[0].Rows[i]["CategoryName"].ToString(), ds.Tables[0].Rows[i]["CategoryID"].ToString());
ddlCategory.Items.Add(li);
}
}
