private void CourseLoad(int uID)
{
coursesChoose.Items.Clear();
listCourses = new List <Course>();
try
{
DBA db = DBA.Instance;
db.connect();
var con = db.getConnection();
con.Open();
string query = "SELECT id, name, lecture_hours, practice_hours, lab_hours FROM course WHERE id IN(SELECT id_course FROM courseToTT WHERE id_user ="******" );";
using (SqlCommand cmd = new SqlCommand(query, con))
{
using (SqlDataReader r = cmd.ExecuteReader())
{
while (r.Read())
{
Course block = new Course(r.GetInt32(0), r.GetString(1), r.GetInt32(2), r.GetInt32(3), r.GetInt32(4));
listCourses.Add(block);
coursesChoose.Items.Add(block.ToString());
}
}
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message, "SQL Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void DBSave(int uID, bool all)
{
DBA db = DBA.Instance;
db.connect();
foreach (int key in dictSchedule[uID].Keys)
{
// delete previous
db.query("DELETE schedule Where user_id = " + uID + " AND course_id = " + key + " ");
string day = dictSchedule[uID][key].Day;
int user_id = dictSchedule[uID][key].User_id;
int class_id = dictSchedule[uID][key].Class_id;
int course_id = dictSchedule[uID][key].Course_id;
int start = dictSchedule[uID][key].Start;
int end = dictSchedule[uID][key].End;
string course_name = dictSchedule[uID][key].Course_name;
string class_name = dictSchedule[uID][key].Class_name;
string class_appoinment = start.ToString() + ":" + end.ToString() + ",";
db.query("INSERT INTO schedule (user_id,course_id, course_name, day, startH, endH, class_id, class_name) VALUES (" + user_id + ", '" + course_id + "', '" + course_name + "', '" + day + "', " + start + ", " + end + ", " + class_id + ", '" + class_name + "' )");
db.query("UPDATE classes SET [" + day.ToLower() + "]= [" + day.ToLower() + "] + '" + class_appoinment + "' WHERE id =" + class_id);
}
if (!(all))
{
MessageBox.Show("Data Saved");
}
}
public static void smethod_1()
{
int num = 0;
Form1.WriteLine(100, "删除人物仓库数据开始");
DataTable dBToDataTable = DBA.GetDBToDataTable(string.Format("select * from TBL_XWWL_warehouse", new object[0]));
if (dBToDataTable != null)
{
Form1.WriteLine(100, string.Concat("共有人物数据", dBToDataTable.Rows.Count));
for (int i = 0; i < dBToDataTable.Rows.Count; i++)
{
DataTable dataTable = DBA.GetDBToDataTable(string.Format("select * from TBL_XWWL_Char where FLD_NAME='{0}'", dBToDataTable.Rows[i]["FLD_NAME"]));
if (dataTable.Rows.Count < 1)
{
num++;
Form1.WriteLine(100, string.Concat(new object[] { "删除人物仓库[", dBToDataTable.Rows[i]["FLD_ID"].ToString(), "] [", dBToDataTable.Rows[i]["FLD_NAME"], "]" }));
DBA.ExeSqlCommand(string.Format("DELETE FROM TBL_XWWL_warehouse WHERE FLD_ID='{0}'and FLD_NAME ='{1}'", dBToDataTable.Rows[i]["FLD_ID"].ToString(), dBToDataTable.Rows[i]["FLD_NAME"].ToString()));
}
else if (dataTable.Rows[0]["FLD_ID"].ToString() != dBToDataTable.Rows[i]["FLD_ID"].ToString())
{
num++;
Form1.WriteLine(100, string.Concat(new object[] { "删除人物仓库[", dBToDataTable.Rows[i]["FLD_ID"].ToString(), "] [", dBToDataTable.Rows[i]["FLD_NAME"], "]" }));
DBA.ExeSqlCommand(string.Format("DELETE FROM TBL_XWWL_warehouse WHERE FLD_ID='{0}'and FLD_NAME ='{1}'", dBToDataTable.Rows[i]["FLD_ID"].ToString(), dBToDataTable.Rows[i]["FLD_NAME"].ToString()));
}
dataTable.Dispose();
}
dBToDataTable.Dispose();
}
Form1.WriteLine(100, string.Concat("删除人物仓库数据完成", num));
}
private bool isExistPrefers()
{
try
{
DBA db = DBA.Instance;
db.connect();
db.getConnection().Open();
string stm = "SELECT COUNT(*) FROM prefers WHERE id_user="******"";
SqlCommand cmd = new SqlCommand(stm, db.getConnection());
Int32 count = Convert.ToInt32(cmd.ExecuteScalar());
db.getConnection().Close();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
Console.Out.WriteLine("No Prefers");
return(false);
}
}
public NewCustomerWindow(ClientVM clientVM, DBA.Client client)
{
InitializeComponent();
_clientVM = clientVM;
this._client = client;
this.DataContext = client;
}
private List <int> CoursesCurrentUser(int id_user)
{
List <int> listCoursesId = new List <int>();
try
{
DBA db = DBA.Instance;
db.connect();
var con = db.getConnection();
con.Open();
string query = "SELECT id_course FROM courseToTT WHERE id_user = "******"";
using (SqlCommand cmd = new SqlCommand(query, con))
{
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
listCoursesId.Add((int)reader["id_course"]);
}
}
}
return(listCoursesId);
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message, "SQL Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(null);
}
}
public void getAllCourseOptions(int course_id, ComboBox opt)
{
try
{
DBA db = DBA.Instance;
db.connect();
var con = db.getConnection();
con.Open();
string query = "SELECT id, day, startH, endH, class_name FROM schedule WHERE course_id = " + course_id;
using (SqlCommand cmd = new SqlCommand(query, con))
{
using (SqlDataReader r = cmd.ExecuteReader())
{
while (r.Read())
{
string res = r.GetInt32(0).ToString() + "| => " + r.GetString(1) + " " + r.GetInt32(2).ToString() + " - " + r.GetInt32(3).ToString();
opt.Items.Add(res);
}
}
}
}
catch (SqlException ex)
{
Console.Out.WriteLine(ex.Message, "SQL Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public long AcquireBuffer()
{
long num;
using (Lock @lock = new Lock(this.object_0, "AcquireBuffer"))
{
if (this.long_0 >= this.long_1)
{
this.long_0 = long.Parse(DBA.GetDBValue_3("EXEC XWWL_GetItemSerial2 1000").ToString());
this.long_1 = this.long_0 + (long)1000;
long long0 = this.long_0;
long num1 = long0;
this.long_0 = long0 + (long)1;
num = num1;
}
else
{
long long01 = this.long_0;
long num2 = long01;
this.long_0 = long01 + (long)1;
num = num2;
}
}
return(num);
}
private void CourseUpdate(int uId)
{
List <ComboBox> addCourseList = new List <ComboBox>();
addCourseList.Add(c1);
addCourseList.Add(c2);
addCourseList.Add(c3);
addCourseList.Add(c4);
addCourseList.Add(c5);
DBA db = DBA.Instance;
db.connect();
db.query("DELETE courseToTT where id_user = "******"");
int ind = 0;
while (ind < 5)
{
if (addCourseList[ind].Text != "")
{
string course = addCourseList[ind].GetItemText(addCourseList[ind].SelectedItem);
course = course.Remove(course.Length - 1);
string[] course_data = course.Split('[');
int course_id = GlobalItems.strToInt(course_data[1]);
db.query("INSERT INTO courseToTT (id_user, id_course) VALUES (" + uId + ", " + course_id + ")");
}
ind++;
}
}
public int checkStudentId(string ID)
{
try
{
DBA db = DBA.Instance;
db.connect();
var con = db.getConnection();
con.Open();
string query = "SELECT id FROM users WHERE IdNUmber = '" + ID + "' AND type = 5 ";
using (SqlCommand cmd = new SqlCommand(query, con))
{
using (SqlDataReader r = cmd.ExecuteReader())
{
if (r.Read())
{
int cID = r.GetInt32(0);
return(cID);
}
return(-1);
}
}
}
catch (SqlException ex)
{
Console.Out.WriteLine(ex.Message, "SQL Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(-1);
}
}
private void CourseByUserLoad(int uID)
{
try
{
DBA db = DBA.Instance;
db.connect();
var con = db.getConnection();
con.Open();
string query = "SELECT id, name FROM course WHERE id IN(SELECT id_course FROM courseToTT WHERE id_user ="******" );";
using (SqlCommand cmd = new SqlCommand(query, con))
{
using (SqlDataReader r = cmd.ExecuteReader())
{
while (r.Read())
{
putInCourseList(r.GetString(1) + "[" + r.GetInt32(0) + "]");
}
}
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message, "SQL Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void studentScheduleOptions(int uID)
{
try
{
DBA db = DBA.Instance;
db.connect();
var con = db.getConnection();
con.Open();
string query = "SELECT id, day, startH, endH, class_name FROM schedule WHERE id IN(SELECT l_id FROM studentSchedule WHERE user_id =" + uID + " )";
using (SqlCommand cmd = new SqlCommand(query, con))
{
using (SqlDataReader r = cmd.ExecuteReader())
{
while (r.Read())
{
string res = r.GetInt32(0).ToString() + "| => " + r.GetString(1) + " " + r.GetInt32(2).ToString() + " - " + r.GetInt32(3).ToString();
putOptions(res);
}
}
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message, "SQL Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void CourseLoad()
{
try
{
DBA db = DBA.Instance;
db.connect();
var con = db.getConnection();
con.Open();
string query = "SELECT id, name FROM course";
using (SqlCommand cmd = new SqlCommand(query, con))
{
using (SqlDataReader r = cmd.ExecuteReader())
{
while (r.Read())
{
c1.Items.Add(r.GetString(1) + "[" + r.GetInt32(0) + "]");
c2.Items.Add(r.GetString(1) + "[" + r.GetInt32(0) + "]");
c3.Items.Add(r.GetString(1) + "[" + r.GetInt32(0) + "]");
c4.Items.Add(r.GetString(1) + "[" + r.GetInt32(0) + "]");
c5.Items.Add(r.GetString(1) + "[" + r.GetInt32(0) + "]");
}
}
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message, "SQL Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void addClass(string name, string maxPLaces, string type, int projector, int board)
{
DBA db = DBA.Instance;
db.connect();
db.query("INSERT INTO classes (name,maxPlaces,type,projector, board) VALUES ('" + name + "', '" + maxPLaces + "', '" + type + "', '" + projector + "', '" + board + "' )");
}
/// <summary>
/// 开启事务处理。
/// </summary>
/// <param name="il">事务锁定行为（即隔离级别）.</param>
/// <returns></returns>
public DBTransactionController BeginTrans(IsolationLevel?il = null)
{
if (DBA == null || CommandParserAdapter == null)
{
throw (new Exception("无法开启事务，因为尚未初始化 DBA 或 CommandParserAdapter 对象。"));
}
IDbConnection DbConnection = DBA.Connect();
//DbConnection.Open();
IDbTransaction Trans;
if (il == null)
{
Trans = DbConnection.BeginTransaction();
}
else
{
Trans = DbConnection.BeginTransaction(il.Value);
}
IDbCommand DbCommand = DBA.CreateDbCommand();
DbCommand.Connection = DbConnection;
DbCommand.Transaction = Trans;
TransactionDbAccess transDBA = new TransactionDbAccess(DbCommand, this);
DBTransactionController TransController = new DBTransactionController(Trans, transDBA, new ReleaseTransHandler(ReleaseTransaction));
TransactionConnectionCache.RegisterValidTransaction(TransController.UniqueId, DBA, DbConnection);
return(TransController);
}
public void addStudent(string fname, string lname, string email, string pass, string id, int type)
{
DBA db = DBA.Instance;
db.connect();
db.query("INSERT INTO users (fname, lname, email, password, idNUmber, type) VALUES ('" + fname + "', '" + lname + "', '" + email + "', '" + pass + "', '" + id + "', 5)");
}
public static void smethod_4()
{
int num = 0;
Form1.WriteLine(100, "删除帮派数据开始");
DataTable dBToDataTable = DBA.GetDBToDataTable(string.Format("select * from TBL_XWWL_GuildMember", new object[0]));
if (dBToDataTable != null)
{
Form1.WriteLine(100, string.Concat("共有帮派数据", dBToDataTable.Rows.Count));
for (int i = 0; i < dBToDataTable.Rows.Count; i++)
{
DataTable dataTable = DBA.GetDBToDataTable(string.Format("select * from TBL_XWWL_Char where FLD_NAME='{0}'", dBToDataTable.Rows[i]["Name"]));
if (dataTable.Rows.Count < 1)
{
num++;
if (dBToDataTable.Rows[0]["leve"].ToString() != "6")
{
Form1.WriteLine(100, string.Concat(new object[] { "删除帮派", dBToDataTable.Rows[i]["G_Name"], " ", dBToDataTable.Rows[i]["Name"].ToString() }));
DBA.ExeSqlCommand(string.Format("DELETE FROM TBL_XWWL_GuildMember WHERE Name ='{0}'", dBToDataTable.Rows[i]["Name"].ToString()));
}
else
{
Form1.WriteLine(100, string.Concat("删除帮派", dBToDataTable.Rows[i]["G_Name"]));
DBA.ExeSqlCommand(string.Format("DELETE FROM TBL_XWWL_Guild WHERE G_Name ='{0}'", dBToDataTable.Rows[0]["G_Name"].ToString()));
DBA.ExeSqlCommand(string.Format("DELETE FROM TBL_XWWL_GuildMember WHERE G_Name ='{0}'", dBToDataTable.Rows[0]["G_Name"].ToString()));
}
}
dataTable.Dispose();
}
dBToDataTable.Dispose();
}
Form1.WriteLine(100, string.Concat("删除帮派数据完成", num));
}
private void ScheduleLoad(int uID)
{
try
{
DBA db = DBA.Instance;
db.connect();
var con = db.getConnection();
con.Open();
string query = "SELECT * FROM schedule WHERE user_id = " + uID + "ORDER BY startH ASC";
using (SqlCommand cmd = new SqlCommand(query, con))
{
using (SqlDataReader r = cmd.ExecuteReader())
{
while (r.Read())
{
int cID = r.GetInt32(2);
string day = r.GetString(4);
string title = r.GetString(3) + " " + r.GetString(8);
string start = r.GetInt32(5).ToString() + ":00";
string end = r.GetInt32(6).ToString() + ":00";
ScheduleEvent block = new ScheduleEvent(r.GetInt32(1), r.GetInt32(2), r.GetString(3), r.GetString(4), r.GetInt32(5), r.GetInt32(6), r.GetInt32(7), r.GetString(8));
putInSchedule(block.Day, block.Class_name, block.Course_name, block.Start, block.End);
}
}
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message, "SQL Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public List <Entry> List()
{
DBA database = new DBA();
List <Entry> entriesList = database.GetEntries();
return(entriesList);
}
private void CoursesLoad()
{
List <Course> listCourses = new List <Course>();
try
{
DBA db = DBA.Instance;
db.connect();
var con = db.getConnection();
con.Open();
string query = "SELECT id,name FROM course";
using (SqlCommand cmd = new SqlCommand(query, con))
{
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
listCourses.Add(new Course((int)reader["id"], (string)reader["name"]));
}
}
}
foreach (Course c1 in listCourses)
{
courses_list.Items.Add(c1.Name + "[" + c1.Id.ToString() + "]");
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message, "SQL Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void deleteClass(string ID)
{
DBA db = DBA.Instance;
db.connect();
db.query("DELETE classes where id = " + ID + " ");
}
public void deleteStudent(string ID)
{
DBA db = DBA.Instance;
db.connect();
db.query("DELETE users where IdNUmber = '" + ID + "' and type = 5");
}
public void addCourse(string cName, int curCap, int maxCap, int cLecture, int cLecH, int cPractice, int cPH, int cLab, int cLabH, int id_dep, string course_description)
{
DBA db = DBA.Instance;
db.connect();
db.query("INSERT INTO course (name,capacity, maxCapacity, lecture, lecture_hours, practice, practice_hours, lab, lab_hours, id_department, description) VALUES ('" + cName + "', '" + curCap + "', '" + maxCap + "', '" + cLecture + "', '" + cLecH + "', '" + cPractice + "', '" + cPH + "', '" + cLab + "', '" + cLabH + "' , '" + id_dep + "', '" + course_description + "' )");
}
public static DataTable SELECT_TBL_XWWL_PublicWarehouse(string string_0)
{
string str = string.Format("select * from [TBL_XWWL_PublicWarehouse] where FLD_ID=@Userid", new object[0]);
DataTable dataTable = DBA.smethod_9(str, new SqlParameter[] { SqlDBA.MakeInParam("@Userid", SqlDbType.VarChar, 30, string_0) });
if (dataTable == null)
{
return(null);
}
if (dataTable.Rows.Count != 0)
{
return(dataTable);
}
Converter.smethod_25(new byte[4380]);
Converter.smethod_25(new byte[50]);
string str1 = string.Format("EXEC XWWL_CREATE_ID_BANK @Userid,@aaa,@ck,@ck1", new object[0]);
DBA.smethod_4(str1, new SqlParameter[] { SqlDBA.MakeInParam("@Userid", SqlDbType.VarChar, 30, string_0), SqlDBA.MakeInParam("@aaa", SqlDbType.Int, 0, 0), SqlDBA.MakeInParam("@ck", SqlDbType.VarBinary, 4380, new byte[4380]), SqlDBA.MakeInParam("@ck1", SqlDbType.VarBinary, 50, new byte[50]) });
string str2 = string.Format("select * from [TBL_XWWL_PublicWarehouse] where FLD_ID='{0}'", string_0);
DataTable dataTable1 = DBA.smethod_9(str2, new SqlParameter[] { SqlDBA.MakeInParam("@Userid", SqlDbType.VarChar, 30, string_0) });
if (dataTable1 == null)
{
return(null);
}
if (dataTable1.Rows.Count == 0)
{
return(null);
}
return(dataTable1);
}
public static DataTable SELECT_TBL_XWWL_Warehouse(string string_0, string string_1)
{
string str = string.Format("select * from [TBL_XWWL_Warehouse] where FLD_ID=@Userid and FLD_NAME =@Username", new object[0]);
DataTable dataTable = DBA.smethod_9(str, new SqlParameter[] { SqlDBA.MakeInParam("@Userid", SqlDbType.VarChar, 30, string_0), SqlDBA.MakeInParam("@Username", SqlDbType.VarChar, 30, string_1) });
if (dataTable == null)
{
return(null);
}
if (dataTable.Rows.Count != 0)
{
return(dataTable);
}
string str1 = string.Format("EXEC XWWL_CREATE_USER_BANK @Userid,@Username,@aa,@zb", new object[0]);
DBA.smethod_4(str1, new SqlParameter[] { SqlDBA.MakeInParam("@Userid", SqlDbType.VarChar, 30, string_0), SqlDBA.MakeInParam("@Username", SqlDbType.VarChar, 30, string_1), SqlDBA.MakeInParam("@aa", SqlDbType.Int, 0, 0), SqlDBA.MakeInParam("@zb", SqlDbType.VarBinary, 4380, new byte[4380]) });
string str2 = string.Format("select * from [TBL_XWWL_Warehouse] where FLD_ID=@Userid and FLD_NAME =@Username", new object[0]);
DataTable dataTable1 = DBA.smethod_9(str2, new SqlParameter[] { SqlDBA.MakeInParam("@Userid", SqlDbType.VarChar, 30, string_0), SqlDBA.MakeInParam("@Username", SqlDbType.VarChar, 30, string_1) });
if (dataTable1 == null)
{
return(null);
}
if (dataTable1.Rows.Count == 0)
{
return(null);
}
return(dataTable1);
}
private void DepartmentLoad()
{
List <Department> listDepartment = new List <Department>();
try
{
DBA db = DBA.Instance;
db.connect();
var con = db.getConnection();
con.Open();
string query = "SELECT id,name FROM departments ORDER BY id DESC";
using (SqlCommand cmd = new SqlCommand(query, con))
{
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
listDepartment.Add(new Department((int)reader["id"], (string)reader["name"]));
}
}
}
foreach (Department d1 in listDepartment)
{
departmentBox.Items.Add(d1.Name + "[" + d1.Id.ToString() + "]");
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message, "SQL Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static byte[] Select_Mon_Huy(int int_0)
{
byte[] numArray;
try
{
DataTable dBToDataTable = DBA.GetDBToDataTable(string.Format("SELECT * FROM TBL_XWWL_Guild WHERE ID = {0}", int_0));
if (dBToDataTable.Rows.Count != 0)
{
if (dBToDataTable.Rows[0]["Mon_huy"].GetType().ToString() != "System.DBNull")
{
byte[] item = (byte[])dBToDataTable.Rows[0]["Mon_huy"];
if (item != null)
{
numArray = item;
return(numArray);
}
}
else
{
numArray = null;
return(numArray);
}
}
numArray = null;
}
catch (Exception exception)
{
Console.WriteLine(exception);
numArray = null;
}
return(numArray);
}
private void DataLoad()
{
try
{
name.Text = "";
IdNum.Text = "";
DBA db = DBA.Instance;
db.connect();
db.getConnection().Open();
var select = "SELECT * FROM departments ORDER by id DESC";
var dataAdapter = new SqlDataAdapter(select, db.getConnection());
var commandBuilder = new SqlCommandBuilder(dataAdapter);
var ds = new DataSet();
dataAdapter.Fill(ds);
dataGridView1.ReadOnly = true;
dataGridView1.DataSource = ds.Tables[0];
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message, "SQL Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private bool checkUnique()
{
if (IdNumber.Text.Trim() == null || IdNumber.Text.Trim() == "")
{
return(true);
}
string ID = IdNumber.Text.Trim();
try
{
DBA db = DBA.Instance;
db.connect();
var conn = db.getConnection();
conn.Open();
//var select = "SELECT * FROM course";
SqlCommand comm = new SqlCommand("SELECT COUNT(*) FROM course WHERE id = " + ID + " ", conn);
Int32 count = (Int32)comm.ExecuteScalar();
Console.WriteLine(count);
if (count > 0)
{
return(false);
}
return(true);
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message, "SQL Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
public void DeleteCourse(string ID)
{
DBA db = DBA.Instance;
db.connect();
db.query("DELETE course where id = " + ID + " ");
}
private void save_courses_Click(object sender, EventArgs e)
{
int id_user = Int32.Parse(id.Text);
int cId;
DBA db = DBA.Instance;
db.connect();
// delete previous link courses to teacher/tutor
Console.WriteLine(id_user.ToString());
db.query("DELETE courseToTT where id_user = "******"");
var pattern = @"\[(.*?)\]";
for (int i = 0; i < courses_list.Items.Count; i++)
{
if (courses_list.GetItemChecked(i))
{
string str = (string)courses_list.Items[i];
var matches = Regex.Matches(str, pattern);
foreach (Match m in matches)
{
cId = Int32.Parse(m.Groups[1].ToString());
db.query("INSERT INTO courseToTT (id_user, id_course) VALUES (" + id_user + ", " + cId + ")");
Console.WriteLine(cId.ToString());
}
}
}
}
public SContact(DBA.Baas.JagatudContact scont)
{
this._id = scont.ID;
this._userID = scont.UserID;
this._contactID = scont.ContactID;
this._algusKP = scont.AlgusKP;
this._loppKP = scont.LoppKP.GetValueOrDefault();
}
public NewMovieWindow(MoviesVM moviesVM, DBA.Movie movie)
{
InitializeComponent();
this._moviesVM = moviesVM;
this._movie = movie;
this.DataContext = movie;
}
public void saveUser(DBA.User user)
{
if (user.id == 0)
{
_dataContext.Users.InsertOnSubmit(user);
}
_dataContext.SubmitChanges();
}
/// <summary>
/// kasutaja salvestamine
/// </summary>
/// <param name="user">kasutaja</param>
public void saveUser(DBA.User user)
{
//kui kasutajat pole, siis tekitakse, vastasel juhul aga muudetakse
if (user.id == 0)
{
_dataContext.Users.InsertOnSubmit(user);
}
_dataContext.SubmitChanges();
}
public void saveClient(DBA.Client clientTO)
{
_dataContext.Clients.InsertOnSubmit(clientTO);
_dataContext.SubmitChanges();
if (_clientList == null)
{
_clientList = new ObservableClients(_dataContext);
}
_clientList.Add(clientTO);
}
public void saveMovie(DBA.Movie movie)
{
_dataContext.Movies.InsertOnSubmit(movie);
_dataContext.SubmitChanges();
if (_moviesList == null)
{
_moviesList = new ObservableMovies(_dataContext);
}
_moviesList.Add(movie);
}
public void deleteMovie(DBA.Movie movie)
{
if (movie.Rentals == null || movie.Rentals.Count < 1)
{
_dataContext.Movies.DeleteOnSubmit(movie);
_dataContext.SubmitChanges();
_moviesList.Remove(movie);
}
else
{
throw new InvalidOperationException("Film(id) on välja laenatud! Välja laentatud filmi ei saa kustutada!");
}
}
public Contact(DBA.Baas.Contact cont)
{
this._id = cont.ID;
this._firstName = cont.Eesnimi;
this._lastName = cont.Perenimi;
this._tel = cont.Telefon;
this._email = cont.E_mail;
this._skype = cont.Skype;
this._address = cont.Aadress;
this.Loodud = cont.Loodud;
this.Muudetud = cont.Muudetud.GetValueOrDefault();
this.Kustutatud = cont.Kustutatud.GetValueOrDefault();
}
/// <summary>
/// lõpetab laenutuse, määratakse tagastamise kuupäev
/// </summary>
/// <param name="item"></param>
public void returnedRental(DBA.Rental item)
{
if (item.ReturnedDate == null)
{
item.ReturnedDate = DateTime.Now;
}
else
{
item.ReturnedDate = null;
}
_dataContext.SubmitChanges();
}
public AddRentalWindow(RentalsVM rentalsVM, ClientVM clientVM, MoviesVM moviesVM, DBA.Rental rental)
{
InitializeComponent();
this._rentalsVM = rentalsVM;
this._clientVM = clientVM;
this._moviesVM = moviesVM;
this._rental = rental;
cboxClient.ItemsSource = _clientVM.getClients();
listBoxMovies.ItemsSource = _moviesVM.getMovies();
InitializeComponent();
_rental = rental;
this.DataContext = _rental;
}
/// <summary>
/// salvestame laenutuse baasi ja mällu
/// </summary>
/// <param name="_rental"></param>
internal void saveOrUpdateRental(DBA.Rental _rental)
{
bool save = false;
if (_rental.id == 0)
{
_dataContext.Rentals.InsertOnSubmit(_rental);
save = true;
}
_dataContext.SubmitChanges();
if (save)
{
_rentalsList.Add(_rental);
}
}
public void Load()
{
DBObject dba = new DBObject();
dba.Init(this);
_DBA = dba;
//DFAccess dfa = new DFAccess();
//dfa.Init(this);
//_DFA = dfa;
_Timer = new Timer(new TimerCallback(Timer_Callback), null, 5000, 1000);
}
internal void updateClient(DBA.Client _client)
{
_dataContext.SubmitChanges();
}
public ClientVM(DBA.LINQtoSQLclassesDataContext dataContext)
{
_dataContext = dataContext;
}
public void mapToDbContact(DBA.Baas.Contact kont)
{
kont.ID = this._id;
kont.Eesnimi = this.FirstName;
kont.Perenimi = this.LastName;
kont.Aadress = this.Address;
kont.E_mail = this.Email;
kont.Skype = this.Skype;
kont.Telefon = this.Tel;
kont.Loodud = this.Loodud;
kont.Muudetud = this.Muudetud;
kont.Kustutatud = this.Kustutatud;
kont.User_fk = this.Userfk;
}
public MoviesVM(DBA.LINQtoSQLclassesDataContext dataContext)
{
_dataContext = dataContext;
}
public void updateMovie(DBA.Movie movie)
{
_dataContext.SubmitChanges();
}
public void deleteClient(DBA.Client _client)
{
//kui laenutusi ei ole, siis kustutame
if (_client.Rentals == null || _client.Rentals.Count < 1)
{
_dataContext.Clients.DeleteOnSubmit(_client);
_dataContext.SubmitChanges();
_clientList.Remove(_client);
}
else
{
throw new InvalidOperationException("Klient on seotud laenututega! Kustutamine ei ole võimalik!");
}
}
public UserVM(DBA.LINQtoSQLclassesDataContext dataContext)
{
_dataContext = dataContext;
}
public RentalsVM(DBA.LINQtoSQLclassesDataContext dataContext)
{
_dataContext = dataContext;
}
public void Init()
{
_DbEngine = new ODBEngine();
_DbEngine.DbInit(_UserModel);
UdcList = new List<Udc>();
UdcList.Add(new Udc { IsSys = true, Id = "AUDC000000000001", Name = "仅数字", Tips = "仅数字", Data = "0123456789" });
UdcList.Add(new Udc { IsSys = true, Id = "AUDC000000000002", Name = "大写字母", Tips = "大写字母", Data = "ABCDEFGHIJKLMNOPQRSTUVWXYZ" });
UdcList.Add(new Udc { IsSys = true, Id = "AUDC000000000003", Name = "小写字母", Tips = "小写字母", Data = "abcdefghijklmnopqrstuvwxyz" });
UdcList.Add(new Udc { IsSys = true, Id = "AUDC000000000004", Name = "大小写字母", Tips = "大小写字母", Data = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz" });
UdcList.Add(new Udc { IsSys = true, Id = "AUDC000000000005", Name = "数字及字母", Tips = "数字及字母", Data = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz" });
UdcList.Add(new Udc { IsSys = true, Id = "AUDC000000000006", Name = "可输入英文符号", Tips = "可输入英文符号", Data = "!\"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\\]^_`abcdefghijklmnopqrstuvwxyz{|}~" });
foreach (Udc udc in _DbEngine.Query<Udc>())
{
UdcList.Add(udc);
}
string _UdcKey = "AUDC000000000005";
foreach (Udc item in UdcList)
{
if (item.Id == _UdcKey)
{
DefaultUdc = item;
}
}
UdcModified = 0x7FFFFFFF;
}
public Contact(DBA.Baas.Contact cont)
{
this._id = cont.ID;
this._firstName = cont.Eesnimi;
this._lastName = cont.Perenimi;
this._tel = cont.Telefon;
this._email = cont.E_mail;
this._skype = cont.Skype;
this._address = cont.Aadress;
this.Loodud = cont.Loodud;
if (cont.Muudetud == DateTime.MinValue)
{
this.Muudetud = null;
}
else
{
this.Muudetud = cont.Muudetud;
}
if (cont.Kustutatud == DateTime.MinValue)
{
this.Kustutatud = null;
}
else
{
this.Kustutatud = cont.Kustutatud;
}
this.Userfk = cont.User_fk;
}
