protected void Page_Load(object sender, EventArgs e)
{
//Add ddl
tblServiceGroupCollection GroupTbl = new tblServiceGroupCollection();
GroupTbl.ReadList();
tblServicePicCollection detPicTbl = new tblServicePicCollection();
if (!IsPostBack)
{
for (int i = 0; i < GroupTbl.Count; i++)
{
ddlNewsGroup.Items.Add(new ListItem(GroupTbl[i].ServiceGroupTitle, GroupTbl[i].id.ToString()));
}
}
//place data
string detString = string.Empty;
tblServicesCollection detTbl = new tblServicesCollection();
detTbl.ReadList();
string addRow = "<div class='row'>";
int countSteps = 0;
for (int i = 0; i < detTbl.Count; i++)
{
GroupTbl.ReadList(Criteria.NewCriteria(tblServiceGroup.Columns.id, CriteriaOperators.Equal, detTbl[i].idServiceGroup));
detPicTbl.ReadList(Criteria.NewCriteria(tblServicePic.Columns.idService, CriteriaOperators.Equal, detTbl[i].id));
if (countSteps == 0)
{
detString += addRow;
}
detString += "<div class='col-md-6 graph-2'>" +
"<h3 class='inner-tittle'>Service " + (i + 1) + " </h3>" +
"<div class='panel panel-primary two'>" +
"<div class='panel-heading'>" + detTbl[i].ServiceTitle + "(" + GroupTbl[0].ServiceGroupTitle + ")" + "</div><div class='panel-body ont two'>";
if (detPicTbl.Count > 0)
{
detString += "<div><img src='../images/service/" + detPicTbl[0].picName + "' alt='" + detPicTbl[0].picName + "' style='width: 100%;' /></div>";
}
detString += "<p>" + detTbl[i].ServiceDetail + "</p></div>" +
"<div class='panel-footer'><a href='service-details.aspx?item=" + detTbl[i].id + "'>edit</a></div></div></div>";
countSteps++;
if (countSteps == 2)
{
countSteps = 0;
detString += "</div>";
}
}
infHtml.InnerHtml = detString;
}
protected void Page_Load(object sender, EventArgs e)
{
string serviceStr = string.Empty;
tblServiceGroupCollection serviceGrpTbl = new tblServiceGroupCollection();
tblServicePicCollection servicePicTbl = new tblServicePicCollection();
tblServicesCollection serviceTbl = new tblServicesCollection();
int itemGet = 0;
if (Request.QueryString["itemId"] != null)
{
itemGet = int.Parse(Request.QueryString["itemId"]);
serviceTbl.ReadList(Criteria.NewCriteria(tblServices.Columns.idServiceGroup, CriteriaOperators.Equal, itemGet));
}
else
{
serviceTbl.ReadList();
}
for (int i = 0; i < serviceTbl.Count; i++)
{
serviceGrpTbl.ReadList(Criteria.NewCriteria(tblServiceGroup.Columns.id, CriteriaOperators.Equal, serviceTbl[i].idServiceGroup));
servicePicTbl.ReadList(Criteria.NewCriteria(tblServicePic.Columns.idService, CriteriaOperators.Equal, serviceTbl[i].id));
serviceStr += "<div class='col-md-4 col-sm-6 col-xs-12'>" +
"<div class='grid1'><span>" + serviceGrpTbl[0].ServiceGroupTitle + "</span>" +
"<div class='price-tit text-center'>" +
"<img src='images/service/" + servicePicTbl[0].picName + "' alt='bondelectric " + servicePicTbl[0].picName + "' class='service-image' />" +
"<h2>" + serviceTbl[i].ServiceTitle + "</h2><p>" + serviceGrpTbl[0].ServiceGroupDetail + "</p></div>" +
"<div class='para'><p>" + serviceTbl[i].ServiceDetail + "</p></div></div></div>";
}
serviceStr += "<div class='clear'> </div>";
serviceHtml.InnerHtml = serviceStr;
#region header top picture
tblLogsCollection picTopTbl = new tblLogsCollection();
picTopTbl.ReadList();
if (picTopTbl.Count > 0)
{
headerPicHtml.Attributes["style"] = "background: url(" + picTopTbl[0].logDetail + ")no-repeat;background-size: cover;background-position: center;";
}
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
int itemGet = 0;
if (Request.QueryString["itemNo"] != null)
{
itemGet = int.Parse(Request.QueryString["itemNo"]);
}
else
{
Response.Redirect("default.aspx");
}
string servicesString = string.Empty;
tblServicesCollection servicesTbl = new tblServicesCollection();
servicesTbl.ReadList(Criteria.NewCriteria(tblServices.Columns.idServiceGroup, CriteriaOperators.Equal, itemGet));
tblServiceGroupCollection serviceGrpTbl = new tblServiceGroupCollection();
serviceGrpTbl.ReadList(Criteria.NewCriteria(tblServiceGroup.Columns.id, CriteriaOperators.Equal, itemGet));
tblServicePicCollection servicePicTbl = new tblServicePicCollection();
for (int i = 0; i < servicesTbl.Count; i++)
{
servicePicTbl.ReadList(Criteria.NewCriteria(tblServicePic.Columns.idService, CriteriaOperators.Equal, servicesTbl[i].id));
servicesString += "<div class='col-md-3'><div class='message-box'>" +
"<h4>" + serviceGrpTbl[0].ServiceGroupTitle + "</h4>" +
"<img src='images/service/" + servicePicTbl[0].picName + "' alt='bondelectric " + servicePicTbl[0].picName + "' />" +
"<h2>" + servicesTbl[i].ServiceTitle + "</h2>" +
"<p>" + servicesTbl[i].ServiceDetail + "</p></div></div>";
}
servicesHtml.InnerHtml = servicesString;
#region header top picture
tblLogsCollection picTopTbl = new tblLogsCollection();
picTopTbl.ReadList();
//if (picTopTbl.Count > 0)
//headerPicHtml.Attributes["style"] = "background: url(" + picTopTbl[0].logDetail + ")no-repeat;background-size: cover;background-position: center;";
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
tblServicesCollection serviceTbl = new tblServicesCollection();
serviceTbl.ReadList();
string serviceStr = "<h4 class='headInModule' style='text-align: right; direction: rtl; margin-bottom: 50px; margin-top: 10px; font-size: 28pt;'>خدمات</h4>";
for (int i = 0; i < serviceTbl.Count; i++)
{
serviceStr += "<div class='span12 module_cont module_text_area'>" +
"<h5>" + serviceTbl[i].ServiceTitle + "</h5>" +
"<p>" + serviceTbl[i].ServiceDetail + "</p></div>";
}
serviceHtml.InnerHtml = serviceStr;
}
catch (Exception)
{
serviceHtml.InnerHtml = "خطا در بارگذاری اطلاعات.";
}
}
protected void btnDel_Click(object sender, EventArgs e)
{
int itemGet = 0;
if (Request.QueryString["item"] != null)
{
itemGet = int.Parse(Request.QueryString["item"]);
}
else
{
Response.Redirect("service-details.aspx");
}
tblServicesCollection detTbl = new tblServicesCollection();
detTbl.ReadList(Criteria.NewCriteria(tblServices.Columns.id, CriteriaOperators.Equal, itemGet));
detTbl[0].Delete();
Response.Redirect("services-add.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string dateInsert = DateTime.Now.ToString("yyyy/MM/dd");
string timeInsert = DateTime.Now.ToString("hh:mm:ss");
tblServicesCollection detReadTbl = new tblServicesCollection();
tblServices detTbl = new tblServices();
tblServicePic detPicTbl = new tblServicePic();
if (txtTitle.Text.Trim().Length > 0)
{
detTbl.ServiceTitle = txtTitle.Text;
if (ckDetails.Text.Trim().Length > 0)
{
string str = ckDetails.Text;
detTbl.ServiceDetail = Server.HtmlDecode(str);
}
else
{
detTbl.ServiceDetail = "";
}
detTbl.idAgeGroup = 1;
detTbl.Gender = 0;
detTbl.idServiceGroup = Int32.Parse(ddlNewsGroup.SelectedValue);
detTbl.Create();
detReadTbl.ReadList();
// file upload start
string filename = string.Empty;
Boolean fileOK = false;
String path = Server.MapPath("~/images/service/");
// if picture
detPicTbl.idService = detReadTbl[detReadTbl.Count - 1].id;
if (IsPostBack)
{
if (fuGallery.HasFile)
{
String fileExtension = System.IO.Path.GetExtension(fuGallery.FileName).ToLower();
String[] allowedExtensions = { ".jpg", ".png", ".bmp", ".gif" };
for (int i = 0; i < allowedExtensions.Length; i++)
{
if (fileExtension == allowedExtensions[i])
{
fileOK = true;
}
}
}
if (fileOK)
{
try
{
fuGallery.PostedFile.SaveAs(path + fuGallery.FileName);
filename = fuGallery.FileName;
}
catch (Exception ex)
{
lblError.Text = "A problem with uplouding picture";
}
}
else
{
lblError.Text = "Not valid picture";
}
}
//file upload end
if (filename.Trim().Length > 0)
{
detPicTbl.picName = filename;
}
else
{
detPicTbl.picName = "default.jpg";
}
detPicTbl.picAddr = "~/images/service/";
detPicTbl.picDetails = "";
detPicTbl.allow = "1";
detPicTbl.Create();
Response.Redirect("services-add.aspx");
}
else
{
lblError.Text = "* please enter title frist.";
}
}
protected void Page_Load(object sender, EventArgs e)
{
int itemGet = 0;
if (Request.QueryString["item"] != null)
{
itemGet = int.Parse(Request.QueryString["item"]);
}
else
{
Response.Redirect("services-add.aspx");
}
//fill data
tblServicesCollection DetailsTbl = new tblServicesCollection();
DetailsTbl.ReadList(Criteria.NewCriteria(tblServices.Columns.id, CriteriaOperators.Equal, itemGet));
tblServicePicCollection DetailsPicTbl = new tblServicePicCollection();
DetailsPicTbl.ReadList(Criteria.NewCriteria(tblServicePic.Columns.idService, CriteriaOperators.Equal, itemGet));
if (DetailsPicTbl.Count > 0)
{
setPicHtml.InnerHtml = "<img src='../images/service/" + DetailsPicTbl[0].picName + "' class='img-responsive' draggable='false'>";
}
//----- Add writer of review -------
//string writerStr = string.Empty;
//tblStaffCollection NewsCreatorTbl = new tblStaffCollection();
//NewsCreatorTbl.ReadList(Criteria.NewCriteria(tblStaff.Columns.id, CriteriaOperators.Equal, DetailsTbl[0].infWriter));
//if (NewsCreatorTbl.Count > 0)
// writerStr = NewsCreatorTbl[0].StaffName + " " + NewsCreatorTbl[0].StaffFamily;
string addDataString = string.Empty;
addDataString += "<h3>" + DetailsTbl[0].ServiceTitle + "</h3><br>" +
//"<span class='code'>Writer: <a>" + writerStr + "</a></span>" +
"<p>Information Details: " + DetailsTbl[0].ServiceDetail + "</p>" +
"<div class='price'>" +
"<span class='text'></span>";
addDataString += "<span class='price-new'></span>";
addDataString += "<span class='price-tax'><label class='checkbox'></label></span><br>";
//addDataString += "<span class='points'><small>Insert Date: " + DetailsTbl[0].infDetailInsertDate + "</small></span><br>";
addDataString += "</div>";
addDetailHtml.InnerHtml = addDataString;
//fill data in change part
//Groups
tblServiceGroupCollection GroupTbl = new tblServiceGroupCollection();
GroupTbl.ReadList();
//Select old items
if (!IsPostBack)
{
if (DetailsTbl[0].ServiceTitle.Length > 0)
{
txtTitle.Text = DetailsTbl[0].ServiceTitle;
}
if (DetailsTbl[0].ServiceDetail.Length > 0)
{
string str = ckDetails.Text;
ckDetails.Text = Server.HtmlDecode(str);
}
for (int i = 0; i < GroupTbl.Count; i++)
{
ddlNewsGroup.Items.Add(new ListItem(GroupTbl[i].ServiceGroupTitle, GroupTbl[i].id.ToString()));
}
ddlNewsGroup.SelectedValue = DetailsTbl[0].idServiceGroup.ToString();
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
int itemGet = 0; string fileNameUpdate = string.Empty;
if (Request.QueryString["item"] != null)
{
itemGet = int.Parse(Request.QueryString["item"]);
}
else
{
Response.Redirect("service-add.aspx");
}
tblServicesCollection detTbl = new tblServicesCollection();
detTbl.ReadList(Criteria.NewCriteria(tblServices.Columns.id, CriteriaOperators.Equal, itemGet));
//tblNewsPicCollection newsPicTbl = new tblNewsPicCollection();
//newsPicTbl.ReadList(Criteria.NewCriteria(tblNewsPic.Columns.newsId, CriteriaOperators.Equal, itemGet));
//------- Add writer of review -------
//string writerStr = string.Empty;
//tblStaffCollection infWriterTbl = new tblStaffCollection();
//infWriterTbl.ReadList(Criteria.NewCriteria(tblStaff.Columns.id, CriteriaOperators.Equal, detTbl[0].infWriter));
//if (infWriterTbl.Count > 0)
// writerStr = infWriterTbl[0].StaffName + " " + infWriterTbl[0].StaffFamily;
//else
// writerStr = "Unknown";
//if (newsPicTbl.Count > 0)
// fileNameUpdate = newsPicTbl[0].picName;
if (txtTitle.Text.Trim().Length > 0)
{
detTbl[0].ServiceTitle = txtTitle.Text;
string str = ckDetails.Text;
detTbl[0].ServiceDetail = Server.HtmlDecode(str);
detTbl[0].idServiceGroup = Int32.Parse(ddlNewsGroup.SelectedValue);
detTbl[0].Update();
tblServicePicCollection detPicTbl = new tblServicePicCollection();
detPicTbl.ReadList(Criteria.NewCriteria(tblServicePic.Columns.idService, CriteriaOperators.Equal, itemGet));
// file upload start
string filename = string.Empty;
if (IsPostBack)
{
Boolean fileOK = false;
String path = Server.MapPath("~/images/service/");
if (fuGallery.HasFile)
{
String fileExtension = System.IO.Path.GetExtension(fuGallery.FileName).ToLower();
String[] allowedExtensions = { ".jpg", ".png", ".bmp", ".gif" };
for (int i = 0; i < allowedExtensions.Length; i++)
{
if (fileExtension == allowedExtensions[i])
{
fileOK = true;
}
}
}
if (fileOK)
{
try
{
fuGallery.PostedFile.SaveAs(path + fuGallery.FileName);
filename = fuGallery.FileName;
}
catch (Exception ex)
{
lblError.Text = "A problem accurred while uplouding picture";
}
}
else
{
lblError.Text = "Not valid picture file";
}
}
// file upload end
if (filename.Trim().Length > 0)
{
detPicTbl[0].picName = filename;
}
else
{
detPicTbl[0].picName = fileNameUpdate;
}
detPicTbl[0].picAddr = "~/images/service/";
detTbl[0].Update();
}
Response.Redirect("service-details.aspx?item=" + itemGet);
}
