public string Index1(string email,string mobile,string bfname,string blname,string bstr,string bzip, string bcity,string bstate,string bstateid,string bcountry, string bdob, string sfname, string slname, string sstr,string szip,string scity, string sstate,string sstateid, string scountry,string sdob,string duedate)
        {
            PortalModel newmv = new PortalModel();
            PortalModel obj = new PortalModel();

            newmv.Email = email;
            newmv.Phone = Convert.ToInt64(mobile);
            newmv.Billfname = bfname;
            newmv.Billlname = blname;
            newmv.Billstreet = bstr;
            newmv.Billzipcode = Convert.ToInt32(bzip);
            newmv.Billcity = bcity;
            newmv.Billstate = bstate;
            newmv.Billstateid = Convert.ToInt32(bstateid);
            newmv.Billcountry = bcountry;
            //newmv.Billdob = Convert.ToDateTime(bdob);
            newmv.Billdob = bdob;
            newmv.Shipfname = sfname;
            newmv.Shiplname = slname;
            newmv.Shipstreet = sstr;
            newmv.Shipzipcode = Convert.ToInt32(szip);
            newmv.Shipcity = scity;
            newmv.Shipstate = sstate;
            newmv.Shipstateid = Convert.ToInt32(sstateid);
            newmv.Shipcountry = scountry;
            newmv.Shipdob = sdob;
            newmv.Bookdate = DateTime.Today;
            newmv.Duedate = Convert.ToDateTime(duedate);
            return obj.AddUsers(newmv);
        }
 public ActionResult Index()
 {
     PortalModel details = new PortalModel();
     PortalModel getobj = new PortalModel();
     details = getobj.GetUsers();
     return View(details);
 }
 public ActionResult Index()
 {
     ViewBag.agentName = "Welcome " + Session["agentName"];
     PortalModel details = new PortalModel();
     PortalModel getobj = new PortalModel();
     details = getobj.GetUsers();
     return View(details);
 }
        public PortalModel GetUsers()
        {
            PortalModel obj = new PortalModel();
            OleDbConnection connect = new OleDbConnection();

            connect.ConnectionString = "Provider=OraOLEDB.Oracle;Data Source=TR9001-PC11;User ID=system1;password=123";

            OleDbCommand command = new OleDbCommand("select * from T_CUSTOMER_DETAILS", connect);
            connect.Open();
            OleDbDataReader reader = command.ExecuteReader();
            while (reader.Read())
            {
                obj.Billfname = reader["strfirstname"].ToString();
                obj.Billlname = reader["strlastname"].ToString();
                obj.Billstreet = reader["STREETNAME"].ToString();
                obj.Billzipcode = Convert.ToInt32(reader["zipcode"]);
                obj.Billcity = reader["strcity"].ToString();
                obj.Billstate = reader["strstate"].ToString();
                obj.Billstateid = Convert.ToInt32(reader["stateid"]);
                obj.Billcountry = reader["strcountry"].ToString();
                obj.Billdob = Convert.ToDateTime(reader["dob"]).ToString("dd-mmm-yyyy");
                obj.Email = reader["email"].ToString();
            }
            return obj;
        }
        public string AddUsers(PortalModel Usersobj)
        {
            return "Custumer contact stored!";
            //OleDbConnection connect = new OleDbConnection();

            //connect.ConnectionString = "Provider=OraOLEDB.Oracle;Data Source=TR9001-PC11;User ID=system1;password=123";

            //connect.Open();
            //OleDbCommand command = new OleDbCommand("insert into Contact values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? )", connect);
            //command.Parameters.AddWithValue("?", Usersobj.Phone);
            //command.Parameters.AddWithValue("?", Usersobj.Billfname);
            //command.Parameters.AddWithValue("?", Usersobj.Billlname);
            //command.Parameters.AddWithValue("?", Usersobj.Billstreet);
            //command.Parameters.AddWithValue("?", Usersobj.Billzipcode);
            //command.Parameters.AddWithValue("?", Usersobj.Billcity);
            //command.Parameters.AddWithValue("?", Usersobj.Billstate);
            //command.Parameters.AddWithValue("?", Usersobj.Billstateid);
            //command.Parameters.AddWithValue("?", Usersobj.Billcountry);
            //command.Parameters.AddWithValue("?", Usersobj.Billdob);
            //command.Parameters.AddWithValue("?", Usersobj.Shipfname);
            //command.Parameters.AddWithValue("?", Usersobj.Shiplname);
            //command.Parameters.AddWithValue("?", Usersobj.Shipstreet);
            //command.Parameters.AddWithValue("?", Usersobj.Shipzipcode);
            //command.Parameters.AddWithValue("?", Usersobj.Shipcity);
            //command.Parameters.AddWithValue("?", Usersobj.Shipstate);
            //command.Parameters.AddWithValue("?", Usersobj.Shipstateid);
            //command.Parameters.AddWithValue("?", Usersobj.Shipcountry);
            //command.Parameters.AddWithValue("?", Usersobj.Bookdate);
            //command.Parameters.AddWithValue("?", Usersobj.Duedate);
            //command.Parameters.AddWithValue("?", Usersobj.Email);
            //command.Parameters.AddWithValue("?", Usersobj.Shipdob);

            //int count = command.ExecuteNonQuery();
            //connect.Close();
            //if (count > 0)
            //{
            //    return "Custumer contact stored!";
            //}
            //else
            //{
            //    return "Customer contact could not be stored!";
            //}
        }
        public PortalModel GetUsers()
        {
            PortalModel obj = new PortalModel();
            //return obj;
            OleDbConnection connect = new OleDbConnection();

            connect.ConnectionString = "Provider=MSDAORA;Data Source=OrderingGUI;Persist Security Info=True;User ID=system; Password=123";

            OleDbCommand command = new OleDbCommand("select * from T_CUSTOMER_DETAILS", connect);
            connect.Open();
            OleDbDataReader reader = command.ExecuteReader();
            while (reader.Read())
            {
                obj.Billfname = reader["strfirstname"].ToString();
                obj.Billlname = reader["strlastname"].ToString();
                obj.Billstreet = reader["STRSTREETNAME"].ToString();
                obj.Billzipcode = Convert.ToInt32(reader["numzipcode"]);
                obj.Billcity = reader["strcity"].ToString();
                obj.Billstate = reader["strstate"].ToString();
                obj.Billstateid = Convert.ToInt32(reader["numstateid"]);
                obj.Billcountry = reader["strcountry"].ToString();
                obj.Billdob = Convert.ToDateTime(reader["dob"]);
                obj.Email = reader["email"].ToString();
            }
            return obj;
        }
        public string AddUsers(PortalModel Usersobj)
        {
            OleDbConnection connect = new OleDbConnection();

            connect.ConnectionString = "Provider=MSDAORA;Data Source=OrderingGUI;Persist Security Info=True;User ID=system; Password=123";

            connect.Open();
            OleDbCommand command = new OleDbCommand("insert into Contact values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? )", connect);
            command.Parameters.AddWithValue("?", Usersobj.Phone);
            command.Parameters.AddWithValue("?", Usersobj.Billfname);
            command.Parameters.AddWithValue("?", Usersobj.Billlname);
            command.Parameters.AddWithValue("?", Usersobj.Billstreet);
            command.Parameters.AddWithValue("?", Usersobj.Billzipcode);
            command.Parameters.AddWithValue("?", Usersobj.Billcity);
            command.Parameters.AddWithValue("?", Usersobj.Billstate);
            command.Parameters.AddWithValue("?", Usersobj.Billstateid);
            command.Parameters.AddWithValue("?", Usersobj.Billcountry);
            command.Parameters.AddWithValue("?", Usersobj.Billdob);
            command.Parameters.AddWithValue("?", Usersobj.Shipfname);
            command.Parameters.AddWithValue("?", Usersobj.Shiplname);
            command.Parameters.AddWithValue("?", Usersobj.Shipstreet);
            command.Parameters.AddWithValue("?", Usersobj.Shipzipcode);
            command.Parameters.AddWithValue("?", Usersobj.Shipcity);
            command.Parameters.AddWithValue("?", Usersobj.Shipstate);
            command.Parameters.AddWithValue("?", Usersobj.Shipstateid);
            command.Parameters.AddWithValue("?", Usersobj.Shipcountry);
            command.Parameters.AddWithValue("?", Usersobj.Bookdate);
            command.Parameters.AddWithValue("?", Usersobj.Duedate);
            command.Parameters.AddWithValue("?", Usersobj.Email);
            command.Parameters.AddWithValue("?", Usersobj.Shipdob);

            int count = command.ExecuteNonQuery();
            connect.Close();
            if (count > 0)
            {
                return "Custumer contact stored!";
            }
            else
            {
                return "Customer contact could not be stored!";
            }
        }