internal MEMBER GetById(int id)
{
MEMBER member = new MEMBER();
using (con = new SqlConnection(connectionString))
{
string sqlQuery = @"SELECT TMEMBER.*, TSTATE.NAME AS STATE_NAME FROM TMEMBER INNER JOIN TSTATE ON TSTATE.ID = TMEMBER.STATE_ID
WHERE TMEMBER.ID=@ID";
using (SqlCommand cmd = new SqlCommand(sqlQuery, con))
{
con.Open();
cmd.Parameters.AddWithValue("@ID", id);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
member.ID = (int)reader["ID"];
member.NAME = (string)reader["NAME"];
member.TITLE = (string)reader["TITLE"];
member.DESCRIPTION = (string)reader["DESCRIPTION"];
member.IMAGE = (string)reader["IMAGE"];
member.TWITTER = (string)reader["TWITTER"];
member.INSTAGRAM = (string)reader["INSTAGRAM"];
member.FACEBOOK = (string)reader["FACEBOOK"];
member.STATE_ID = (int)reader["STATE_ID"];
member.STATE_NAME = (string)reader["STATE_NAME"];
}
con.Close();
}
}
return(member);
}
internal void Insert(MEMBER member)
{
using (con = new SqlConnection(connectionString))
{
string sqlQuery = $@"INSERT INTO TMEMBER (NAME, TITLE, DESCRIPTION, IMAGE, TWITTER, INSTAGRAM, FACEBOOK, STATE_ID) VALUES
(@NAME, @TITLE, @DESCRIPTION, @IMAGE, @TWITTER, @INSTAGRAM, @FACEBOOK, @STATE_ID)";
using (SqlCommand cmd = new SqlCommand(sqlQuery, con))
{
con.Open();
cmd.Parameters.AddWithValue("@NAME", member.NAME);
cmd.Parameters.AddWithValue("@TITLE", member.TITLE);
cmd.Parameters.AddWithValue("@DESCRIPTION", member.DESCRIPTION);
cmd.Parameters.AddWithValue("@IMAGE", member.IMAGE);
cmd.Parameters.AddWithValue("@TWITTER", member.TWITTER);
cmd.Parameters.AddWithValue("@INSTAGRAM", member.INSTAGRAM);
cmd.Parameters.AddWithValue("@FACEBOOK", member.FACEBOOK);
cmd.Parameters.AddWithValue("@STATE_ID", member.STATE_ID);
cmd.ExecuteNonQuery();
con.Close();
}
}
}
internal void Update(MEMBER member)
{
using (con = new SqlConnection(connectionString))
{
string sqlQuery = $@"UPDATE TMEMBER SET NAME=@NAME, TITLE=@TITLE, DESCRIPTION=@DESCRIPTION, IMAGE=@IMAGE, TWITTER=@TWITTER, INSTAGRAM=@INSTAGRAM, FACEBOOK=@FACEBOOK, STATE_ID=@STATE_ID WHERE TMEMBER.ID = @ID";
using (SqlCommand cmd = new SqlCommand(sqlQuery, con))
{
con.Open();
cmd.Parameters.AddWithValue("@NAME", member.NAME);
cmd.Parameters.AddWithValue("@TITLE", member.TITLE);
cmd.Parameters.AddWithValue("@DESCRIPTION", member.DESCRIPTION);
cmd.Parameters.AddWithValue("@IMAGE", member.IMAGE);
cmd.Parameters.AddWithValue("@TWITTER", member.TWITTER);
cmd.Parameters.AddWithValue("@INSTAGRAM", member.INSTAGRAM);
cmd.Parameters.AddWithValue("@FACEBOOK", member.FACEBOOK);
cmd.Parameters.AddWithValue("@STATE_ID", member.STATE_ID);
cmd.Parameters.AddWithValue("@ID", member.ID);
cmd.ExecuteNonQuery();
con.Close();
}
}
}
public ActionResult MemberCreate(MemberCreateModel fc)
{
try
{
MEMBER newMember = new MEMBER();
newMember.FNAME = fc.FName;
newMember.LNAME = fc.LName;
newMember.AGENCY_ID = fc.Agency_ID;
newMember.PHONE = fc.Phone;
newMember.EMAIL = fc.Email;
newMember.RSSFEED = fc.RSS_Feed;
newMember.EMERGENCY_CONTACT_NAME = fc.Emergency_ContactName;
newMember.EMERGENCY_CONTACT_PHONE = fc.Emergency_ContactPhone;
newMember.ROLE_ID = fc.Role_ID;
newMember.USERNAME = fc.UserName;
STNServiceCaller serviceCaller = STNServiceCaller.Instance;
var request = new RestRequest(Method.POST);
request.Resource = "Members/{pass}/addMember";
request.AddParameter("pass", fc.Password, ParameterType.UrlSegment);
request.RequestFormat = DataFormat.Xml;
request.AddHeader("Content-Type", "application/xml");
STNWebSerializer serializer = new STNWebSerializer();
request.AddParameter("application/xml", serializer.Serialize <MEMBER>(newMember), ParameterType.RequestBody);
MEMBER createdMember = serviceCaller.Execute <MEMBER>(request);
return(RedirectToAction("MemberDE", new { id = createdMember.MEMBER_ID }));
}
catch (Exception e)
{
return(View("../Shared/Error", e));
}
}
public bool UpdateMember(MEMBER member)
{
string sql = @"sp_member_UPDATE";
string sql_phone = @"sp_memAndPhone_UPDATE";
string sql_del = @"sp_memAndPhone_DELETE";
using (TransactionScope ts = new TransactionScope())
{
object[] obj_mem = { "@MFname", member.MFname, "@MLname", member.MLname, "@MAddress", member.MAddress, "@MSex", member.MSex, "@MemID", member.MemID };
Db.Update(sql, obj_mem);
object[] obj_del = { "@MemID", member.MemID };
Db.Delete(sql_del, obj_del);
if (member.MEMBER_PHONE.Count == 0)
{
return(false);
}
else
{
foreach (var ls in member.MEMBER_PHONE)
{
object[] obj = { "@MemID", member.MemID, "@Phone", ls.Phone };
try
{
Db.Insert(sql_phone, obj);
}
catch
{
return(false);
}
}
}
ts.Complete();
return(true);
}
}
/// <summary>
///
/// </summary>
/// <param name="emp"></param>
/// <returns></returns>
public int Create(MEMBER obj)
{
try
{
Guid userGuid = System.Guid.NewGuid();
byte[] dataAndGuid = ASCIIEncoding.ASCII.GetBytes(obj.mempwd + userGuid.ToString());
SHA512 sha512 = new SHA512CryptoServiceProvider();
string resultSha512 = Convert.ToBase64String(sha512.ComputeHash(dataAndGuid));
//obj.mempwd = resultSha512;
obj.memguid = userGuid.ToString();
obj.FAVORITESHOPLIST = null;
obj.MEMBERLIST = null;
using (AllShowEntities db = new AllShowEntities())
{
db.MEMBER.Add(obj);
db.SaveChanges();
return(obj.memno);//db.SaveChanges();
}
}
catch (DbEntityValidationException)
{
throw;
}
catch (Exception)
{
throw;
}
}
private MEMBER ReadMember(DbDataReader dataReader)
{
if (dataReader == null || dataReader["ID"] == null)
{
return(null);
}
var output = new MEMBER();
for (var i = 0; i < dataReader.FieldCount; i++)
{
string fieldName = dataReader.GetName(i).ToUpper();
switch (fieldName)
{
case "ID":
int intValue;
if (int.TryParse(dataReader[fieldName]?.ToString(), out intValue))
{
output.GetType().GetProperty(fieldName).SetValue(output, intValue, null);
}
break;
case "NAME":
output.GetType().GetProperty(fieldName).SetValue(output, dataReader[fieldName]?.ToString(), null);
break;
default:
break;
}
}
return(output);
}
public bool SP_InsertFriendship(MEMBER member1, MEMBER member2)
{
bool output = false;
DbNonQueryResponse dbData = null;
string methodName = MethodBase.GetCurrentMethod().GetName();
var sw = Stopwatch.StartNew();
try
{
string commandText = $"CALL SP_INSERT_FRIENDSHIP({member1.ID}, {member2.ID});";
dbData = this._dbContext.ExecuteNonQuery(commandText, null, $"{methodName}");
if (dbData?.Success ?? false)
{
output = true;
}
return(output);
}
catch (Exception ex)
{
LogEngine.MemberLogger.WriteToLog(LogLevels.Error, $"DAL.Exception: {JsonConvert.SerializeObject(ex)}");
return(output = false);
}
finally
{
sw.Stop();
LogEngine.MemberLogger.WriteToLog(LogLevels.Debug, $"DAL.{methodName}(AFFECTED_ROWS={dbData?.AffectedRows ?? 0}) in {sw.ElapsedMilliseconds}ms");
}
}
//call for who the member logged in is
private string GetLoggedInMember()
{
STNServiceCaller serviceCaller = STNServiceCaller.Instance;
var request = new RestRequest();
request.Resource = "/Members?username={userName}";
request.RootElement = "Member";
request.AddParameter("userName", User.Identity.Name, ParameterType.UrlSegment);
MEMBER thisMember = serviceCaller.Execute <MEMBER>(request);
int loggedInMember = Convert.ToInt32(thisMember.ROLE_ID);
string Role = string.Empty;
switch (loggedInMember)
{
case 1: Role = "Admin"; break;
case 2: Role = "Manager"; break;
case 3: Role = "Field"; break;
default: Role = "error"; break;
}
return(Role);
}
public ActionResult DeleteMember(int id)
{
MEMBER member = memberDA.GetById(id);
try
{
if (ModelState.IsValid)
{
memberDA.Delete(id);
if (System.IO.File.Exists(Server.MapPath("~/Content/images/members/" + member.IMAGE)))
{
System.IO.File.Delete(Server.MapPath("~/Content/images/members/" + member.IMAGE));
}
return(RedirectToAction("Members", "Admin"));
}
else
{
ViewBag.Error = "Try Again.";
return(View("MemberDelete", member));
}
}
catch (Exception ex)
{
ViewBag.Error = "Try Again.";
return(View("MemberDelete", member));
}
}
private void EditMemberButton_Click(object sender, RoutedEventArgs e)
{
Button editMemberButton = sender as Button;
MEMBER editMember = editMemberButton.Tag as MEMBER;
HomeScreen.GetHomeScreenInstance().GetDialogs("MemberAddDialog", editMember, "Xem/Chỉnh sửa Thành viên");
}
public ActionResult SetPassWord(RePassword rePassword)
{
if (ModelState.IsValid)
{
IQueryable <Models.MEMBER> querySql = from d in db.MEMBERS
where d.MEMBERNAME == User.Identity.Name
select d;
List <Models.MEMBER> query = querySql.ToList();
MEMBER member = query.First();
if (member.PASSWORDS != rePassword.OldPassword)
{
ModelState.AddModelError("OldPassword", "密码错误");
}
else
{
db.Database.ExecuteSqlCommand("update MEMBERS set PASSWORDS='" + rePassword.NewPassword + "' where MEMBERNAME='" + member.MEMBERNAME + "'");
db.SaveChanges();
AuthenticationManager.SignOut(DefaultAuthenticationTypes.ApplicationCookie);
for (int i = 0; i < this.Request.Cookies.Count; i++)
{
this.Response.Cookies[this.Request.Cookies[i].Name].Expires = DateTime.Now.AddDays(-1);
}
return(Content("<script>alert('更改成功,请重新登录!');window.location.href='/Home/MainPage';</script>"));
}
}
return(View(rePassword));
}
public ActionResult Validate([Bind(Include = "CellPhone")] MEMBER member)
{
var numberPhone = member.CellPhone;
var data = _db.MEMBERs.Where(s => s.CellPhone.Equals(numberPhone)).ToList();
if (data.Any())
{
_id = data.FirstOrDefault().AccountID;
System.Diagnostics.Debug.WriteLine("MY ID IS" + _id);
Session["Acc"] = data.FirstOrDefault().AccountID;
return(RedirectToAction("OTP"));
}
else
{
ViewBag.error = "Account not found";
return(RedirectToAction("Login"));
}
}
public JsonResult Save(int?id, string data, bool isadd)
{
if (isadd == true)
{
JavaScriptSerializer serialzer = new JavaScriptSerializer();
MEMBER member = serialzer.Deserialize <MEMBER>(data);
member.MATKHAU = md5(member.MATKHAU);
_connect.MEMBERs.Add(member);
_connect.SaveChanges();
}
else
{
MEMBER mb = _connect.MEMBERs.SingleOrDefault(p => p.ID == id);
JavaScriptSerializer serialzer = new JavaScriptSerializer();
MEMBER members = serialzer.Deserialize <MEMBER>(data);
mb.TEN = members.TEN;
mb.MATKHAU = md5(members.MATKHAU);
mb.ANH = members.ANH;
mb.EMAIL = members.EMAIL;
mb.QUYEN = members.QUYEN;
mb.SDT = members.SDT;
mb.STATUS = members.STATUS;
_connect.SaveChanges();
}
return(Json(new { status = true }, JsonRequestBehavior.AllowGet));
}
protected void BtnLogin_Click(object sender, EventArgs e)
{
MEMBER user = GetMemberByLoginname(User_Name.Text, Password1.Text);
if (user != null)
{
CURRENTMEMBER = user;
IsUser = CURRENTMEMBER.TYPEMEMBERID == 1;
IsDepartmentEmployee = CURRENTMEMBER.TYPEMEMBERID == 2;
IsFirmResponsible = CURRENTMEMBER.TYPEMEMBERID == 3;
IsAdmin = CURRENTMEMBER.TYPEMEMBERID == 4;
if (txt_Checkbox.Checked)//Beni unutma kısmında ki checkedbox'ın işaretli olup olmadığına baktık.
{
Response.Cookies["Reservastion-user"].Value = CURRENTMEMBER.ID.ToString();
Response.Cookies["Reservastion-user"].Expires = DateTime.Now.AddDays(365);
}
else
{
Response.Cookies["Reservastion-user"].Expires = DateTime.Now.AddDays(-1);
}
Response.Redirect("/Default.aspx");
}
else
{
MessageBox("Giriş Başarısız.");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (ValidateNewPassword())
{
MEMBER mem = DALMember.GetByID(MEMBERID);
if (mem != null)
{
if (mem.ISACTIVE)
{
mem.PASSWORD = Functions.MD5(txtPasword.Text);
mem.PASSWORDRESETCODE = Guid.NewGuid().ToString();
DALMember.Update(mem);
Functions.SetLoginUser(ONLINEUSER, mem);
DALMailQueue.SendPasswordMail(mem.EMAIL, mem.FULLNAME, txtPasword.Text);
Response.Redirect("/AdminMainPage?Reset=" + mem.PASSWORDRESETCODE + "");
}
else
{
NotificationAdd(NotificationType.error, "Kullanıcınız pasif durumdadır. Sistem yöneticisi ile iletişime geciniz.");
}
}
else
{
NotificationAdd(NotificationType.error, "Kayıt Bulunamadı");
}
}
}
//Sets Username and Password to send with request
public bool setAuthentication(String username, String password)
{
client.Authenticator = new HttpBasicAuthenticator(username, password);
//Check login
RestRequest request = new RestRequest();
request.Resource = ConfigurationManager.AppSettings["STNServicesLoginEndpoint"];
request.RootElement = "boolean";
CurrentUser = _instance.Execute <MEMBER>(request);
if (CurrentUser != null)
{
//get the role
if ((CurrentUser.ROLE_ID != null) || (CurrentUser.ROLE_ID != 0))
{
request = new RestRequest();
request.Resource = "/Roles/{roleId}";
request.RootElement = "ROLE";
request.AddParameter("roleId", CurrentUser.ROLE_ID, ParameterType.UrlSegment);
CurrentRole = _instance.Execute <ROLE>(request);
}
}
else
{
clearAuthentication();
}
return(CurrentUser != null);
}
public override MembershipUser GetUser(string username, bool userIsOnline)
{
MembershipUser memUser = null;
try
{
if (username.Length == 0)
{
return(null);
}
STNServiceCaller serviceCaller = STNServiceCaller.Instance;
var request = new RestRequest();
request.Resource = "/Members?username={userName}";
request.RootElement = "Member";
request.AddParameter("userName", username, ParameterType.UrlSegment);
MEMBER thisMember = serviceCaller.Execute <MEMBER>(request);
if (thisMember != null)
{
memUser = new MembershipUser("STNServicesMembershipProvider",
thisMember.USERNAME, null, thisMember.EMAIL, string.Empty,
string.Empty, true, false, DateTime.Now,
DateTime.Now, DateTime.Now,
DateTime.Now, DateTime.Now);
}
}
catch
{
}
return(memUser);
}
protected void btnSaveFirmDepartmentMember_Click(object sender, EventArgs e)//Yeni çalışan ekle kısmını yaptım kayıt yapıyor seçilen kısıma..
{
if (ValidateRecord())
{
Guid id = Guid.NewGuid();
MEMBER member = null;
using (db = new novartz_stajyer1Entities())
{
member = new MEMBER
{
NAME = txtmdlName.Text,
SURNAME = txtmdlSurname.Text,
LOGINNAME = txtmdlMail.Text,
BIRDDATE = Convert.ToDateTime(txtmdlBirtday.Text),
PHONE = txtmdlPhone.Text,
PASWORD = txtmdlPassword.Text,
GENDER = Convert.ToBoolean(drpmdlGender.SelectedValue == "1"),//Bayan ise true olarak çalışıyor
TYPEMEMBERID = Convert.ToByte(drpmdltypmember.SelectedValue),
CANLOGIN = true,
ID = id
};
db.MEMBER.Add(member);
db.SaveChanges();
};
if (drpmdltypmember.SelectedValue == "3")
{
FIRMRESPONSIBLE rsp = null;
using (db = new novartz_stajyer1Entities())
{
Guid id3 = Guid.NewGuid();
rsp = new FIRMRESPONSIBLE
{
ID = id3,
FIRMID = Guid.Parse(DrpFirm.SelectedValue),
MEMBERID = id
};
db.FIRMRESPONSIBLE.Add(rsp);
db.SaveChanges();
}
}
FIRMDEPARTMENTMEMBER rec = null;
using (db = new novartz_stajyer1Entities())
{
Guid id2 = Guid.NewGuid();
rec = new FIRMDEPARTMENTMEMBER
{
ID = id2,
FIRMDEPARTMENTID = Guid.Parse(DrpDepartment.SelectedValue),
ISACTIVE = dropmdlcd.SelectedValue == "1",
MEMBERID = id
};
db.FIRMDEPARTMENTMEMBER.Add(rec);
db.SaveChanges();
};
MessageBox("İşleminiz Başarılı");
}
}
public JsonResult Delete(int id)
{
MEMBER member = _connect.MEMBERs.SingleOrDefault(p => p.ID == id);
_connect.MEMBERs.Remove(member);
_connect.SaveChanges();
return(Json(new { status = true }, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteConfirmed(int id)
{
MEMBER mEMBER = db.MEMBERs.Find(id);
db.MEMBERs.Remove(mEMBER);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Details(int id)
{
try
{
STNServiceCaller serviceCaller = STNServiceCaller.Instance;
var request = new RestRequest();
request.Resource = "HWMs/{entityId}";
request.RootElement = "HWM";
request.AddParameter("entityId", id, ParameterType.UrlSegment);
HWM aHWM = serviceCaller.Execute <HWM>(request);
//see if this hwm has a peak summary or approval (field can't delete then)
if (aHWM.PEAK_SUMMARY_ID.HasValue || aHWM.APPROVAL_ID.HasValue)
{
ViewData["ManagerOnly"] = "true";
}
//get Site number
request = new RestRequest();
request.Resource = "Sites/{entityId}";
request.RootElement = "SITE";
request.AddParameter("entityId", aHWM.SITE_ID, ParameterType.UrlSegment);
ViewData["SiteNo"] = serviceCaller.Execute <SITE>(request).SITE_NO;
//get member logged in's role
request = new RestRequest();
request.Resource = "/Members?username={userName}";
request.RootElement = "MEMBER";
request.AddParameter("userName", User.Identity.Name, ParameterType.UrlSegment);
MEMBER thisMember = serviceCaller.Execute <MEMBER>(request);
if (thisMember.ROLE_ID == 1)
{
ViewData["Role"] = "Admin";
}
if (thisMember.ROLE_ID == 2)
{
ViewData["Role"] = "Manager";
}
if (thisMember.ROLE_ID == 3)
{
ViewData["Role"] = "Field";
}
//Get peak summary info
request = new RestRequest();
request.Resource = "/PeakSummaries/{entityId}";
request.RootElement = "ArrayOfPEAK_SUMMARY";
request.AddParameter("entityId", aHWM.PEAK_SUMMARY_ID, ParameterType.UrlSegment);
ViewData["PeakSummary"] = serviceCaller.Execute <PEAK_SUMMARY>(request);
return(View(aHWM));
}
catch (Exception e)
{
return(View("../Shared/Error", e));
}
}
private void Member_Delete_btn_Click(object sender, EventArgs e)
{
id = (int)(MD_Grid.CurrentRow.Cells[0].Value);
MEMBER memData = data.MEMBERS.Find(id);
data.MEMBERS.Remove(memData);
data.SaveChanges();
load_comboBoxes();
}
public async Task <ActionResult> DeleteConfirmed(short id)
{
MEMBER mEMBER = await db.MEMBER.FindAsync(id);
db.MEMBER.Remove(mEMBER);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public ActionResult EditMember(MEMBER model)
{
if (Session["MEmail"] != null && Session["MemID"] != null)
{
var resolveRequest = HttpContext.Request;
resolveRequest.InputStream.Seek(0, SeekOrigin.Begin);
string jsonString = new StreamReader(resolveRequest.InputStream).ReadToEnd();
if (jsonString != null)
{
List <string> phones = new List <string>();
dynamic jArr2 = Newtonsoft.Json.JsonConvert.DeserializeObject(jsonString);
try
{
foreach (dynamic item in jArr2)
{
string type = item.name.Value.ToString();
switch (type)
{
case "email": model.MEmail = item.value.Value; break;
case "inputFName": model.MFname = item.value.Value; break;
case "inputLName": model.MLname = item.value.Value; break;
case "address": model.MAddress = item.value.Value; break;
case "optradio": model.MSex = item.value.Value; break;
case "mobilePhone[]": model.MEMBER_PHONE.Add(new MEMBER_PHONE()
{
Phone = item.value.Value
}); break;
// phones.Add(item.value.Value); break;
}
model.MemID = Session["MemID"].ToString();
}
if (_memRepository.UpdateMember(model))
{
var objUser = db.MEMBER.Where(m => m.MEmail == model.MEmail && m.MPassword == model.MPassword).FirstOrDefault();
if (objUser != null)
{
Session["MemID"] = objUser.MemID;
Session["MEmail"] = objUser.MEmail;
}
return(RedirectToAction("Index", "Shipping"));
}
}
catch
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
return(View());
}
return(RedirectToAction("Index", "Shipping"));
}
//
// GET: /ObjPointsDetails/1
public ActionResult ObjPointDetails(int id)
{
try
{
STNServiceCaller serviceCaller = STNServiceCaller.Instance;
var request = new RestRequest();
request.Resource = "/ObjectivePoints/{entityId}";
request.RootElement = "OBJECTIVE_POINT";
request.AddParameter("entityId", id, ParameterType.UrlSegment);
OBJECTIVE_POINT anObjPoint = serviceCaller.Execute <OBJECTIVE_POINT>(request);
//get any opMeasurements that have this op attached
request = new RestRequest();
request.Resource = "ObjectivePoints/{objectivePointId}/OPMeasurements";
request.RootElement = "ArrayOfOP_MEASUREMENTS";
request.AddParameter("objectivePointId", id, ParameterType.UrlSegment);
List <OP_MEASUREMENTS> OPopMeasList = serviceCaller.Execute <List <OP_MEASUREMENTS> >(request);
if (OPopMeasList.Count >= 1)
{
ViewData["OPMeas_Linked"] = "true";
}
request = new RestRequest();
request.Resource = "Sites/{entityId}";
request.RootElement = "SITE";
request.AddParameter("entityId", anObjPoint.SITE_ID, ParameterType.UrlSegment);
ViewData["SiteNo"] = serviceCaller.Execute <SITE>(request).SITE_NO;
//get member logged in's role
request = new RestRequest();
request.Resource = "/Members?username={userName}";
request.RootElement = "MEMBER";
request.AddParameter("userName", User.Identity.Name, ParameterType.UrlSegment);
MEMBER thisMember = serviceCaller.Execute <MEMBER>(request);
if (thisMember.ROLE_ID == 1)
{
ViewData["Role"] = "Admin";
}
if (thisMember.ROLE_ID == 2)
{
ViewData["Role"] = "Manager";
}
if (thisMember.ROLE_ID == 3)
{
ViewData["Role"] = "Field";
}
return(View("../ObjPoints/ObjPointDetails", anObjPoint));
}
catch (Exception e)
{
return(View("../Shared/Error", e));
}
}
public async Task <ActionResult> Create([Bind(Include = "MEMBER_ID,NATIONAL_ID,USERNAME,PASSWORD,FNAME,LNAME,SEX,BIRTH_DATE,ADDRESS,E_MAIL,PHONE,CREDIT_CARD,URL_IMG,RE_ENTER")] MEMBER mEMBER)
{
if (db.MEMBER.Where(a => a.USERNAME.Equals(mEMBER.USERNAME)).Count() != 0)
{
Response.Write("<script> alert('This username was used.')</script>");
return(View(mEMBER));
}
if (db.MEMBER.Where(a => a.NATIONAL_ID.Equals(mEMBER.NATIONAL_ID)).Count() != 0)
{
Response.Write("<script> alert('This national id was used.')</script>");
return(View(mEMBER));
}
if (mEMBER.NATIONAL_ID.ToString().Length != 13)
{
Response.Write("<script> alert('National ID incorrect.')</script>");
return(View(mEMBER));
}
if (mEMBER.PASSWORD != mEMBER.RE_ENTER)
{
Response.Write("<script> alert('Password and Re-Enter not match.')</script>");
return(View(mEMBER));
}
if (mEMBER.BIRTH_DATE > DateTime.Today)
{
Response.Write("<script> alert('Birthday incorrext.')</script>");
return(View(mEMBER));
}
if (ModelState.IsValid)
{
mEMBER.MEMBER_ID = (short)(db.MEMBER.Count() + 1);
//string[] date = mEMBER.B_DATE.Split('-');
//mEMBER.B_DATE = date[1] + '/' + date[0] + '/' + date[2];
//mEMBER.BIRTH_DATE = Convert.ToDateTime(mEMBER.B_DATE);
db.MEMBER.Add(mEMBER);
if (mEMBER.URL_IMG == null)
{
mEMBER.URL_IMG = "http://downloadicons.net/sites/default/files/user-icon-2722.png";
}
Session["img"] = mEMBER.URL_IMG;
db.MEMBER.Add(mEMBER);
await db.SaveChangesAsync();
return(RedirectToAction("Login", "Home"));
}
return(View(mEMBER));
}
public ClaimsIdentity CreateIdentity(MEMBER member, string authenticationType)
{
ClaimsIdentity _identity = new ClaimsIdentity(DefaultAuthenticationTypes.ApplicationCookie);
_identity.AddClaim(new Claim(ClaimTypes.Name, member.MEMBERNAME));
_identity.AddClaim(new Claim(ClaimTypes.NameIdentifier, member.MEMBERID));
//_identity.AddClaim(new Claim(ClaimTypes.NameIdentifier, member.PASSWORDS));
//_identity.AddClaim(new Claim("http://schemas.microsoft.com/accesscontrolservice/2010/07/claims/identityprovider", "ASP.NET Identity"));
return(_identity);
}
public bool MEMBERControl(string mail)
{
MEMBER sonuc = null;
using (db = new novartz_stajyer1Entities())
{
sonuc = db.MEMBER.SingleOrDefault(u => u.LOGINNAME == mail);
}
return(sonuc != null);
}
public MEMBER GetMemberByLoginname(string loginname, string password)
{
MEMBER rec = null;
using (db = new novartz_stajyer1Entities())
{
rec = db.MEMBER.Where(a => a.LOGINNAME == loginname && a.PASWORD == password).FirstOrDefault();
}
return(rec);
}
