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.");
}
}
