public static IEnumerable <module> GetMyModules()
{
DBFactory db;
SqlDataReader rdr;
List <module> data = null;
try
{
db = new DBFactory("CCATDBEntities");
rdr = db.ExecuteReader("MSI_GetLeftSideMenu", new SqlParameter("@roleName", GetRoleName()));
data = new List <module>();
module record;
while (rdr.Read())
{
record = new module();
record.moduleId = Convert.ToInt32(rdr["moduleId"].ToString());
record.pageMenuGroups = rdr["pageMenuGroups"].ToString();
data.Add(record);
}
//Close the datareader
rdr.Close();
}
catch (Exception ex)
{
throw new Exception("Exception in DataQueries.GetMyModules:" + ex.Message);
}
return(data.AsEnumerable <module>());
}
public void LoseControl()
{
if (_grabbed)
{
Transform _result = _grabbed.GetComponent <module>().OnRelease(this);
//TODO: _singleTestTrf = result or _flowTestTrfs[i] = result
//TODO: destroy the stuff existing previously
module _resultModule = _result.GetComponent <module>();
if (_resultModule._mySpot == module.SpotType.SingleTest)
{
if (_singleTestTrf)
{
Destroy(_singleTestTrf.gameObject);
_singleTestTrf = null;
}
_singleTestTrf = _result;
//_singleTestButton.GetComponent<button>().ShowSingleModuleRate(_singleTestTrf);
//TODO: update single test success rate on something
}
else if (_resultModule._mySpot == module.SpotType.FlowTest)
{
_flowButton.GetComponent <button>().SetFlowTest(false);
switch (_resultModule._myType)
{
case module.ModuleType.Tire:
if (_flowTestTrfs[0])
{
Destroy(_flowTestTrfs[0].gameObject);
_flowTestTrfs[0] = null;
}
_flowTestTrfs[0] = _result;
break;
case module.ModuleType.Door:
if (_flowTestTrfs[1])
{
Destroy(_flowTestTrfs[1].gameObject);
_flowTestTrfs[1] = null;
}
_flowTestTrfs[1] = _result;
break;
case module.ModuleType.Body:
if (_flowTestTrfs[2])
{
Destroy(_flowTestTrfs[2].gameObject);
_flowTestTrfs[2] = null;
}
_flowTestTrfs[2] = _result;
break;
default:
break;
}
}
_grabbed = null;
_grabbedParent = null;
}
}
/// <summary>
/// update
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public int update(ref module obj)
{
using (NpgsqlDBConnection db = new NpgsqlDBConnection())
{
try
{
if (db.open_connection())
{
string sql_command = "UPDATE modules set " +
" item_name = :item_name, module_id =:module_id, " +
" on_value = :on_value, off_value =:off_value, " +
" input_min = :input_min, input_max =:input_max, " +
" output_min = :output_min, output_max =:output_max, " +
" error_min = :error_min, error_max =:error_max, " +
" channel_number =:channel_number, off_set =:off_set " +
" where id = :id";
using (NpgsqlCommand cmd = db._conn.CreateCommand())
{
cmd.CommandText = sql_command;
cmd.Parameters.Add(":item_name", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.item_name;
cmd.Parameters.Add(":module_id", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.module_id;
cmd.Parameters.Add(":channel_number", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.channel_number;
cmd.Parameters.Add(":on_value", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.on_value;
cmd.Parameters.Add(":off_value", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.off_value;
cmd.Parameters.Add(":input_min", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.input_min;
cmd.Parameters.Add(":input_max", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.input_max;
cmd.Parameters.Add(":output_min", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.output_min;
cmd.Parameters.Add(":output_max", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.output_max;
cmd.Parameters.Add(":error_min", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.error_min;
cmd.Parameters.Add(":error_max", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.error_max;
cmd.Parameters.Add(":off_set", NpgsqlTypes.NpgsqlDbType.Double).Value = obj.off_set;
cmd.Parameters.Add(":id", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.id;
cmd.ExecuteNonQuery();
db.close_connection();
return(obj.id);
}
}
else
{
db.close_connection();
return(-1);
}
}
catch (NpgsqlException ex)
{
if (db != null)
{
db.close_connection();
}
return(-1);
}
}
}
private void bDelModule_Click(object sender, RoutedEventArgs e)
{
module current = dbGridModules.SelectedItem as module;
core.serviceCenterDB.modules.Remove(current);
core.serviceCenterDB.SaveChanges();
updateModules();
}
public ActionResult DeleteConfirmed(string id)
{
module module = db.modules.Find(id);
db.modules.Remove(module);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private async void _button_clicked(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(_FirstName.Text) && !string.IsNullOrWhiteSpace(_LastName.Text) && !string.IsNullOrWhiteSpace(_Email.Text) && !string.IsNullOrWhiteSpace(_Password.Text) && !string.IsNullOrWhiteSpace(_Num.Text) && !string.IsNullOrWhiteSpace(_module.Text))
{
var db = new SQLiteConnection(_dbPath);
var maxPK = db.Table <Teacher>().OrderByDescending(c => c.Id).FirstOrDefault();
Teacher teach = new Teacher()
{
Id = (maxPK == null ? 1 : maxPK.Id + 1),
FirstName = _FirstName.Text,
LastName = _LastName.Text,
Num = _Num.Text,
Email = _Email.Text.Trim(),
Password = _Password.Text.Trim()
};
db.Insert(teach);
var maxPK3 = db.Table <student>().OrderByDescending(c => c.Id).FirstOrDefault();
/*
* student std = new student {
* Email = "*****@*****.**",
* FirstName = "oussama",
* LastName = "el aaoumari",
* Id = (maxPK == null ? 1 : maxPK3.Id + 1),
* Nb_Absent = 0,
* Nb_Present = 0,
* Num = "063946765"
* };
* db.Insert(std);
*/
db.CreateTable <module>();
var maxPK2 = db.Table <module>().OrderByDescending(c => c.Id).FirstOrDefault();
module mod = new module()
{
Id = (maxPK2 == null ? 1 : maxPK2.Id + 1),
Name = _module.Text
};
db.Insert(mod);
await DisplayAlert("Alert", teach.FirstName + " " + teach.LastName + " Added", "Log In");
await Navigation.PushAsync(new LoginPage());
}
else
{
warning.Text = "Please Fill All the Fields !! ";
}
}
private void bEditModule_Click(object sender, RoutedEventArgs e)
{
module current = dbGridModules.SelectedItem as module;
Windows.ModuleWindow w = new Windows.ModuleWindow(current);
w.ShowDialog();
//(core.serviceCenterDB.modules.Where(m => m.Id == w.Module.Id).First())
core.serviceCenterDB.SaveChanges();
updateModules();
}
public ModuleWindow(module module)
{
currentModule = module;
init();
cbType.SelectedItem = currentModule.typeOfModule;
tbName.Text = currentModule.name;
tbInStock.Text = currentModule.numberInStock.ToString();
tbToOrder.Text = currentModule.needToOrder.ToString();
tbSafetyStock.Text = currentModule.safetyStock.ToString();
}
/// <summary>
/// Gets module by name.
/// </summary>
/// <param name="module1">The module1.</param>
/// <returns>module</returns>
/// <remarks></remarks>
public static module GetModuleByName(string module1)
{
module mod = new module();
DocsLinqDataContext doc_db = new DocsLinqDataContext();
mod = (from m in doc_db.modules
where m.module1.Equals(module1)
select m).FirstOrDefault<module>();
return mod;
}
public ActionResult Edit([Bind(Include = "moduleCode,deptCode,moduleTitle")] module module)
{
if (ModelState.IsValid)
{
db.Entry(module).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.deptCode = new SelectList(db.departments, "code", "name", module.deptCode);
return(View(module));
}
public ActionResult Create([Bind(Include = "moduleCode,deptCode,moduleTitle")] module module)
{
if (ModelState.IsValid)
{
db.modules.Add(module);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.deptCode = new SelectList(db.departments, "code", "name", module.deptCode);
return(View(module));
}
static void Main(string[] args)
{
System.IO.StreamReader str = new System.IO.StreamReader("test.xml");
XmlSerializer xSerializer = new XmlSerializer(typeof(module));
module m = (module)xSerializer.Deserialize(str);
str.Close();
Console.WriteLine(m.name);
Console.ReadLine();
}
// GET: modules/Details/5
public ActionResult Details(string deptCode, string moduleCode)
{
if (deptCode == null || moduleCode == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
module module = db.modules.Find(moduleCode, deptCode);
if (module == null)
{
return(HttpNotFound());
}
return(View(module));
}
// GET: modules/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
module module = db.modules.Find(id);
if (module == null)
{
return(HttpNotFound());
}
return(View(module));
}
public void Submit(module model)
{
model.IsDeleted = false;
model.UpdateTime = DateTime.Now;
if (model.ID == 0)
{
entity.module.Add(model);
}
else
{
entity.Entry <module>(model).State = System.Data.Entity.EntityState.Modified;
}
entity.SaveChanges();
}
private void addEditButton_Click(object sender, RoutedEventArgs e)
{
string descriptionModule = new TextRange(rtbEditor.Document.ContentStart, rtbEditor.Document.ContentEnd).Text;
if (db.module.Where(p => p.moduleId == moduleID).Any())
{
if (moduleName.Text != "" || descriptionModule != "" || imageArray != null)
{
var module = db.module.Where(p => p.moduleId == moduleID).FirstOrDefault();
module.moduleName = moduleName.Text;
module.description = descriptionModule;
module.moduleImage = imageArray;
db.SaveChanges();
}
}
else
{
if (moduleName.Text != "" && descriptionModule != "" && imageArray != null)
{
module addModule = new module
{
moduleName = moduleName.Text,
description = descriptionModule,
moduleImage = imageArray
};
test addTest = new test
{
testName = moduleName.Text,
moduleId = addModule.moduleId
};
badge addBadge = new badge
{
badgeName = moduleName.Text,
badgeImage = imageArray,
moduleId = addModule.moduleId
};
db.module.Add(addModule);
db.test.Add(addTest);
db.badge.Add(addBadge);
db.SaveChanges();
}
moduleName.Clear();
moduleImage.ImageSource = null;
rtbEditor.Document.Blocks.Clear();
}
}
// GET: modules/Edit/5
public ActionResult Edit(string deptCode, string moduleCode)
{
if (deptCode == null || moduleCode == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
module module = db.modules.Find(moduleCode, deptCode);
if (module == null)
{
return(HttpNotFound());
}
ViewBag.deptCode = new SelectList(db.departments, "code", "name", module.deptCode);
return(View(module));
}
public Login Loginpost(LoginInput logininfo)
{
using (var entity = new CASChillerSystemEntities())
{
Login login = new Login();
string username = logininfo.Username;
string password = logininfo.Password;
string appname = logininfo.Appname;
if (Membership.ValidateUser(username, password))
{
aspnet_Users asp_user = entity.aspnet_Users.Where(x => x.UserName == username).FirstOrDefault();
User user = entity.Users.Where(y => y.userlogin_id == asp_user.UserId).FirstOrDefault();
List <Modules> modulelist = new List <Modules>();
List <user_module> uml = entity.user_module.Where(z => z.users_id == user.Users_ID && z.menu_group == appname).ToList();
if (uml != null && uml.Count != 0)
{
login.Status = true;
for (int i = 0; i < uml.Count; i++)
{
Modules modules = new Modules();
int moduleid = (int)uml[i].Module_ID;
modules.Module_Name = entity.modules.Where(x => x.module_id == moduleid).Select(y => y.module_name).FirstOrDefault();
modules.Module_Display = uml[i].module_display_name;
int module_id = (int)uml[i].Module_ID;
module module = entity.modules.Where(x => x.module_id == module_id).FirstOrDefault();
modules.Module_Icon = module.description;
modulelist.Add(modules);
}
login.AppName = appname;
login.Token = entity.aspnet_Membership.Where(y => y.UserId == asp_user.UserId).Select(x => x.Password).FirstOrDefault();
login.Modules = modulelist;
login.Id = user.Users_ID;
//insert user login record to Transaction_Log table
Transaction_Log tl = new Transaction_Log();
tl.Log_Description = "User Login";
tl.Creation_Time = DateTime.Now;
tl.Creator = login.Id;
tl.Remarks = appname;
entity.Transaction_Log.Add(tl);
entity.SaveChanges();
}
}
return(login);
}
}
/// <summary>
/// get info by id
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public module get_info_by_id(int id)
{
using (NpgsqlDBConnection db = new NpgsqlDBConnection())
{
try
{
module obj = null;
if (db.open_connection())
{
string sql_command = "SELECT * FROM modules WHERE id = " + id;
sql_command += " LIMIT 1";
using (NpgsqlCommand cmd = db._conn.CreateCommand())
{
cmd.CommandText = sql_command;
NpgsqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
obj = new module();
obj = (module)_get_info(reader);
break;
}
reader.Close();
db.close_connection();
return(obj);
}
}
else
{
db.close_connection();
return(null);
}
}
catch
{
if (db != null)
{
db.close_connection();
}
return(null);
}
finally
{ db.close_connection(); }
}
}
private void ListViewItem_PreviewMouseRightButtonDown(object sender, MouseButtonEventArgs e)
{
ListViewItem lbi = sender as ListViewItem;
if (lbi != null)
{
module fam = lbi.DataContext as module;
if (fam != null)
{
try
{
moduleID = fam.moduleId;
}
catch { }
}
}
}
public ActionResult Edit([Bind(Include = "ModuleID,ModuleCode,ModuleTitle")] module module)
{
if (ModelState.IsValid)
{
if (db.modules.Any(s => s.ModuleCode.Equals(module.ModuleCode)))
{
ViewBag.Error = "Modulis su tokiu kodu jau yra pridėtas.";
return(View(module));
}
else
{
db.Entry(module).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(module));
}
private async void _saveButton_Clicked(object sender, EventArgs e)
{
var db = new SQLiteConnection(_dbPath);
var maxPK = db.Table <module>().OrderByDescending(c => c.Id).FirstOrDefault();
module mod = new module()
{
Id = (maxPK == null ? 1 : maxPK.Id + 1),
Name = _modueNameEntry.Text
};
db.Insert(mod);
await DisplayAlert("Alert", "Module : " + mod.Name + " Added", "OK");
await Navigation.PopAsync();
}
/// <summary>
/// Get all
/// </summary>
/// <returns></returns>
public IEnumerable <module> get_all()
{
List <module> listUser = new List <module>();
using (NpgsqlDBConnection db = new NpgsqlDBConnection())
{
try
{
if (db.open_connection())
{
string sql_command = "SELECT * FROM modules";
using (NpgsqlCommand cmd = db._conn.CreateCommand())
{
cmd.CommandText = sql_command;
NpgsqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
module obj = new module();
obj = (module)_get_info(reader);
listUser.Add(obj);
}
reader.Close();
db.close_connection();
return(listUser);
}
}
else
{
db.close_connection();
return(null);
}
}
catch
{
if (db != null)
{
db.close_connection();
}
return(null);
}
finally
{ db.close_connection(); }
}
}
private void ListViewItem_PreviewMouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
ListViewItem lbi = sender as ListViewItem;
if (lbi != null)
{
module fam = lbi.DataContext as module;
if (fam != null)
{
try
{
int moduleId = fam.moduleId;
main.Children.Clear();
main.Children.Add(new Module(moduleId));
}
catch { }
}
}
}
private IEnumerable <module> checkAndInsertModuleConfiguration()
{
using (module_repository _modules = new module_repository())
{
IEnumerable <module> moduleConfigList = _modules.get_all();
MODULE_CONFIG_LIST = moduleConfigList.Select(x => x.item_name).ToArray();
if (moduleConfigList.Count() == MODULE_CONFIG_LIST.Count())
{
return(moduleConfigList);
}
else
{
foreach (string itemModuleName in MODULE_CONFIG_LIST)
{
module objExistedModuleByName = _modules.get_info_by_name(itemModuleName);
if (objExistedModuleByName != null)
{
continue;
}
else
{
objExistedModuleByName = new module();
objExistedModuleByName.item_name = itemModuleName;
if (_modules.add(ref objExistedModuleByName) > 0)
{
// ok
}
else
{
// fail
MessageBox.Show(lang.getText("system_error"));
this.Close();
return(null);
}
}
}
moduleConfigList = _modules.get_all();
return(moduleConfigList);
}
}
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
Frame rootFrame = Window.Current.Content as Frame;
if (rootFrame.CanGoBack)
{
// Show UI in title bar if opted-in and in-app backstack is not empty.
SystemNavigationManager.GetForCurrentView().AppViewBackButtonVisibility =
AppViewBackButtonVisibility.Visible;
}
else
{
// Remove the UI from the title bar if in-app back stack is empty.
SystemNavigationManager.GetForCurrentView().AppViewBackButtonVisibility =
AppViewBackButtonVisibility.Collapsed;
}
module vm = e.Parameter as module;
if (vm != null)
{
if (vm.ifchecked1 == "true")
{
line.Visibility = Visibility.Visible;
check_box1.IsChecked = true;
}
else
{
line.Visibility = Visibility.Collapsed;
check_box1.IsChecked = false;
}
if (vm.ifchecked2 == "true")
{
line1.Visibility = Visibility.Visible;
check_box2.IsChecked = true;
}
else
{
line1.Visibility = Visibility.Collapsed;
check_box2.IsChecked = false;
}
}
}
public string Submit(module model)
{
try
{
var result = Bll.ModuleBll.Instance.Get(m => m.ID == model.ID);
if (model.ID == 0 || (model.ID > 0 && result.ModuleCode != model.ModuleCode))
{
var isHaveModel = Bll.ModuleBll.Instance.IsHaveModel(m => m.ModuleCode == model.ModuleCode);
if (isHaveModel)
{
return(JsonConvert.SerializeObject(new { data = false, url = "", msg = "已经有编号为" + model.ModuleCode + "的数据" }));
}
}
if (model.ID > 0)
{
result.Name = model.Name;
result.ModuleCode = model.ModuleCode;
result.Sort = model.Sort;
Bll.ModuleBll.Instance.Submit(result);
}
else
{
if (model.ParentId > 0)
{
var pModel = Bll.ModuleBll.Instance.Get(m => m.ID == model.ParentId);
pModel.IsGroup = true;
Bll.ModuleBll.Instance.Submit(pModel);
}
model.CreateTime = DateTime.Now;
Bll.ModuleBll.Instance.Submit(model);
}
}
catch (Exception)
{
return(JsonConvert.SerializeObject(new { data = false, url = "", msg = "保存出错" }));
}
var url = Url.Action("Index", new { projectCode = model.ProjectCode });
var isEdit = model.ID > 0;
return(JsonConvert.SerializeObject(new { data = true, url = url, msg = "保存成功", isEdit = isEdit }));
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
ViewModule.i = "EditPage";
ViewModule.Date_Time = DateTime.Today;
Frame rootFrame = Window.Current.Content as Frame;
if (rootFrame.CanGoBack)
{
// Show UI in title bar if opted-in and in-app backstack is not empty.
SystemNavigationManager.GetForCurrentView().AppViewBackButtonVisibility =
AppViewBackButtonVisibility.Visible;
}
else
{
// Remove the UI from the title bar if in-app back stack is empty.
SystemNavigationManager.GetForCurrentView().AppViewBackButtonVisibility =
AppViewBackButtonVisibility.Collapsed;
}
module m = e.Parameter as module;
if (m != null)
{
if (m.title != null)
{
title_block.Text = m.title;
}
if (m.detail != null)
{
detail_block.Text = m.detail;
}
if (m.Date_Time != null)
{
date.Date = m.Date_Time;
}
}
}
private void contextModule_Click(object sender, RoutedEventArgs e)
{
switch ((sender as MenuItem).Name)
{
case "deleteModule":
if (moduleID != 0)
{
db = new CoursesContext();
module modules = new module
{
moduleId = moduleID
};
db.module.Attach(modules);
db.module.Remove(modules);
db.SaveChanges();
StartProgramm(db.module.Select(p => p.moduleId).FirstOrDefault());
}
break;
case "editModule":
if (moduleID != 0)
{
main.Children.Clear();
main.Children.Add(new AddModule(moduleID));
}
break;
case "addModule":
main.Children.Clear();
main.Children.Add(new AddModule());
break;
default:
break;
}
}
public ActionResult DeleteConfirmed(int id)
{
//pirma istrinam moduliu sarysius su studentais
while (true)
{
studentModule studentModule = db.studentModules.Where(s => s.ModuleID == id).FirstOrDefault();
if (studentModule != null)
{
db.studentModules.Remove(studentModule);
db.SaveChanges();
}
else
{
break;
}
}
//tada istrinam modulio paskaitas
while (true)
{
lecture lecture = db.lectures.Where(s => s.ModuleID == id).FirstOrDefault();
if (lecture != null)
{
db.lectures.Remove(lecture);
db.SaveChanges();
}
else
{
break;
}
}
module module = db.modules.Find(id);
db.modules.Remove(module);
db.SaveChanges();
return(RedirectToAction("Index"));
}
select(
module : moduleProvider.GetOrDefault().module,
