Esempio n. 1
0
    protected void Button2_Click(object sender, EventArgs e)
    {
        string username = Username1.Value;
        string password = Password1.Value;
        bool   CLog     = cLog.Checked;
        bool   VLog     = vLog.Checked;


        if (CLog == true && cLog.Value.Equals("customer"))
        {
            tbl_CustomerLogin _isLogin = obj.LoginCustomer(username, password);
            if (_isLogin != null)
            {
                Session["UserObj"] = _isLogin;
                if (CRealm.Checked)
                {
                    Session["UserType"] = "Customer";
                }

                Response.Redirect("CustomerHome.aspx");
                //  lbl_Message1.Text = _isLogin.CustomerID; //"Login Successfully!!! :)";
                lbl_Message1.ForeColor = System.Drawing.Color.Green;
            }
            else
            {
                lbl_Message1.Text      = "Login Failed. Please Verify Your Credentials!!! :)";
                lbl_Message1.ForeColor = System.Drawing.Color.Red;
            }
        }
        else
        {
            tbl_VendorLogin _isLogin = vobj.LoginVendor(username, password);
            if (_isLogin != null)
            {
                Session["UserObj"] = _isLogin;
                if (VRealm.Checked)
                {
                    Session["UserType"] = "Vendor";
                }
                Response.Redirect("VendorHome.aspx");
                lbl_Message1.Text      = "Vendor Logged in !!!";
                lbl_Message1.ForeColor = System.Drawing.Color.Green;
            }
            else
            {
                lbl_Message1.Text      = "Login Failed. Please Verify Your Credentials!!! :)";
                lbl_Message1.ForeColor = System.Drawing.Color.Red;
            }
        }
    }
Esempio n. 2
0
    public List <Inovice> GenerateInvoice(int selectedVendorId, string custname, string custcontact, string ServiceType)
    {
        bool            _isinvoice = false;
        tbl_VendorLogin vObj       = new tbl_VendorLogin();
        var             obj        = (from r in vbContext.tbl_VendorLogins
                                      where r.VendorID == selectedVendorId
                                      select r).FirstOrDefault();

        inc.VenName     = obj.VendorName;
        inc.VenEmail    = obj.VendorEmail;
        inc.VenContact  = obj.VendorContact;
        inc.Basic       = (int)obj.VisitingCharges;
        inc.CustName    = custname;
        inc.CustContact = custcontact;
        inc.ServiceType = ServiceType;
        incl.Add(inc);
        _isinvoice = true;
        return(incl);
    }
Esempio n. 3
0
    public bool addExtraDetail(string profession, int maxD, int visitCharge, int id)
    {
        bool _isAdded = false;

        try
        {
            tbl_VendorLogin loginObj = new tbl_VendorLogin();
            loginObj.VendorProfession   = profession;
            loginObj.MaxServiceDistance = maxD;
            loginObj.VisitingCharges    = visitCharge;
            loginObj.VendorID           = id;

            var query = from ord in dbContext.tbl_VendorLogins
                        where ord.VendorID == id
                        select ord;

            // Execute the query, and change the column values
            // you want to change.
            foreach (tbl_VendorLogin ord in query)
            {
                ord.VendorProfession   = loginObj.VendorProfession;
                ord.MaxServiceDistance = loginObj.MaxServiceDistance;
                ord.VisitingCharges    = loginObj.VisitingCharges;
                // Insert any additional changes to column values.
            }

            // Submit the changes to the database.


            dbContext.SubmitChanges();
            _isAdded = true;
        }
        catch (Exception e)
        {
            Console.WriteLine(e);
            // Provide for exceptions.
        }



        return(_isAdded);
    }
Esempio n. 4
0
    protected void Page_Load(object sender, EventArgs e)
    {
        tbl_VendorLogin vl = new tbl_VendorLogin();

        vl = (tbl_VendorLogin)Session["UserObj"];
        int            id    = vl.VendorID;
        List <Booking> book  = bobj.showBooking(id);
        DataTable      table = new DataTable();

        table.Columns.Add("Customer Name");
        table.Columns.Add("Email");
        table.Columns.Add("Contact");

        foreach (var obj in book)
        {
            table.Rows.Add(obj.CustName, obj.CustEmail, obj.CustContact);
        }
        DataGrid1.DataSource = table;
        DataGrid1.DataBind();
    }
Esempio n. 5
0
    public tbl_VendorLogin LoginVendor(string username, string password)
    {
        tbl_VendorLogin obj = null;

        try
        {
            tbl_VendorLogin loginObj = new tbl_VendorLogin();
            loginObj.VendorEmail    = username;
            loginObj.VendorPassword = password;

            var query = from p in dbContext.tbl_VendorLogins
                        where p.VendorEmail == loginObj.VendorEmail && p.VendorPassword == loginObj.VendorPassword
                        select p;
            obj = query.FirstOrDefault();
        }
        catch (Exception ex)
        {
        }
        return(obj);
    }
Esempio n. 6
0
    public bool RegisterVendor(string username, string password, string email, string contactNumber)
    {
        bool _isRegister = false;

        try
        {
            tbl_VendorLogin loginObj = new tbl_VendorLogin();
            loginObj.VendorName     = username;
            loginObj.VendorPassword = password;
            loginObj.VendorEmail    = email;
            loginObj.VendorContact  = contactNumber;
            //   loginObj.VendorProfession= profession;
            //  loginObj.VisitingCharges = 100;
            //  loginObj.MaxServiceDistance = 20;

            dbContext.tbl_VendorLogins.InsertOnSubmit(loginObj);
            dbContext.SubmitChanges();
            _isRegister = true;
        }
        catch (Exception ex)
        {
        }
        return(_isRegister);
    }
Esempio n. 7
0
    protected void setVendorsDetail(object sender, EventArgs e)
    {
        tbl_VendorLogin vl = new tbl_VendorLogin();

        vl = (tbl_VendorLogin)Session["UserObj"];
        int id = vl.VendorID;
        // string profession = Realm.Value;
        int    msd        = 0;
        String Profession = null;
        string latitude   = lat.Value;
        string longitude  = lon.Value;

        int  basic    = 0;
        bool plumbing = Plumbing.Checked;

        if (plumbing)
        {
            Profession = Plumbing.Value;
        }

        bool electical = Electrical.Checked;

        if (electical)
        {
            Profession = Electrical.Value;
        }

        bool carpentry = Carpentry.Checked;

        if (carpentry)
        {
            Profession = Carpentry.Value;
        }


        bool painting = Painting.Checked;

        if (painting)
        {
            Profession = Painting.Value;
        }


        bool interior = Interior_Design_Decorating.Checked;

        if (interior)
        {
            Profession = Interior_Design_Decorating.Value;
        }

        bool one = One.Checked;

        if (one)
        {
            msd = int.Parse(One.Value);
        }

        bool two = Two.Checked;

        if (two)
        {
            msd = int.Parse(Two.Value);
        }
        bool three = Three.Checked;

        if (three)
        {
            msd = int.Parse(Three.Value);
        }
        bool four = Four.Checked;

        if (four)
        {
            msd = int.Parse(Four.Value);
        }

        basic = int.Parse(Basic.Value);

        bool is_feed    = vd.addExtraDetail(Profession, msd, basic, id);
        bool is_located = ld.addLocationDetails(latitude, longitude, id);

        Response.Redirect("VendorHome.aspx");
    }
Esempio n. 8
0
 partial void Deletetbl_VendorLogin(tbl_VendorLogin instance);
Esempio n. 9
0
 partial void Updatetbl_VendorLogin(tbl_VendorLogin instance);
Esempio n. 10
0
 partial void Inserttbl_VendorLogin(tbl_VendorLogin instance);