public JsonResult UploadPersonPhotoFile(HttpPostedFileBase File, long memberId)
{
if (File != null && File.ContentLength > 0)
{
string Path = string.Format("{0}/{1}", GetItem.UpdPath(), "Manager");
if (!System.IO.Directory.Exists(Path))
{
System.IO.Directory.CreateDirectory(Path);
}
string saveName = WorkV3.Golbal.UpdFileInfo.SaveFiles(File, Path);
if (memberId != 0)
{
MemberModels mem = MemberDAO.GetItem(memberId);
string sql = "UPDATE Member SET Img=@Img WHERE LoginID=@ID";
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.ParameterCollection paraList = new SQLData.ParameterCollection();
paraList.Add("@ID", mem.LoginID);
paraList.Add("@Img", saveName);
int exeCount = db.ExecuteNonQuery(sql, paraList);
}
}
return(Json("success"));
}
public MemberBUS(MainBUS main)
{
this.mainBus = main;
this.memberDAO = new MemberDAO(this.mainBus.GetCommand());
this.jobDAO = new JobDAO(this.mainBus.GetCommand());
this.data = this.memberDAO.getAllMember();
}
protected void btnSignin_Click(object sender, EventArgs e)
{
txtusername_password.Text = "";
MemberDAO member = new MemberDAO();
int memberid = Convert.ToInt32(member.GetMemberByChecklogin(txtUserName.Text.Trim(), Encrypt(txtPassword.Text.Trim())));
switch (memberid)
{
case -1:
txtusername_password.Text = "Username and/or password is incorrect.";
break;
case -2:
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModalwebsite", "$('#myModalwebsite').modal();", true);
break;
case -3:
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModalFingerprint", "$('#myModalFingerprint').modal();", true);
break;
default:
Checkstatus(memberid);
break;
}
}
private void MainForm_Load(object sender, EventArgs e)
{
allMembers = MemberDAO.getAll();
member member = MemberDAO.getById(loggedInUser.member_id);
lblLogedUser.Text = member.first_name + " " + member.last_name;
comboBoxMemberLogin.Items.AddRange(allMembers.ToArray());
userMemberCheckIn();
populateAttendaceList();
//AutoCompleteStringCollection MyCollection = new AutoCompleteStringCollection();
//MyCollection.AddRange(MemberDAO.getAllBasicInfo().ToArray());
//comboBoxMemberLogin.AutoCompleteCustomSource = MyCollection;
calendarAttendance.MaxDate = DateTime.Now;
dateTimePickerReportDateFrom.MaxDate = DateTime.Now;
dateTimePickerReportDateTo.MaxDate = DateTime.Now;
dateTimePickerEducationLevelExamDate.MaxDate = DateTime.Now;
//You can pay for the month three days before
var payingMonth = DateTime.Now.AddDays(3).Month;
var payingYear = DateTime.Now.AddDays(3).Year;
comboBoxMonthMembershipFee.Items.Add(((months)payingMonth).ToString());
comboBoxMonthMembershipFee.SelectedIndex = 0;
comboBoxYearMembershipFee.Items.Add(payingYear);
comboBoxYearMembershipFee.SelectedIndex = 0;
comboBoxReportCategory.Items.Add("Članovi");
comboBoxReportCategory.Items.Add("Oprema");
comboBoxReportCategory.Items.Add("Finansije");
comboBoxReportCategory.SelectedIndex = 0;
}
private void btnCheckMember_Click(object sender, EventArgs e)
{
if (txtMemberCode.Text != "")
{
if (MemberDAO.CheckMember(int.Parse(txtMemberCode.Text)))
{
Member m = MemberDAO.GetMember(int.Parse(txtMemberCode.Text));
view(m.MemberNumber);
txtPhone.Text = m.Telephone;
txtName.Text = m.Name;
txtEmail.Text = m.Email;
}
else
{
txtName.Text = "";
txtPhone.Text = "";
txtEmail.Text = "";
txtMemberCode.Text = "";
dgvBorrowedBooks.DataSource = new DataTable();
numBorrowedBooks.Text = "0";
MessageBox.Show("Member Code is invalid.");
}
}
else
{
MessageBox.Show("Member Code can not be blank.");
}
}
protected void bthOKSave_Click(object sender, EventArgs e)
{
int memberuserid = Convert.ToInt32(this.DecryptQueryString("userid").ToString());
UserDAO user = new UserDAO();
MemberDAO member = new MemberDAO();
UserScanDAO userscan = new UserScanDAO();
DataTable dt = new SchoolAddressDAO().GetSchoolAddressByDetailaddress(txtshcool.Text.Trim());
if (dt.Rows.Count > 0)
{
int schoolid = Convert.ToInt32(dt.Rows[0]["school_id"].ToString());
user.UpdateUserByMember(memberuserid, schoolid, txtid.Text.Trim(), txtfullname.Text.Trim(), txtfullnameparent.Text.Trim(),
txttel.Text.Trim(), txtemail.Text.Trim());
//if(chkactive.Checked==false)
//{
// member.UpdateMemberByIsactive(memberuserid, chkactive.Checked);
// userscan.UpdateUserScanByActivescan(memberuserid, false);
//}
//else
//{
// member.UpdateMemberByIsactive(memberuserid, chkactive.Checked);
// userscan.UpdateUserScanByActivescan(memberuserid, chkactivescan.Checked);
//}
userscan.UpdateUserScanByActivescan(memberuserid, chkactivescan.Checked);
BindDataUser();
}
}
private void Checkstatus(int memberid)
{
DataTable dt = new MemberDAO().GetMember(memberid);
if (dt.Rows.Count > 0)
{
string status = dt.Rows[0]["createdby"].ToString();
if (status == "Driver")
{
int memberUserid = Convert.ToInt32(ViewState["memberUser_id"].ToString());
UserScanDAO userscan = new UserScanDAO();
userscan.AddUserScanByIDMember(memberUserid, "ไม่ได้ลงทะบียนสแกน", "ไม่ได้ลงทะบียนสแกน", 0, 0, 0, datetime(), false, 0, "");
Response.Redirect("../Driver/FingerPrintscan.aspx" +
this.EncryptQueryString("userid=" + memberUserid + "&driverid=" + memberid));
//cookiesdatauseranddriver(memberUser, memberid);
}
else if (status == "User")
{
txtusername_password.Text = "Username and/or password is incorrect.";
}
}
}
private void btnCheckMember_Click(object sender, EventArgs e)
{
if (txtMemberCode.Text != "")
{
btnBorrow.Enabled = false;
txtCopyNumber.Text = "";
if (MemberDAO.CheckMember(int.Parse(txtMemberCode.Text)))
{
Member m = MemberDAO.GetMember(int.Parse(txtMemberCode.Text));
if (MemberDAO.GetBorrowedBooks(m.MemberNumber).Rows.Count < 5)
{
view(m.MemberNumber);
display(1);
txtMemberName.Text = m.Name;
txtEmail.Text = m.Email;
}
else
{
display(0);
MessageBox.Show("The number of borrowed books is 5. You can not borrow anymore book.");
}
}
else
{
display(0);
MessageBox.Show("Member Code is invalid.");
}
}
else
{
MessageBox.Show("Member Code can not be blank.");
}
}
protected void btnChange_Click(object sender, EventArgs e)
{
MemberDTO member = (MemberDTO)Session["MEMBER_USER"];
string username = member.Username;
string oldPass = txtOldPass.Text;
MemberDAO dao = new MemberDAO();
if (!dao.CheckPassword(username, oldPass))
{
string message = "Password is not correct.";
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + message + "');", true);
this.txtOldPass.Focus();
return;
}
string newPass = txtNewPass.Text;
if (dao.ChangePass(username, newPass))
{
string message = "Password changed SUCCESSFULLY.";
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + message + "');", true);
}
else
{
Response.Redirect("../ErrorPages/ErrorPage.aspx");
}
}
private void setMemberdata(string id, string pw, string membername, MemberDAO memberDAO)
{
MainCT.member.memberno = int.Parse(memberDAO.findMemberno(id, pw));
MainCT.member.memberid = id;
MainCT.member.memberpw = pw;
MainCT.member.membername = membername;
}
public IHttpActionResult Put(Member todo)
{
if (MemberDAO.Update(todo))
{
return(Ok());
}
return(BadRequest());
}
public void ChangePassword(long memberId, string password)
{
MemberModels member = MemberDAO.GetItem(memberId);
member.Password = password;
ManagerDAO.SetItem(member);
}
public IHttpActionResult Delete(int id)
{
if (MemberDAO.Delete(id))
{
return(Ok());
}
return(BadRequest());
}
protected void GridViewMember_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "DeleteRow")
{
int memberID = int.Parse(e.CommandArgument.ToString());
MemberDAO.DeleteMember(memberID);
GridViewMember.DataBind();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
Member m = new Member();
m.MemberNumber = Convert.ToInt32(txtMemberCode.Text);
MemberDAO.Delete(m);
dgvMember.DataSource = MemberDAO.GetDataTable();
MessageBox.Show("Delete Successful");
display(0);
}
protected void ButtonAdd_Click(object sender, EventArgs e)
{
string name = TextBoxName.Text.Trim();
string sex = TextBoxSex.Text.Trim();
string address = TextBoxAddress.Text.Trim();
string phone = TextBoxPhone.Text.Trim();
string email = TextBoxEmail.Text.Trim();
MemberDAO.InsertMember(name, sex, address, phone, email);
GridViewMember.DataBind();
}
protected void bthOKSave_Click(object sender, EventArgs e)
{
int memberUserid = Convert.ToInt32(ViewState["memberUser_id"].ToString());
MemberDAO Member = new MemberDAO();
UserScanDAO userscan = new UserScanDAO();
Member.UpdateMemberByIsactive(memberUserid, true);
userscan.AddUserScanByIDMember(memberUserid, "ไม่ได้ลงทะบียนสแกน", "ไม่ได้ลงทะบียนสแกน", 0, 0, 0, datetime(), false, 0, "");
Response.Redirect("../Login.aspx");
}
public int checkPasswordSimilarity(long memberId, string password)
{
IEnumerable <string> siteSns = WorkV3.Models.DataAccess.SitesDAO.GetDatas().Select(x => x.SN);
string strSites = String.Join("|", WorkV3.Models.DataAccess.SitesDAO.GetDatas().Select(x => x.SN).ToArray());
MemberModels member = MemberDAO.GetItem(memberId);
string pattern = $@"^(?i:({strSites}))(?:20[0-9]{{2}})$";
Regex regex = new Regex(pattern);
bool retValue = regex.Match(password).Success;
return(retValue ? 1 : 0);
}
private void FrmMember_Load(object sender, EventArgs e)
{
try
{
memberDAO = new MemberDAO(Setting.connString);
this.tbNoMember.Text =
memberDAO.GetNomorTransaksiBerikutnya();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void dgvMember_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
DataGridView dgv = (DataGridView)sender;
if (dgv.Columns[e.ColumnIndex] is DataGridViewButtonColumn && e.RowIndex >= 0)
{
RenewGUI f = new RenewGUI(int.Parse(dgvMember.Rows[e.RowIndex].Cells["memberNumber"].Value.ToString()));
if (f.ShowDialog() == DialogResult.OK)
{
dgvMember.DataSource = MemberDAO.GetDataTable();
}
}
}
public JsonResult CheckSessionValid()
{
var Member = Request.Cookies["sessionId"] != null?MemberDAO.Current(Request.Cookies["sessionId"].Value) : null;
if (Member == null)
//string sessionID = Request.Cookies["sessionId"].Value;
//if (Session[sessionID] == null)
{
return(Json("no"));
}
else
{
return(Json("yes"));
}
}
public RegisterMember()
{
check = 0;
InitializeComponent();
dgvMember.DataSource = MemberDAO.GetDataTable();
DataGridViewButtonColumn button = new DataGridViewButtonColumn();
button.Name = "btnView";
button.HeaderText = "View";
button.Text = "View";
button.UseColumnTextForButtonValue = true; //dont forget this line
this.dgvMember.Columns.Add(button);
dgvMember.Columns["btnView"].DisplayIndex = dgvMember.ColumnCount - 1;
display(0);
}
protected void btnRegister_Click(object sender, EventArgs e)
{
MemberDAO dao = new MemberDAO();
string username = txtUsername.Text.Trim();
if (dao.IsUsernameExist(username))
{
string message = "Username already exists.\\nPlease choose a different username.";
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + message + "');", true);
this.txtUsername.ForeColor = System.Drawing.Color.Red;
this.txtUsername.Focus();
return;
}
string password = txtPass.Text.Trim();
string phone = txtPhone.Text.Trim();
string firstname = txtFirstName.Text.Trim();
string lastname = txtLastName.Text.Trim();
string email = txtEmail.Text.Trim();
string picture = txtPicture.Value;
int day = int.Parse(dlDay.Text);
int month = int.Parse(dlMonth.Text);
int year = int.Parse(dlYear.Text);
DateTime birthday = new DateTime(year, month, day);
MemberDTO member = new MemberDTO
{
Username = username,
Password = password,
PhoneNum = phone,
FirstName = firstname,
LastName = lastname,
Email = email,
ImageLink = picture,
IsActive = true,
Birthdate = birthday,
};
bool result = dao.AddNewMemberAdmin(member);
if (result)
{
string message = "Regiter SUCCESSFULLY.\\nPlease login to continue.";
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + message + "');", true);
}
else
{
Response.Redirect("../ErrorPages/ErrorPage.aspx");
}
}
private void BindDataMember()
{
MemberDAO member = new MemberDAO();
int memberid = Convert.ToInt32(member.AddMember(txtusername.Text.Trim(), Encrypt(txtpassword.Text.Trim()), "Driver", 1, true));
switch (memberid)
{
case -1:
labusername.Text = "Username already exists";
break;
default:
BindDataDriver(memberid);
break;
}
}
public ActionResult mySites()
{
ViewBag.Member = Request.Cookies["sessionId"] != null?MemberDAO.Current(Request.Cookies["sessionId"].Value) : null;
if (ViewBag.Member != null)
{
List <WorkV3.Models.SitesModels> mm = WorkV3.Models.DataAccess.SitesDAO.GetDatas();
var backendMenu = BackendMenuDAO.GetManagerRoots().ToList();
ViewBag.BackendMenu = backendMenu;
return(View(mm));
}
else
{
Response.Redirect(Url.Action("Login"));
return(View());
}
}
[HttpPost] //Phần này thêm, sửa thành viên nè
public ActionResult Account_Manage(Member member)
{
if (ModelState.IsValid)
{
string action = Request["action"];
if (action.Equals("edit"))
{
string email_temp = Request["email_temp"];
if (!email_temp.Equals(member.Email) &&
CheckObjExists.IsExist(USER_TABLE, USER_EMAIL, member.Email))
{
Session.Add("dia-log", "errThất Bại! Email " + member.Email + " đã tồn tại.");
}
else if (MemberDAO.EditMember(member))
{
Session.Add("dia-log", "sucSửa Thành Công");
}
}
else if (action.Equals("add"))
{
if (!CheckObjExists.IsExist(USER_TABLE, USER_AC, member.UserName) &&
!CheckObjExists.IsExist(USER_TABLE, USER_EMAIL, member.Email))
{
if (MemberDAO.AddMember(member))
{
Session.Add("dia-log", "sucThêm mới tài khoản thành Công");
}
}
else
{
Session.Add("member", member);
if (CheckObjExists.IsExist(USER_TABLE, USER_AC, member.UserName))
{
Session.Add("dia-log", "errThất Bại! Tài khoản " + member.UserName + " đã tồn tại.");
}
else
{
Session.Add("dia-log", "errThất Bại! Email " + member.Email + " đã tồn tại.");
}
}
}
}
return(RedirectToAction("Account_Manage"));
}
public void client_MqttMsgPublishRecieved(object sender, MqttMsgPublishEventArgs e)
{
//string status_fingerprint = Encoding.UTF8.GetString(e.Message); // รับ message จากตัวสแกนลายนิ้วมือ ok กับ fail
// Debug.WriteLine("Received = " + Encoding.UTF8.GetString(e.Message) + "\ron topic = " + e.Topic);
string topiocmessage = ViewState["topicmessage"].ToString();
if (e.Topic == topiocmessage)
{
int memberuserid = Convert.ToInt32(ViewState["MemberUser_id"].ToString());
int memberdriverid = Convert.ToInt32(ViewState["MemberDriver_id"].ToString());
string status_fingerprint = Encoding.UTF8.GetString(e.Message); // รับ message จากตัวสแกนลายนิ้วมือ ok กับ fail
DataTable dt = new DriverDAO().GetDriverByIDMember(memberdriverid); // รับชื่อของคนขับรถที่เป็นร่วม
if (status_fingerprint == "ok")
{
if (dt.Rows.Count > 0)
{
Debug.WriteLine("Received = " + Encoding.UTF8.GetString(e.Message) + "\ron topic = " + e.Topic + "\rMemberuserid = " + memberuserid);
string fullnamedriver = dt.Rows[0]["fullname"].ToString();
status = status_fingerprint; // ส่ง ok กับ fail
//..................... ทำการเพิ่มลายนิ้วมือลงไป database .......................//
UserScanDAO Userscan = new UserScanDAO();
Userscan.UpdateUserScanByMember(memberuserid, "ยังไม่ได้สแกน", "ยังไม่ได้สแกน", fullnamedriver, true, 1, datetime());
//..................... เปิกการใช้งานของ user ................................//
MemberDAO Member = new MemberDAO();
Member.UpdateMemberByIsactive(memberuserid, true);
Member.UpdateMemberByRegister(memberuserid, 3);
client_Addscan.Disconnect(); // Disconnect mqtt
}
}
else if (status_fingerprint == "fail")
{
status = status_fingerprint; // ส่ง ok กับ fail
client_Addscan.Disconnect();
}
else if (status_fingerprint == "disconnect")
{
client_Addscan.Disconnect();
}
}
}
private void userMemberCheckIn()
{
DateTime today = DateTime.Now;
Boolean CheckedInForCurrentDate =
AttendanceDAO.isAlreadyCheckedIn(loggedInUser.member_id, today.Day, today.Month, today.Year);
if (!CheckedInForCurrentDate)
{
var user_member = MemberDAO.getById(loggedInUser.member_id); //UBACITI POLJE TrUE za placen dolazak
var newAttendance = new attendance()
{
member_id = user_member.member_id,
check_in_time = DateTime.Now,
is_staff = true
};
AttendanceDAO.insert(newAttendance);
}
}
private void btnDangNhap_Click(object sender, EventArgs e)
{
String userName = txtTenDN.Text.Trim();
String password = txtMatKhau.Text.Trim();
MemberModel memberModel = MemberDAO.getAdminByUserNameNPass(userName, password);
if (memberModel != null)
{
Constants.USER_LOGIN = memberModel;
this.Hide();
new FormMain().Show();
}
else
{
MessageBox.Show(this, "Đăng Nhập Thất Bại !", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
protected void btnEdit_Click(object sender, EventArgs e)
{
labcheckscan.Visible = false;
chkactivescan.Enabled = true;
imgcheckscan.Visible = false;
int memberuserid = Convert.ToInt32(this.DecryptQueryString("userid").ToString());
DataTable dt = new UserDAO().GetUserSelectJointbSchooladdress_ByIDMember(memberuserid);
DataTable dtmember = new MemberDAO().GetMember(memberuserid);
DataTable dtuserscan = new UserScanDAO().GetUserScanByIDMember(memberuserid);
if (dt.Rows.Count > 0 && dtmember.Rows.Count > 0 && dtuserscan.Rows.Count > 0)
{
txtid.Text = dt.Rows[0]["id"].ToString();
txtfullname.Text = dt.Rows[0]["fullname"].ToString();
txtshcool.Text = dt.Rows[0]["detailaddress"].ToString();
BindDataschool();
txtfullnameparent.Text = dt.Rows[0]["fullnameparent"].ToString();
txttel.Text = dt.Rows[0]["tel"].ToString();
txtemail.Text = dt.Rows[0]["email"].ToString();
string checkscan = dtuserscan.Rows[0]["checkscan"].ToString();
if (checkscan == "0")
{
labcheckscan.Visible = true;
// chkactive.Enabled = false;
chkactivescan.Enabled = false;
imgcheckscan.ImageUrl = "~/Images/ajax_loader_gray_48.gif";
imgcheckscan.Visible = true;
imgcheckscan.Width = 20;
imgcheckscan.Height = 20;
// chkactive.Checked = (bool)dtmember.Rows[0]["is_active"];
chkactivescan.Checked = (bool)dtuserscan.Rows[0]["activescan"];
}
else if (checkscan == "1")
{
//chkactive.Checked = (bool)dtmember.Rows[0]["is_active"];
chkactivescan.Checked = (bool)dtuserscan.Rows[0]["activescan"];
}
}
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModaledituser", "$('#myModaledituser').modal();", true);
}
