Esempio n. 1
0
        private void btndel_Click(object sender, EventArgs e)
        {
            string sdelrcid = this.txtrciddel.Text;

            if (sdelrcid == "")
            {
                MessageBox.Show("Pleae fill up receipt id !");
            }
            else
            {
                try
                {
                    int            delrcid = int.Parse(this.txtrciddel.Text);
                    Operatedbclass opdb    = new Operatedbclass();
                    if (opdb.Detecrcid(delrcid) == "")
                    {
                        MessageBox.Show("Receipt id not exist.");
                    }
                    else
                    {
                        opdb.Deletercid(delrcid);
                        MessageBox.Show("Receipt " + sdelrcid + " delete successful !");
                        this.txtrciddel.Text = "";
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Some error happened " + ex.Message + "");
                }
            }
        }
Esempio n. 2
0
        private void Insuranceservicesform_Load(object sender, EventArgs e)
        {
            Operatedbclass opdt = new Operatedbclass();

            opdt.initdtbind(this.dtgvis, "Insinfos");
            this.Initdgvh();
            Setdgvso(this.dtgvis);
            cominstype.Enabled = false;
            comclaimfp.Enabled = false;
        }
Esempio n. 3
0
 private void btnupdate_Click(object sender, EventArgs e)
 {
     if ((this.txtcarplate.Text == "") || (this.txtcarv.Text == "") || (this.labname.Text == ".") || (this.labphone.Text == "."))
     {
         MessageBox.Show("Please Fillup information !");
     }
     else
     {
         Operatedbclass opdb = new Operatedbclass();
         opdb.Updatecusinfo(this.labname.Text, this.txtcarplate.Text, this.labphone.Text, int.Parse(this.txtcarv.Text));
         MessageBox.Show("Update successful !");
         cleanup();
     }
 }
Esempio n. 4
0
        private void btnsubmit_Click(object sender, EventArgs e)
        {
            string acc, pass, actype, repass, countnum;

            acc      = this.txtacc.Text;
            pass     = this.txtpass.Text;
            repass   = this.txtcpass.Text;
            actype   = this.combacty.Text.Trim();
            countnum = "0";
            if ((acc == "") || (pass == "") || (repass == "") || (actype == ""))
            {
                MessageBox.Show("Please Fillup information !");
            }
            else
            {
                try
                {
                    Staffinfos     stinfo = new Staffinfos(actype, acc, repass);
                    Operatedbclass opdb   = new Operatedbclass();

                    if (pass.Equals(repass))
                    {
                        if (opdb.Matchaccount(stinfo.Staccount) != countnum)
                        {
                            MessageBox.Show("Account already exist. Please use another one.");
                        }
                        else
                        {
                            opdb.Insertloinfo(stinfo.Actype, stinfo.Staccount, stinfo.Stpass);
                            MessageBox.Show("Register successful !");
                            cleanup();
                        }
                    }
                    else
                    {
                        MessageBox.Show("Password doesn't match with the confirm password !");
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Some error happened " + ex.Message + "");
                }
            }
        }
Esempio n. 5
0
        private void btnsubmit_Click(object sender, EventArgs e)
        {
            Randomidclass rand      = new Randomidclass();
            int           trcid     = rand.genrandid();
            string        tcusname  = this.labname.Text;
            string        tcarnum   = this.labcarplate.Text;
            string        tcusphone = this.labphonenum.Text;
            string        tinstype  = this.cominstype.Text;
            string        tfayear   = this.comclaimfp.Text;
            string        tncd      = this.labncd.Text;
            string        tyy       = this.txtyy.Text;
            string        tmm       = this.txtmm.Text;
            string        tdd       = this.txtdd.Text;
            string        tstdate   = tyy + "-" + tmm + "-" + tdd;



            if ((tinstype == "") || (tfayear == "") || (tyy == "") || (tmm == "") || (tdd == "") || (tncd == "."))
            {
                MessageBox.Show("Please Fillup information !");
            }
            else
            {
                try
                {
                    string           tendyy   = (int.Parse(tyy) + 1).ToString();
                    string           tenddate = tendyy + "-" + tmm + "-" + tdd;
                    int              tcarv    = int.Parse(this.labcarval.Text);
                    Operatedbclass   opdb     = new Operatedbclass();
                    Insurancedetails insd     = new Insurancedetails(trcid, tcusname, tcarnum, tcusphone, tcarv, tinstype,
                                                                     tfayear, tncd, glbsum, tstdate, tenddate);
                    opdb.Insertinsrecord(insd.Rcid, insd.Cusname, insd.Carnum, insd.Cusphone, insd.Carprice, insd.Instype, insd.Fayear,
                                         insd.Ncd, insd.Sum, insd.Stdate, insd.Enddate);
                    MessageBox.Show("Submit successful! Please research to view record.");
                    cleanup();
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Some error happened " + ex.Message + "");
                }
            }
        }
Esempio n. 6
0
        private void btnsearch_Click(object sender, EventArgs e)
        {
            string usphone = this.txtsp.Text;

            if (usphone == "")
            {
                MessageBox.Show("Phone number empty !");
            }
            else
            {
                Operatedbclass opdb = new Operatedbclass();
                //opdb.Detecphone(usphone);
                string        detectph = "";
                SqlConnection sqlconn  = opdb.Opendbcn();
                sqlconn.Open();
                string        sql2 = "select* from Cusinsinfo where Cusphone='" + usphone + "'";
                SqlCommand    cmd2 = new SqlCommand(sql2, sqlconn);
                SqlDataReader dr   = cmd2.ExecuteReader();
                if (dr.Read())
                {
                    detectph = dr["Cusphone"].ToString();
                    // if (detectph == usphone)
                    // {

                    cusphone = dr["Cusphone"].ToString();
                    cusname  = dr["Cusname"].ToString();
                    carnum   = dr["Carnum"].ToString();
                    carprice = dr["Carprice"].ToString();

                    // }
                }
                else
                {
                    MessageBox.Show("Phone number not exist !");
                }
                sqlconn.Close();
                this.labname.Text     = cusname;
                this.labphone.Text    = cusphone;
                this.txtcarplate.Text = carnum;
                this.txtcarv.Text     = carprice;
            }
        }
Esempio n. 7
0
        private void btnviewall_Click(object sender, EventArgs e)
        {
            string         phonenum = this.txtsearchphone.Text;
            Operatedbclass opdt     = new Operatedbclass();

            if (phonenum == "")
            {
                MessageBox.Show("Phone number empty !");
            }
            else
            {
                if (opdt.dtallbind(this.dtgvis, "Insinfos", phonenum) == "")
                {
                    MessageBox.Show("No record!");
                }
                else
                {
                    opdt.dtallbind(this.dtgvis, "Insinfos", phonenum);
                }
            }
        }
Esempio n. 8
0
        private void btnsearchphone_Click(object sender, EventArgs e)
        {
            string         phonenum = this.txtsearchphone.Text;
            Operatedbclass opdt     = new Operatedbclass();

            if (phonenum == "")
            {
                MessageBox.Show("Phone number empty !");
            }
            else
            {
                if (opdt.dtbind(this.dtgvis, "Cusinsinfo", phonenum) == "")
                {
                    MessageBox.Show("Phone number not exist !");
                }
                else
                {
                    opdt.dtbind(this.dtgvis, "Cusinsinfo", phonenum);
                }
            }
        }
Esempio n. 9
0
        private void btnsubmit_Click(object sender, EventArgs e)
        {
            string tcusname, tcarnum, tcusph, tcarpr, countnum;
            int    tcarpr2;

            tcusname = this.txtcusname.Text;
            tcarnum  = this.txtcarpn.Text;
            tcusph   = this.txtphonen.Text;
            tcarpr   = this.txtcarp.Text;

            countnum = "0";
            if ((tcusname == "") || (tcarnum == "") || (tcusph == "") || (tcarpr == ""))
            {
                MessageBox.Show("Please Fillup information !");
            }
            else
            {
                try
                {
                    tcarpr2 = int.Parse(tcarpr);
                    Customerinfos  cusinfosobj = new Customerinfos(tcusname, tcarnum, tcusph, tcarpr2);
                    Operatedbclass operatedb   = new Operatedbclass();
                    if (operatedb.Matchphone(cusinfosobj.Cusphone) != countnum)
                    {
                        MessageBox.Show("Phone number alreay registered !");
                    }
                    else
                    {
                        operatedb.Insertcusinfo(cusinfosobj.Cusname, cusinfosobj.Carnum, cusinfosobj.Cusphone, cusinfosobj.Carprice);
                        MessageBox.Show("Register successful !");
                        cleantxtbox();
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Some error happened " + ex.Message + "");
                }
            }
        }
Esempio n. 10
0
        private void btnviewallreceipt_Click(object sender, EventArgs e)
        {
            string rcid = this.txtrcid.Text;

            Operatedbclass opdt = new Operatedbclass();

            if (rcid == "")
            {
                MessageBox.Show("Receipt id empty !");
            }
            else
            {
                int rcidnum = int.Parse(this.txtrcid.Text);
                if (opdt.dtrcbind(this.dtgvis, "Insinfos", rcidnum) == "")
                {
                    MessageBox.Show("Receipt id not exist !");
                }
                else
                {
                    opdt.dtrcbind(this.dtgvis, "Insinfos", rcidnum);
                }
            }
        }
Esempio n. 11
0
        private void btnlogin_Click(object sender, EventArgs e)
        {
            string account = this.txtacc.Text;
            string passd   = this.txtpass.Text;

            if ((account == "") || (passd == ""))
            {
                MessageBox.Show("Please enter account or password !");
                return;
            }
            else
            {
                try
                {
                    Operatedbclass operatedb = new Operatedbclass();
                    if (operatedb.Finduserpass(account) == passd)
                    {
                        Multselectform multslf = new Multselectform();
                        multslf.lgusname = account;
                        multslf.lgustype = operatedb.Findusertype(account);
                        multslf.lgtime   = DateTime.Now.ToString();
                        this.Hide();
                        multslf.ShowDialog();
                        this.Close();
                    }
                    else
                    {
                        MessageBox.Show("Password error !");
                        return;
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Some error happened " + ex.Message + "");
                }
            }
        }