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
{
}
}
}
