protected void Button1_Click(object sender, EventArgs e) { try { AddFranchise editfranchise = new AddFranchise(); string franimage = ""; if (logo.FileName != "") { FileInfo fl = new FileInfo("uploads/" + hiddenimage.Value.ToString()); if (fl.Exists) { fl.Delete(); } logo.SaveAs(Server.MapPath("uploads/" + logo.FileName)); franimage = logo.FileName; } else { franimage = hiddenimage.Value.ToString(); } int id = Convert.ToInt16(Request.QueryString["id"]); editfranchise.editFranchise(franchise_name.Text, description.Text, email.Text, franimage, established_date.Text, started_date.Text, concept.Text, int.Parse(investment_required.Text), int.Parse(no_of_units.Text), int.Parse(category.Text), id); msg.Visible = true; msg.Text = "Franchise Updated successfully"; msg.ForeColor = Color.Green; } catch (Exception ex) { ltrmsg.Text = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { msg.Visible = false; userid.Visible = false; if (!IsPostBack) { description.Attributes.Add("maxlength", description.MaxLength.ToString()); AddFranchise cat = new AddFranchise(); db.dt = cat.showCategory(); category.DataSource = db.dt; category.DataTextField = ("name"); category.DataValueField = ("id"); category.DataBind(); if (Session["username"] != null) { if (Session["role"] == "franchiser") { string query = "select* from users where username ='******'"; SqlDataAdapter da = new SqlDataAdapter(query, db.con); DataSet ds = new DataSet(); da.Fill(ds, "user123"); DataTable dt = ds.Tables[0]; DataRow dr = dt.Rows[0]; userid.Text = dr["id"].ToString(); } } } }
public Schema() : base() { InstanceType = typeof(__Corporat__); Properties.ClearExposed(); Html = Add <__TString__>("Html"); Html.DefaultValue = "/Ahsan/Corporation/CorporationJson.html"; Html.SetCustomAccessors((_p_) => { return(((__Corporat__)_p_).__bf__Html__); }, (_p_, _v_) => { ((__Corporat__)_p_).__bf__Html__ = (System.String)_v_; }, false); Name = Add <__TString__>("Name"); Name.DefaultValue = ""; Name.SetCustomAccessors((_p_) => { return(((__Corporat__)_p_).__bf__Name__); }, (_p_, _v_) => { ((__Corporat__)_p_).__bf__Name__ = (System.String)_v_; }, false); FranchiseNameToAdd = Add <__TString__>("FranchiseNameToAdd$", bind: "FranchiseNameToAdd"); FranchiseNameToAdd.DefaultValue = ""; FranchiseNameToAdd.Editable = true; FranchiseNameToAdd.SetCustomAccessors((_p_) => { return(((__Corporat__)_p_).__bf__FranchiseNameToAdd__); }, (_p_, _v_) => { ((__Corporat__)_p_).__bf__FranchiseNameToAdd__ = (System.String)_v_; }, false); AddFranchise = Add <__TLong__>("AddFranchise$"); AddFranchise.DefaultValue = 0L; AddFranchise.Editable = true; AddFranchise.SetCustomAccessors((_p_) => { return(((__Corporat__)_p_).__bf__AddFranchise__); }, (_p_, _v_) => { ((__Corporat__)_p_).__bf__AddFranchise__ = (System.Int64)_v_; }, false); AddFranchise.AddHandler((Json pup, Property <Int64> prop, Int64 value) => { return(new Input.AddFranchise() { App = (CorporationViewModel)pup, Template = (TLong)prop, Value = value }); }, (Json pup, Starcounter.Input <Int64> input) => { ((CorporationViewModel)pup).Handle((Input.AddFranchise)input); }); SortOnNumberOfHomes = Add <__TLong__>("SortOnNumberOfHomes$"); SortOnNumberOfHomes.DefaultValue = 0L; SortOnNumberOfHomes.Editable = true; SortOnNumberOfHomes.SetCustomAccessors((_p_) => { return(((__Corporat__)_p_).__bf__SortOnNumberOfHomes__); }, (_p_, _v_) => { ((__Corporat__)_p_).__bf__SortOnNumberOfHomes__ = (System.Int64)_v_; }, false); SortOnNumberOfHomes.AddHandler((Json pup, Property <Int64> prop, Int64 value) => { return(new Input.SortOnNumberOfHomes() { App = (CorporationViewModel)pup, Template = (TLong)prop, Value = value }); }, (Json pup, Starcounter.Input <Int64> input) => { ((CorporationViewModel)pup).Handle((Input.SortOnNumberOfHomes)input); }); SortOnTotalComission = Add <__TLong__>("SortOnTotalComission$"); SortOnTotalComission.DefaultValue = 0L; SortOnTotalComission.Editable = true; SortOnTotalComission.SetCustomAccessors((_p_) => { return(((__Corporat__)_p_).__bf__SortOnTotalComission__); }, (_p_, _v_) => { ((__Corporat__)_p_).__bf__SortOnTotalComission__ = (System.Int64)_v_; }, false); SortOnTotalComission.AddHandler((Json pup, Property <Int64> prop, Int64 value) => { return(new Input.SortOnTotalComission() { App = (CorporationViewModel)pup, Template = (TLong)prop, Value = value }); }, (Json pup, Starcounter.Input <Int64> input) => { ((CorporationViewModel)pup).Handle((Input.SortOnTotalComission)input); }); SortOnAverageComission = Add <__TLong__>("SortOnAverageComission$"); SortOnAverageComission.DefaultValue = 0L; SortOnAverageComission.Editable = true; SortOnAverageComission.SetCustomAccessors((_p_) => { return(((__Corporat__)_p_).__bf__SortOnAverageComission__); }, (_p_, _v_) => { ((__Corporat__)_p_).__bf__SortOnAverageComission__ = (System.Int64)_v_; }, false); SortOnAverageComission.AddHandler((Json pup, Property <Int64> prop, Int64 value) => { return(new Input.SortOnAverageComission() { App = (CorporationViewModel)pup, Template = (TLong)prop, Value = value }); }, (Json pup, Starcounter.Input <Int64> input) => { ((CorporationViewModel)pup).Handle((Input.SortOnAverageComission)input); }); SortOnTrend = Add <__TLong__>("SortOnTrend$"); SortOnTrend.DefaultValue = 0L; SortOnTrend.Editable = true; SortOnTrend.SetCustomAccessors((_p_) => { return(((__Corporat__)_p_).__bf__SortOnTrend__); }, (_p_, _v_) => { ((__Corporat__)_p_).__bf__SortOnTrend__ = (System.Int64)_v_; }, false); SortOnTrend.AddHandler((Json pup, Property <Int64> prop, Int64 value) => { return(new Input.SortOnTrend() { App = (CorporationViewModel)pup, Template = (TLong)prop, Value = value }); }, (Json pup, Starcounter.Input <Int64> input) => { ((CorporationViewModel)pup).Handle((Input.SortOnTrend)input); }); FranchiseList = Add <__TArray__>("FranchiseList"); FranchiseList.SetCustomAccessors((_p_) => { return(((__Corporat__)_p_).__bf__FranchiseList__); }, (_p_, _v_) => { ((__Corporat__)_p_).__bf__FranchiseList__ = (__Arr__)_v_; }, false); }
protected void Button1_Click(object sender, EventArgs e) { string data = "select franchise_name from franchise where franchise_name='" + franchise_name.Text + "'"; db.cmd = new SqlCommand(data, db.con); db.openConnection(); db.dr = db.cmd.ExecuteReader(); if (db.dr.Read()) { msg.Visible = true; msg.Text = "username already exists"; msg.ForeColor = Color.Red; } else { if (logo.HasFile) { string str = logo.FileName; string fileExtension = Path.GetExtension(str); if (fileExtension.ToLower() == ".jpg" || fileExtension.ToLower() == ".png" || fileExtension.ToLower() == ".bmp") { logo.PostedFile.SaveAs(Server.MapPath(".") + "//uploads//" + str); String path = "~//uploads//" + str.ToString(); AddFranchise createfranchise = new AddFranchise(); int catid = Convert.ToInt32(category.Text); createfranchise.addFranchises(franchise_name.Text, description.Text, email.Text, logo.FileName, established_date.Text, started_date.Text, concept.Text, int.Parse(investment_required.Text), int.Parse(no_of_units.Text), int.Parse(userid.Text), catid); msg.Visible = true; msg.Text = "Franchise Added successfully Please add investment details "; msg.ForeColor = Color.Green; } else { msg.Visible = true; msg.Text = "uploaded file must be either in jpg, png or bmp format"; msg.ForeColor = Color.Green; } } else { } } }
protected void Page_Load(object sender, EventArgs e) { uid.Visible = false; user_id.Visible = false; dbConnection db = new dbConnection(); if (!Page.IsPostBack) { msg.Visible = false; AddFranchise cat = new AddFranchise(); db.dt = cat.showCategory(); category.DataSource = db.dt; category.DataTextField = ("name"); category.DataValueField = ("id"); category.DataBind(); if (Session["username"] != null) { string query = "select* from users where username ='******'"; db.cmd = new System.Data.SqlClient.SqlCommand(query, db.con); db.openConnection(); db.dr = db.cmd.ExecuteReader(); while (db.dr.Read()) { string id = db.dr[0].ToString(); user_id.Text = id; } db.closeConnection(); } if (Request.QueryString["id"] != null) { string data = "select * from franchise where id='" + Request.QueryString["id"] + "'"; SqlDataAdapter da = new SqlDataAdapter(data, db.con); DataSet ds = new DataSet(); da.Fill(ds, "franchise"); DataTable dt = ds.Tables[0]; DataRow dr = dt.Rows[0]; franchise_name.Text = dr["franchise_name"].ToString(); description.Text = dr["description"].ToString(); email.Text = dr["email"].ToString(); established_date.Text = dr["established_date"].ToString(); started_date.Text = dr["started_date"].ToString(); concept.Text = dr["concept"].ToString(); investment_required.Text = dr["investment_required"].ToString(); no_of_units.Text = dr["no_of_units"].ToString(); category.Text = dr["catid"].ToString(); uid.Text = dr["uid"].ToString(); if (dr["logo"] != null) { string str = logo.FileName; lbllogo.Text = "<img id='id' src='uploads/" + dr["logo"] + "' width='100' height='100' />"; hiddenimage.Value = dr["logo"].ToString(); } if (uid.Text != user_id.Text) { Response.Redirect("login.aspx"); msg.Visible = true; msg.Text = "wrong login credentials"; } else { } } if (Session["username"] == null) { Response.Redirect("login.aspx"); } else { } } }