protected void areaDDL_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList ddl = sender as DropDownList;
//testMsg.Text = ddl.SelectedValue;
try
{
cn.Open();
SqlCommand cmd = new SqlCommand(@"GetDistrictByAreaLang", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@areaID", SqlDbType.Int).Value = Convert.ToInt32(ddl.SelectedValue);
cmd.Parameters.Add("@lang", SqlDbType.Int).Value = Agency_Kernel.GetLanguageID();
DataSet ds = new DataSet();
SqlDataAdapter ad = new SqlDataAdapter(cmd);
ad.Fill(ds);
districtDDL.DataSource = ds;
districtDDL.DataBind();
ListItem li = new ListItem();
li.Attributes.Add("selected", "true");
li.Attributes.Add("disabled", "true");
li.Attributes.Add("hidden", "true");
li.Text = (string)GetLocalResourceObject("selectDistrict.Text");
li.Value = "";
districtDDL.Items.Insert(0, li);
}
catch (Exception ex)
{
//testMsg.Text = ex.Message;
}
finally
{
cn.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["lang"] != null)
{
Agency_Kernel.SaveLanguage(Request.QueryString["lang"].ToString());
string referer = Request.Headers["Referer"].ToString();
Response.Redirect(referer);
}
}
protected void loginBtn_Click(object sender, EventArgs e)
{
bool loginSuccess = false;
try
{
int agencyID = 0;
string enryptedPassword = Crypto.EncryptMD5(password.Text);
string accesskey = CommonFunc.GeneratePassword(20);
cn.Open();
SqlCommand cmd = new SqlCommand("AgencyLogin", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@email", SqlDbType.VarChar).Value = email.Text;
cmd.Parameters.Add("@password", SqlDbType.VarChar).Value = enryptedPassword;
cmd.Parameters.Add("@accesskey", SqlDbType.VarChar).Value = accesskey;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
agencyID = Convert.ToInt32(dr["agencyID"]);
Session["agencyID"] = agencyID;
loginSuccess = true;
errorDiv.Visible = false;
if (rememberMe.Checked)
{
Agency_Kernel.SaveAgencyIDCookie(agencyID, accesskey);
}
}
dr.Close();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{ }
if (loginSuccess)
{
Response.Redirect(CommonFunc.GetAgencyDomain() + "home/");
}
else
{
errorDiv.Visible = true;
}
}
private void LoadListing()
{
try
{
cn.Open();
SqlCommand cmd = new SqlCommand(@"GetPaidListing", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@lang", SqlDbType.Int).Value = Agency_Kernel.GetLanguageID();
cmd.Parameters.Add("@agencyID", SqlDbType.Int).Value = Convert.ToInt32(Session["agencyID"]);
DataSet ds = new DataSet();
SqlDataAdapter ad = new SqlDataAdapter(cmd);
ad.Fill(ds);
listRepeater.DataSource = ds;
listRepeater.DataBind();
}
catch (Exception ex)
{ }
finally
{
cn.Close();
}
}
private void LoadArea()
{
try
{
cn.Open();
SqlCommand cmd = new SqlCommand("GetAreaByLang", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@lang", SqlDbType.Int).Value = Agency_Kernel.GetLanguageID();
DataSet ds = new DataSet();
SqlDataAdapter ad = new SqlDataAdapter(cmd);
ad.Fill(ds);
areaDDL.DataSource = ds;
areaDDL.DataBind();
areaDDL.Items.Insert(0, new ListItem((string)GetLocalResourceObject("selectArea.Text"), ""));
}
catch (Exception ex)
{ }
finally
{
cn.Close();
}
}
private void LoadPendingListing()
{
try
{
cn.Open();
SqlCommand cmd = new SqlCommand(@"GetPendingListing", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@lang", SqlDbType.Int).Value = Agency_Kernel.GetLanguageID();
cmd.Parameters.Add("@agencyID", SqlDbType.Int).Value = Convert.ToInt32(Session["agencyID"]);
DataSet ds = new DataSet();
SqlDataAdapter ad = new SqlDataAdapter(cmd);
ad.Fill(ds);
pendingListRepeater.DataSource = ds;
pendingListRepeater.DataBind();
}
catch (Exception ex)
{ }
finally
{
cn.Close();
}
foreach (RepeaterItem ri in pendingListRepeater.Items)
{
DropDownList durationDDL = ri.FindControl("durationDDL") as DropDownList;
DropDownList classDDL = ri.FindControl("classDDL") as DropDownList;
try
{
cn.Open();
SqlCommand cmd = new SqlCommand("GetAllListingTypeWithLang", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@lang", SqlDbType.Int).Value = Agency_Kernel.GetLanguageID();
DataSet ds = new DataSet();
SqlDataAdapter ad = new SqlDataAdapter(cmd);
ad.Fill(ds);
foreach (DataRow dr in ds.Tables[0].Rows)
{
ListItem li = new ListItem();
string itemClass = (string)GetLocalResourceObject("itemClass.Text");
itemClass = itemClass.Replace("{type}", dr["typeName"].ToString()).Replace("{price}", dr["price"].ToString());
li.Text = itemClass;
li.Value = dr["price"].ToString() + "@" + dr["typeID"].ToString();
classDDL.Items.Add(li);
}
}
catch (Exception ex)
{
}
finally
{
cn.Close();
}
if (durationDDL != null)
{
AsyncPostBackTrigger trigger1 = new AsyncPostBackTrigger();
trigger1.ControlID = durationDDL.UniqueID;
trigger1.EventName = "SelectedIndexChanged";
pendingPanel.Triggers.Add(trigger1);
}
if (classDDL != null)
{
AsyncPostBackTrigger trigger2 = new AsyncPostBackTrigger();
trigger2.ControlID = durationDDL.UniqueID;
trigger2.EventName = "SelectedIndexChanged";
pendingPanel.Triggers.Add(trigger2);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Session.Clear();
Agency_Kernel.Logout();
Response.Redirect(CommonFunc.GetAgencyDomain() + "Login/");
}
public void LoadData(int listingID)
{
try
{
listID.Value = listingID.ToString();
cn.Open();
SqlCommand cmd = new SqlCommand("GetListingInfoForEdit", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@listingID", SqlDbType.Int).Value = listingID;
cmd.Parameters.Add("@lang", SqlDbType.Int).Value = Agency_Kernel.GetLanguageID();
SqlDataAdapter ad = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
ad.Fill(ds);
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count == 1)
{
DataRow dr = ds.Tables[0].Rows[0];
areaID.Value = dr["areaID"].ToString();
districtID.Value = dr["districtID"].ToString();
area.Text = dr["area"].ToString();
district.Text = dr["district"].ToString();
if (dr["titleEn"].ToString() != "")
{
titleEn.Text = dr["titleEn"].ToString();
}
if (dr["titleTc"].ToString() != "")
{
titleTc.Text = dr["titleTc"].ToString();
}
if (dr["subTitleEn"].ToString() != "")
{
subTitleEn.Text = dr["subTitleEn"].ToString();
}
if (dr["subTitleTc"].ToString() != "")
{
subTitleTc.Text = dr["subTitleTc"].ToString();
}
ListItem roomDDLSelected = roomDDL.Items.FindByValue(dr["room"].ToString());
if (roomDDLSelected != null)
{
roomDDLSelected.Selected = true;
}
ListItem bathroomDDLSelected = bathroomDDL.Items.FindByValue(dr["bathroom"].ToString());
if (bathroomDDLSelected != null)
{
bathroomDDLSelected.Selected = true;
}
if (dr["size"].ToString() != "0" && dr["size"].ToString() != "")
{
size.Text = dr["size"].ToString();
}
if (dr["netSize"].ToString() != "0" && dr["netSize"].ToString() != "")
{
netSize.Text = dr["netSize"].ToString();
}
ListItem listingTypeCbSelected = listingTypeCb.Items.FindByValue(dr["listingType"].ToString());
if (listingTypeCbSelected != null)
{
listingTypeCbSelected.Selected = true;
}
if (dr["salePrice"].ToString() != "0" && dr["salePrice"].ToString() != "")
{
salePrice.Text = dr["salePrice"].ToString();
}
if (dr["rentPrice"].ToString() != "0" && dr["rentPrice"].ToString() != "")
{
rentPrice.Text = dr["rentPrice"].ToString();
}
if (dr["youtubeID"].ToString() != "")
{
youtubeID.Text = dr["youtubeID"].ToString();
}
if (dr["descEn"].ToString() != "")
{
descEn.Text = dr["descEn"].ToString();
}
if (dr["descTc"].ToString() != "")
{
descTc.Text = dr["descTc"].ToString();
}
}
if (ds.Tables[1] != null)
{
photoRepeater.DataSource = ds.Tables[1];
photoRepeater.DataBind();
for (int i = 0; i < photoRepeater.Items.Count; i++)
{
Button approveBtn = photoRepeater.Items[i].FindControl("delPhotoButton") as Button;
AsyncPostBackTrigger trigger = new AsyncPostBackTrigger();
trigger.ControlID = approveBtn.UniqueID;
trigger.EventName = "Click";
wallPanel.Triggers.Add(trigger);
}
availableImageCount = 7 - ds.Tables[1].Rows.Count;
if (availableImageCount < 0)
{
availableImageCount = 0;
}
else
{
List <availablePhoto> availablePhotoList = new List <availablePhoto>();
int displayOrder = ds.Tables[1].Rows.Count + 1;
for (int i = 0; i < availableImageCount; i++)
{
availablePhoto ap = new availablePhoto();
ap.index = displayOrder;
availablePhotoList.Add(ap);
displayOrder++;
}
availablePhotoRepeater.DataSource = availablePhotoList;
availablePhotoRepeater.DataBind();
foreach (RepeaterItem avaRepeaterItem in availablePhotoRepeater.Items)
{
FileUpload fu = avaRepeaterItem.FindControl("fileUpload") as FileUpload;
// ScriptManager.GetCurrent(this).RegisterPostBackControl(fu);
}
}
}
}
catch (Exception ex)
{
testMsg.Text = ex.Message;
}
finally
{
cn.Close();
}
}
