Example #1
0
 public void coursedata()
 {
     DataSet ds = null;
     Coursemaster course = new Coursemaster();
     course.Action = "Selectcoursedata";
     ds = course.coursemaster(course);
     ViewData["AllcouData"] = ds.Tables[0];
 }
Example #2
0
        //
        // GET: /Bookonline/
        public ActionResult Index(String seName,string location, String ObType, String price)
        {
            ViewBag.Type = ObType;
            if (ObType == "Course")
            {
                DataSet ds = null;
                Coursemaster course = new Coursemaster();
                course.Action = "Selectonslug";
                course.SlugName = seName;
                course.Location = location;
                ds = course.coursemaster(course);
                if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
                {
                    ViewBag.CName = ds.Tables[0].Rows[0]["Name"].ToString();
                    ViewBag.Location = ds.Tables[0].Rows[0]["Location"].ToString();
                    ViewBag.Date = ds.Tables[0].Rows[0]["Date"].ToString();
                    String pri = ds.Tables[0].Rows[0]["Price"].ToString();
                    ViewBag.Fee = pri;
                    double gst1 = (Convert.ToDouble(pri) * 10 / 100);
                    ViewBag.gst = gst1.ToString("0.00");
                    double total1 = Convert.ToDouble(pri) + gst1;
                    ViewBag.total = total1.ToString("0.00");
                }
            }
            else if (ObType == "Online")
            {
                DataSet ds = null;
                OnlineCourseMaster course = new OnlineCourseMaster();
                course.Action = "Selectonslug";
                course.Slug_Name = seName;
                ds = course.OnlineCourseMasters(course);
                if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
                {

                    ViewBag.CName = ds.Tables[0].Rows[0]["Name"].ToString();
                    String pri = ds.Tables[0].Rows[0]["price"].ToString();
                    ViewBag.Fee = pri;
                    double gst1 = (Convert.ToDouble(pri) * 10 / 100);
                    ViewBag.gst = gst1.ToString("0.00");
                    double total1 = Convert.ToDouble(pri) + gst1;
                    ViewBag.total = total1.ToString("0.00");
                }
            }
            else
            {
                ViewBag.CName = seName;
                ViewBag.Fee = price;
                double gst = (Convert.ToDouble(price) * 10 / 100);
                ViewBag.gst = gst;
                double total = Convert.ToDouble(price) + gst;
                ViewBag.total = total;
            }
            return View("~/Views/Home/Bookonline.cshtml");
        }
Example #3
0
        public DataSet coursemaster(Coursemaster obj)
        {
            DataSet ds =null;
            try
            {
                #region Parameters
                string[,] str = new string[10, 2];
                str[0, 0] = "@Action";
                str[0, 1] = obj.Action;

                str[1, 0] = "@C_Id";
                str[1, 1] = obj.C_Id.ToString();

                str[2, 0] = "@Trainingid";
                str[2, 1] = obj.Trainingid.ToString();

                str[3, 0] = "@Name";
                if (obj.Name == null)
                {
                    str[3, 1] = "";
                }
                else
                {
                    str[3, 1] = obj.Name;
                }
                str[4, 0] = "@Date";

                if (obj.Date == null)
                {
                    str[4, 1] = "";
                }
                else
                {
                    str[4, 1] = obj.Date;
                }

                str[5, 0] = "@Location";
                if (obj.Location == null)
                {
                    str[5, 1] = "";
                }
                else
                {
                    str[5, 1] = obj.Location;
                }

                str[6, 0] = "@Duration";
                str[6, 1] = obj.Duration.ToString();

                str[7, 0] = "@Price";
                str[7, 1] = obj.Price.ToString();

                str[8, 0] = "@Active";
                str[8, 1] = obj.Active.ToString();

                str[9, 0] = "@SlugName";
                if (obj.SlugName == null)
                {
                    str[9, 1] = "";
                }
                else
                {
                    str[9, 1] = obj.SlugName;
                }
                #endregion
                Database db = new Database();
                ds = db.StoreprocedureExecuteDsReturned("[SP_HSRS_Course_Masters]", str);
                return ds;
            }
            catch (Exception)
            {

                throw;
            }
        }
Example #4
0
 public ActionResult Index(Coursemaster model, string submit)
 {
     if (submit == "Submit" || submit == null)
     {
         master.Action = "Insert";
         master.Trainingid = model.Trainingid;
         master.Name = model.Name;
         master.SlugName = model.Name.Replace("®", "").Replace("&", "").Replace(" ", "").ToLower()+model.Duration+DateTime.Now.ToShortDateString().Replace("/","");
         master.Location = model.Location;
         master.Duration = model.Duration;
         master.Date = model.Date;
         master.Price = model.Price;
         DataSet ds = master.coursemaster(master);
         TempData["message"] = ds.Tables[0].Rows[0][0].ToString();
     }
     else
     {
         master.Action = "Update";
         master.C_Id = model.C_Id;
         master.Trainingid = model.Trainingid;
         master.Name = model.Name;
         master.SlugName = model.Name.Replace("®", "").Replace("&", "").Replace(" ", "").ToLower() + model.Duration + DateTime.Now.ToShortDateString().Replace("/", "");
         master.Location = model.Location;
         master.Duration = model.Duration;
         master.Date = model.Date;
         master.Price = model.Price;
         DataSet ds = master.coursemaster(master);
         TempData["message"] = ds.Tables[0].Rows[0][0].ToString();
     }
     return RedirectToAction("Index", "Coursemaster");
 }
Example #5
0
 //
 // GET: /Home/
 public ActionResult Index()
 {
     DataSet ds = null;
     Coursemaster course = new Coursemaster();
     course.Action = "Select";
     ds = course.coursemaster(course);
     ViewData["AllcouData"] = ds.Tables[0];
     ViewData["Agile"] = ds.Tables[1];
     ViewData["PMP"] = ds.Tables[2];
     return View("~/Views/Home/Home.cshtml");
 }