public ActionResult PackageDetails(int packageid, string packagename) { if (Session["AdminID"] == null) { return(RedirectToAction("login", "Admin")); } else { ViewBag.PACKAGEID = packageid; ViewBag.PACKAGENAME = packagename; var db = new DB_MODEL(); //package master = using package id var package__master = (from a in db.Package_Master where a.Package_Id == packageid select a).ToList(); //package spot = using pacage id var package__spot = (from a in db.Package_Spots where a.Package_Id == packageid select a).ToList(); //package tour var package__tour = (from a in db.Package_Tour where a.Package_Id == packageid select a).ToList(); //package grid var package__gird = (from a in db.Package_Grid_Image where a.Package_Id == packageid select a).ToList(); //package review var package__review = (from a in db.Package_Review where a.Package_Id == packageid select a).ToList(); var model = new ViewModel { package_master_vm = package__master, package_spots_vm = package__spot, package_tour_vm = package__tour, package_grid_vm = package__gird, package_review_vm = package__review }; return(View(model)); } }
private void modelBinding() { string _dbModel = typeof(DB_MODEL).Name; var ms = Assembly.GetExecutingAssembly().GetTypes().Cast <Type>() .Where(x => x.Namespace == "app.Model" && !m_listDataName.Any(o => o == x.Name)) .ToArray(); foreach (var info in ms) { //System.Reflection.MemberInfo info = typeof(MyClass); object[] _mcs = info.GetCustomAttributes(true).Where(x => x.GetType().Name == _dbModel).ToArray(); if (_mcs.Length > 0) { DB_MODEL mo = (DB_MODEL)_mcs[0]; mo.NAME = info.Name; mo.FIELDS = new DB_MODEL(info).FIELDS; registryModel(mo); int index = m_listMenu.FindIndex(x => x.NAME == mo.NAME); if (index == -1) { m_listMenu.Add(new MENU(mo)); } } } }
public ActionResult BookThisTour(int packageid, string packagename) { if (Session["UserID"] == null) { return(RedirectToAction("login", "Home")); } else { ViewBag.PACKAGEIDT = packageid; ViewBag.PACKAGENAMET = packagename; var db = new DB_MODEL(); //package master = using package id var package__master = (from a in db.Package_Master where a.Package_Id == packageid select a).ToList(); //package tour var package__tour = (from a in db.Package_Tour where a.Package_Id == packageid && a.Tour_Start_Date > DateTime.Now select a).ToList(); var model = new ViewModel { package_master_vm = package__master, package_tour_vm = package__tour }; return(View(model)); } }
public ActionResult Bookings() { if (Session["UserID"] == null) { return(RedirectToAction("login", "Home")); } else { int user__id = Convert.ToInt32(Session["UserID"]); var db = new DB_MODEL(); var package__master = (from a in db.Package_Master select a).ToList(); var booking = (from a in db.Bookings where a.User_Id == user__id select a).ToList(); var tour__package = (from a in db.Package_Tour select a).ToList(); var package_reviews = (from a in db.Package_Review where a.User_Id == user__id select a).ToList(); var model = new ViewModel { booking_vm = booking, package_master_vm = package__master, package_tour_vm = tour__package }; return(View(model)); } }
public ActionResult bookingcancel() { if (Session["AdminID"] == null) { return(RedirectToAction("login", "Admin")); } else { var db = new DB_MODEL(); var bookings__ = (from a in db.Bookings where a.Booking_Status == "Admin Cancel" || a.Booking_Status == "User Cancelled" select a).ToList(); var package__master = (from a in db.Package_Master select a).ToList(); var package__tour = (from a in db.Package_Tour select a).ToList(); var user__info = (from a in db.User_Info select a).ToList(); var model = new ViewModel { package_master_vm = package__master, package_tour_vm = package__tour, booking_vm = bookings__, user_info_vm = user__info }; return(View(model)); } }
public ActionResult PackageDetails(int packageid, string packagename) { ViewBag.PACKAGEID = packageid; ViewBag.PACKAGENAME = packagename; var db = new DB_MODEL(); int status_data = 0; //package master = using package id var package__master = (from a in db.Package_Master where a.Package_Id == packageid where a.Package_Status == false select a).ToList(); //package spot = using pacage id var package__spot = (from a in db.Package_Spots where a.Package_Id == packageid select a).ToList(); //package tour var package__tour = (from a in db.Package_Tour where a.Package_Id == packageid select a).ToList(); //package grid var package__gird = (from a in db.Package_Grid_Image where a.Package_Id == packageid select a).ToList(); //package review var package__review = (from a in db.Package_Review where a.Package_Id == packageid select a).ToList(); var model = new ViewModel { package_master_vm = package__master, package_spots_vm = package__spot, package_tour_vm = package__tour, package_grid_vm = package__gird, package_review_vm = package__review }; return(View(model)); }
public ActionResult TourDetails(int packageid, string packagename) { ViewBag.PACKAGEIDT = packageid; ViewBag.PACKAGENAMET = packagename; var db = new DB_MODEL(); //package master = using package id var package__master = (from a in db.Package_Master where a.Package_Id == packageid select a).ToList(); //package spot = using pacage id var package__spot = (from a in db.Package_Spots where a.Package_Id == packageid select a).ToList(); //package tour var package__tour = (from a in db.Package_Tour where a.Package_Id == packageid select a).ToList(); //package grid var package__gird = (from a in db.Package_Grid_Image where a.Package_Id == packageid select a).ToList(); //package review var package__review = (from a in db.Package_Review where a.Package_Id == packageid select a).ToList(); var user__info = (from a in db.User_Info select a).ToList(); var model = new ViewModel { package_master_vm = package__master, package_spots_vm = package__spot, package_tour_vm = package__tour, package_grid_vm = package__gird, package_review_vm = package__review, user_info_vm = user__info }; return(View(model)); }
public ActionResult Tours() { var db = new DB_MODEL(); var package__master = (from a in db.Package_Master select a).ToList(); var model = new ViewModel { package_master_vm = package__master }; return(View(model)); }
public FormModelEdit(IDataFile _db, string _dbName) : base("Model Edit", true) { db = _db; DbName = _dbName; Model = _db.GetModel(_dbName); ClientSize = new Size(fWidth, fHeight); init_Control(); }//end function init()
private void registryModel(DB_MODEL m) { var df = new DataFile(m); if (df.Opened) { if (m_dataFile.TryAdd(m.NAME, df)) { m_listDataName.Add(m.NAME); } } }
public static object ExeFuncBeforeAddOrUpdate(string fun_name, DB_MODEL model, string colField, Dictionary <string, object> data, object val) { object rs = val; if (fun_name != title_FUNC_BEFORE_ADD_OR_UPDATE && fun_name != title_FUNC_VALIDATE_ON_FORM) { Func <DB_MODEL, string, Dictionary <string, object>, object> exe; if (cacheFuncBeforeUpdate.TryGetValue(fun_name, out exe)) { rs = exe(model, colField, data); } } return(rs); }
public bool ModelUpdate(DB_MODEL model, bool hasRemoveField) { DataFile db = GetDF(model.NAME); if (db != null && db.Opened) { //int kAdd = model.Fields.Where(x => x.FieldChange == dbFieldChange.ADD).Count(); //int kRemove = model.Fields.Where(x => x.FieldChange == dbFieldChange.REMOVE).Count(); //if (kAdd > 0 && kRemove > 0) return false; return(db.UpdateModel(model, hasRemoveField)); } return(false); }
public bool CreateDb(DB_MODEL model) { DataFile df = new DataFile(model); if (df.Opened) { string name = df.Model.NAME; if (m_dataFile.TryAdd(name, df)) { m_listDataName.Add(name); } return(true); } return(false); }
public ActionResult Bookings() { int ab = Convert.ToInt32(Session["UserID"]); var db = new DB_MODEL(); var package__master = (from a in db.Package_Master select a).ToList(); var booking = (from a in db.Bookings where a.User_Id == ab select a).ToList(); var tour__package = (from a in db.Package_Tour select a).ToList(); var model = new ViewModel { booking_vm = booking, package_master_vm = package__master, package_tour_vm = tour__package }; return(View(model)); }
public ActionResult user_info() { if (Session["UserID"] == null) { return(RedirectToAction("login", "Home")); } else { int user__id = Convert.ToInt32(Session["UserID"]); var db = new DB_MODEL(); var user__info = (from a in db.User_Info where a.User_Id == user__id select a).ToList(); var model = new ViewModel { user_info_vm = user__info }; return(View(model)); } }
public ActionResult user_reviews() { if (Session["UserID"] == null) { return(RedirectToAction("login", "Home")); } else { int user__id = Convert.ToInt32(Session["UserID"]); var db = new DB_MODEL(); var package__review = (from a in db.Package_Review where a.User_Id == user__id select a).ToList(); var package__master = (from a in db.Package_Master select a).ToList(); var model = new ViewModel { package_review_vm = package__review, package_master_vm = package__master }; return(View(model)); } }
//private void form_RemoveAt(FlowLayoutPanel boi_Filter, int index) //{ // if (index == countField) // form_Remove(boi_Filter); // else // { // listIndexRemove.Add(index); // foreach (Control c in boi_Filter.Controls) // { // if (c.Name == "uc" + index.ToString()) // { // c.Visible = false; // break; // } // } // } //} //private void form_Remove(FlowLayoutPanel boi_Filter) //{ // int id = countField; // countField--; // if (countField == -1) return; // foreach (Control c in boi_Filter.Controls) // if (c.Name == "uc" + id.ToString()) // { // boi_Filter.Controls.Remove(c); // break; // } //} private void form_Submit(string dbName, string dbCaption, FlowLayoutPanel boi_Filter) { //string dbName = txt_Name.Text, dbCaption = txt_Caption.Text; if (string.IsNullOrEmpty(dbName)) { MessageBox.Show("Please input Model Name and fields: name, type, caption."); return; } dbName = dbName.ToUpper().Trim(); if (MessageBox.Show("Are you sure update model [" + dbName + "] ?", "Update Model", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button2) != DialogResult.Yes) { return; } bool exist = db.ExistModel(dbName); if (exist) { MessageBox.Show("Model Name exist. Please choose other name."); return; } var li = new List <FieldInfo>(); int index = 1; foreach (Control c in boi_Filter.Controls) { var o = new FieldInfo(); int ki = 0; foreach (Control fi in c.Controls) { #region if (fi.Name == "name" + index.ToString()) { o.NAME = (fi as TextBox).Text; } else if (fi.Name == "type" + index.ToString()) { int ix = (fi as ComboBox).SelectedIndex; o.TYPE_NAME = (fi as ComboBox).Items[ix].ToString(); } else if (fi.Name == "auto" + index.ToString()) { o.IS_KEY_AUTO = (fi as CheckBox).Checked; } else if (fi.Name == "kit" + index.ToString()) { #region if (o.IS_KEY_AUTO) { continue; } object _coltrol = (fi as ComboBox).SelectedItem; if (_coltrol != null) { try { o.KIT = (ControlKit)((int)(_coltrol as ComboboxItem).Value); } catch { } } #endregion } else if (fi.Name == "link_type" + index.ToString()) { if (o.IS_KEY_AUTO) { continue; } o.JOIN_TYPE = JoinType.NONE; object ct = (fi as ComboBox).SelectedItem; if (ct != null) { try { o.JOIN_TYPE = (JoinType)((int)(ct as ComboboxItem).Value); } catch { } } } else if (fi.Name == "value_default" + index.ToString()) { if (o.IS_KEY_AUTO) { continue; } string vd = (fi as TextBox).Text; o.VALUE_DEFAULT = vd == null ? new string[] { } : vd.Split('|'); } else if (fi.Name == "link_model" + index.ToString()) { if (o.IS_KEY_AUTO) { continue; } object ct = (fi as ComboBox).SelectedItem; if (ct != null) { o.JOIN_MODEL = (ct as ComboboxItem).Value as string; } } else if (fi.Name == "link_field" + index.ToString()) { if (o.IS_KEY_AUTO) { continue; } object ct = (fi as ComboBox).SelectedItem; if (ct != null) { o.JOIN_FIELD = (ct as ComboboxItem).Value as string; } } else if (fi.Name == "link_view" + index.ToString()) { if (o.IS_KEY_AUTO) { continue; } object ct = (fi as ComboBox).SelectedItem; if (ct != null) { o.JOIN_VIEW = (ct as ComboboxItem).Value as string; } } else if (fi.Name == "index" + index.ToString()) { o.IS_INDEX = (fi as CheckBox).Checked; } else if (fi.Name == "null" + index.ToString()) { o.IS_ALLOW_NULL = (fi as CheckBox).Checked; if (o.IS_KEY_AUTO || o.IS_INDEX) { o.IS_ALLOW_NULL = false; } } else if (fi.Name == "caption" + index.ToString()) { o.CAPTION = (fi as TextBox).Text; } else if (fi.Name == "caption_short" + index.ToString()) { o.CAPTION_SHORT = (fi as TextBox).Text; } else if (fi.Name == "des" + index.ToString()) { o.DESCRIPTION = (fi as TextBox).Text; } else if (fi.Name == "mobi" + index.ToString()) { o.MOBI = (fi as CheckBox).Checked; } else if (fi.Name == "tablet" + index.ToString()) { o.TABLET = (fi as CheckBox).Checked; } else if (fi.Name == "duplicate" + index.ToString()) { o.IS_NOT_DUPLICATE = (fi as CheckBox).Checked; } else if (fi.Name == "encrypt" + index.ToString()) { o.IS_ENCRYPT = (fi as CheckBox).Checked; } else if (fi.Name == "order_edit" + index.ToString()) { int _vi = 0; if (int.TryParse((fi as TextBox).Text, out _vi)) { o.ORDER_EDIT = _vi; } } else if (fi.Name == "order_view" + index.ToString()) { int _vi = 0; if (int.TryParse((fi as TextBox).Text, out _vi)) { o.ORDER_VIEW = _vi; } } else if (fi.Name == "func_edit" + index.ToString()) { o.FUNC_EDIT = fi.Text == dbFunc.title_FUNC_VALIDATE_ON_FORM ? "": fi.Text; } else if (fi.Name == "func_before_update" + index.ToString()) { o.FUNC_BEFORE_UPDATE = fi.Text == dbFunc.title_FUNC_BEFORE_ADD_OR_UPDATE ? "" : fi.Text; } else if (fi.Name == "key_url" + index.ToString()) { o.ORDER_KEY_URL = string.IsNullOrEmpty(fi.Text) ? 0 : int.Parse(fi.Text); } else if (fi.Name == "show_in_grid" + index.ToString()) { o.ONLY_SHOW_IN_DETAIL = (fi as CheckBox).Checked; } else if (fi.Name == "full_text_search" + index.ToString()) { o.IS_FULL_TEXT_SEARCH = (fi as CheckBox).Checked; } else if (fi.Name == "key_for_sync" + index.ToString()) { o.IS_KEY_SYNC_EDIT = (fi as CheckBox).Checked; } else if (fi.Name == "field_change" + index.ToString()) { try { o.FieldChange = string.IsNullOrEmpty(fi.Text) ? dbFieldChange.NONE : (dbFieldChange)int.Parse(fi.Text); } catch { } } ki++; #endregion }//end for fields if (!string.IsNullOrEmpty(o.NAME) && o.Type != null) { #region switch (o.KIT) { case ControlKit.RADIO: o.JOIN_TYPE = JoinType.DEF_VALUE; if (o.VALUE_DEFAULT == null || o.VALUE_DEFAULT.Length == 0 || (o.VALUE_DEFAULT.Length == 1 && o.VALUE_DEFAULT[0] == "")) { MessageBox.Show("Please input field [ " + o.NAME + " ] attributed [ Value Default ]"); return; } break; case ControlKit.SELECT: if (o.JOIN_TYPE == JoinType.DEF_VALUE && (o.VALUE_DEFAULT == null || o.VALUE_DEFAULT.Length == 0 || (o.VALUE_DEFAULT.Length == 1 && o.VALUE_DEFAULT[0] == ""))) { MessageBox.Show("Please input field [ " + o.NAME + " ] attributed [ Value Default ]"); return; } if (o.JOIN_TYPE == JoinType.JOIN_MODEL && (string.IsNullOrEmpty(o.JOIN_MODEL) || string.IsNullOrEmpty(o.JOIN_FIELD))) { MessageBox.Show("Please input field [ " + o.NAME + " ] attributed [ JOIN MODEL - JOIN FIELD ]"); return; } break; case ControlKit.LOOKUP: if (o.JOIN_TYPE == JoinType.JOIN_MODEL && (string.IsNullOrEmpty(o.JOIN_MODEL) || string.IsNullOrEmpty(o.JOIN_FIELD))) { MessageBox.Show("Please input field [ " + o.NAME + " ] attributed [ JOIN MODEL - JOIN FIELD ]"); return; } break; } if (o.JOIN_TYPE == JoinType.JOIN_MODEL && !string.IsNullOrEmpty(o.JOIN_MODEL) && !string.IsNullOrEmpty(o.JOIN_FIELD)) { string[] types = db.GetFields(o.JOIN_MODEL).Where(x => x.NAME == o.JOIN_FIELD).Select(x => x.TYPE_NAME).ToArray(); if (types.Length > 0) { o.TYPE_NAME = types[0]; } } if (o.JOIN_TYPE == JoinType.DEF_VALUE && o.VALUE_DEFAULT != null && o.VALUE_DEFAULT.Length >= 1 && o.VALUE_DEFAULT[0] != "") { o.TYPE_NAME = typeof(Int32).Name; } #endregion if (o.FieldChange != dbFieldChange.REMOVE) { li.Add(o); } } else { MessageBox.Show("Please input fields: name, type, caption."); c.Focus(); return; } index++; }//end for controls if (li.Count > 0) { DB_MODEL m = new DB_MODEL() { NAME = dbName.Replace(" ", "_").Trim().ToUpper(), FIELDS = li.ToArray(), }; if (OnSubmit != null) { OnSubmit(m); } } else { MessageBox.Show("Please input fields: name, type, caption."); } }