protected void Page_Load(object sender, EventArgs e)
{
//place pictures
string addStage = string.Empty;
tblStagesCollection stageTbl = new tblStagesCollection();
stageTbl.ReadList();
tblStagesPicsCollection stagePicTbl = new tblStagesPicsCollection();
addStage += "<div class='grids_of_4'>";
for (int i = 0; i < stageTbl.Count; i++)
{
stagePicTbl.ReadList(Criteria.NewCriteria(tblStagesPics.Columns.stageId, CriteriaOperators.Equal, stageTbl[i].id));
addStage += "<div class='grid1_of_4'><div class='content_box'><a href='stage-details.aspx?item=" + stageTbl[i].id + "'>" +
"<img src='.." + stagePicTbl[0].picAddr + stagePicTbl[0].picName + "' class='img-responsive' alt='" + stagePicTbl[0].id + "' /></a>" +
"<h4><a> " + stageTbl[i].stageName + " </a></h4>" +
"<p>" + stageTbl[i].stagePhone + "</p>" +
"<div class='grid_1 simpleCart_shelfItem'>" +
"<div class='item_add'><span class='item_price'><h6>" + stageTbl[i].stageRowTotal + "</h6></span></div>" +
"<div class='item_add'><span class='item_price'><a href='stage-details.aspx?item=" + stageTbl[i].id + "'>EDIT</a></span></div>" +
"</div></div></div>";
if ((i - 1) % 4 == 0)
{
addStage += "<div class='clearfix'></div></div>";
addStage += "<div class='grids_of_4'>";
}
}
addStaffHtml.InnerHtml = addStage;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string errorString = string.Empty;
lblError.Visible = false;
tblStages stageTbl = new tblStages();
tblStagesPics stagesPicTbl = new tblStagesPics();
tblStagesSeats stagesSeatStatusTbl = new tblStagesSeats();
tblStagesSeats stagesSeatTbl = new tblStagesSeats();
tblStagesCollection stagesReadIdTbl = new tblStagesCollection();
int idStage = 0;
int rowNo = Convert.ToInt32(ddlStageRow.SelectedValue);
try
{
if (txtStageName.Text.Trim().Length > 0)
{
#region tblStage
stageTbl.stageName = txtStageName.Text;
stageTbl.stageAddress = txtAddress.Text;
stageTbl.stagePhone = txtPhone.Text;
stageTbl.stageDetails = txtDetail.Text;
stageTbl.stageRowTotal = Convert.ToInt32(ddlStageRow.SelectedValue);
stageTbl.allow = "1";
//stageTbl.Create();
#endregion
//Read the last id for other related tables
stagesReadIdTbl.ReadList();
if (stagesReadIdTbl.Count > 0)
{
idStage = stagesReadIdTbl[stagesReadIdTbl.Count - 1].id;
}
#region tblStagePic
// file upload start
string filename = string.Empty;
if (IsPostBack)
{
Boolean fileOK = false;
String path = Server.MapPath("~/images/stage/");
if (fuGallery.HasFile)
{
String fileExtension = System.IO.Path.GetExtension(fuGallery.FileName).ToLower();
String[] allowedExtensions = { ".jpg", ".png", ".bmp", ".tif" };
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 promblem with uplouding picture";
}
}
else
{
lblError.Text = "Not valid picture";
}
}
// file upload end
stagesPicTbl.picAddr = "images/stage/";
stagesPicTbl.stageId = idStage;
stagesPicTbl.allow = "1";
if (filename.Length > 0)
{
stagesPicTbl.picName = filename;
}
else
{
stagesPicTbl.picName = "default.jpg";
}
//if (lblError.Visible == false)
//stagesPicTbl.Create();
#endregion
#region tblStagesSeats
int lengthOfReadingRow = Convert.ToInt32(ddlStageRow.SelectedValue);
//read cookie
string cookieVal = "";
if (Request.Cookies["rowsNo"] != null)
{
cookieVal = Request.Cookies["rowsNo"].Value;
}
//reading values in splited text
string[] rowItem; string[] seperator = { "-" };
rowItem = cookieVal.Split(seperator, lengthOfReadingRow + 1, StringSplitOptions.RemoveEmptyEntries);
for (int i = 1; i <= lengthOfReadingRow; i++)
{
stagesSeatStatusTbl.StagesId = idStage;
stagesSeatStatusTbl.rowNo = i;
stagesSeatStatusTbl.seatsForRow = Convert.ToInt32(rowItem[i]);
stagesSeatStatusTbl.allow = "1";
//stagesSeatStatusTbl.Create();
}
#endregion
#region tblStagesSeatsStatus
#endregion
//Response.Redirect("staff.aspx");
}
else
{
lblError.Text = "* Please fill nesessary items";
lblError.Visible = true;
}
}
catch (Exception ex)
{
lblError.Text = ex.ToString();
lblError.Visible = true;
throw;
}
}
