protected void btnAdd_Click(object sender, EventArgs e)
{
if (ValidateRecord()) // 1) Valideta controle git hata kontrolu yapılsın. hata yok ise if içine girer.
{
//girilen değerleri atama yapar
ENTMEMUSER user = new ENTMEMUSER();
user.ID = Guid.NewGuid();
user.MAIL = txtEposta.Text;
user.PASSWORD = MD5("1");
user.NAME = txtName.Text;
user.SURNAME = txtSurname.Text;
user.CREATEDATE = Convert.ToDateTime(txtRecorddate.Text);
user.TYPEUSERID = Convert.ToByte(drpUserType.SelectedValue);
user.ISADMIN = chkAdmin.Checked;
user.PHONE = txtTelephone.Text;
user.STATUS = Convert.ToBoolean(true);
user.FIRMID = FIRMID;
//user.FIRMID = Guid.Parse(drpFirm.SelectedValue);
user.LANGUAGEID = byte.Parse(drpLanguage.SelectedValue);
DALUser.InsertTable(user); //bu fonksiyona gider atama yapılmıs degerlerı tabloya dataya kayıt eder
Response.Redirect("/Mng/MNGFirmDetail.aspx?ID=" + FIRMID);
}
}
public void DeleteUserTest()
{
List <string> errors = new List <string>();
Random random = new Random();
Users users = new Users(1, 1, "username" + random.Next(10000), "password", 'u', "test" + random.Next(10000) + "@test.com",
DateTime.Now, DateTime.Now, 'a');
int id = DALUser.CreateUser(users, ref errors);
Assert.AreNotEqual(-1, id);
int result = DALUser.DeleteUser(id, ref errors);
Assert.AreNotEqual(-1, result);
Users verifyUser = DALUser.ReadUser(id, ref errors);
Assert.AreEqual(0, errors.Count());
Assert.AreEqual('d', verifyUser.condition);
Assert.AreNotEqual(-1, result);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (!string.IsNullOrEmpty(ONLINEUSER.ID.ToString()))
{
ENTMEMUSER user = DALUser.GetUser(ONLINEUSER.ID);
if (user != null)
{
txtName.Text = user.NAME;
txtSurname.Text = user.SURNAME;
txtEposta.Text = user.MAIL;
txtTelephone.Text = user.PHONE.ToString();
}
else
{
Response.Redirect("/Default.aspx");
}
}
else
{
Response.Redirect("/Default.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (!string.IsNullOrEmpty(Request.QueryString["ID"]))
{
FIRMID = DALUser.GetFirmID(Guid.Parse(Request.QueryString["ID"]));
ENTVWMEMUSER usr = DALUser.GetUserInfo(Guid.Parse(Request.QueryString["ID"]));
if (usr != null)
{
USERID = usr.ID;
lblName.Text = usr.NAME;
lblSurname.Text = usr.SURNAME;
lblFirmName.Text = usr.FIRMNAME;
lblPhone.Text = usr.PHONE;
lblEmail.Text = usr.MAIL;
lblStatus.Text = usr.STATUS ? "Aktif" : "Pasif";
lblCreateDate.Text = usr.CREATEDATE.ToString();
lblLanguage.Text = usr.LANGUAGENAME;
lblUserType.Text = usr.TYPEUSERNAME;
}
else
{
Response.Redirect("/Mng/MNGFirmDetail.aspx");
}
}
else
{
Response.Redirect("/Mng/MNGFirms.aspx");
}
}
}
public DALUser GetAdditionalInfo(DALUser user)
{
User expectedUser = context.Set <User>().Include("UserInfo").FirstOrDefault(i => i.Email == user.Email);
if (ReferenceEquals(expectedUser, null))
{
throw new InvalidOperationException();
}
return(new DALUser()
{
Id = expectedUser.UserId,
Nickname = expectedUser.Nickname,
Password = expectedUser.Password,
Email = expectedUser.Email,
Role = expectedUser.Role,
Rating = expectedUser.Rating,
Firstname = expectedUser.UserInfo == null?null: expectedUser.UserInfo.Firstname,
Lastname = expectedUser.UserInfo == null ? null : expectedUser.UserInfo.Lastname,
Age = expectedUser.UserInfo == null ? null : expectedUser.UserInfo.Age,
Gender = expectedUser.UserInfo == null ? null : expectedUser.UserInfo.Gender,
//CreatedTasks = new List<DALTask>(expectedUser.CreatedTasks.Select(i=>new DALTask()
//{
// Title = i.Task.Title,
// Price = i.Task.Price,
// Status = i.Task.Status
//})),
//DevelopedTasks = new List<DALTask>(expectedUser.CreatedTasks.Select(i=>new DALTask()
//{
// Title = i.Task.Title,
// Price = i.Task.Price,
// Status = i.Task.Status
//}))
});
}
protected void rptFirms_ItemCommand(object source, RepeaterCommandEventArgs e)
{
switch (e.CommandName)
{
case "Delete":
List <ENTMEMUSER> FirmUserList = DALUser.GetAllListUserID(Guid.Parse(e.CommandArgument.ToString()));
foreach (ENTMEMUSER user in FirmUserList)
{
List <ENTREQREQUESTS> FirmRequestList = DALRequest.GetAllListFirmRequestsID(user.ID);
foreach (ENTREQREQUESTS rqst in FirmRequestList)
{
List <ENTREQREQUESTDETAIL> FirmRequestDetailList = DALRequest.GetAllListRequestDetailsID(rqst.ID);
foreach (ENTREQREQUESTDETAIL rqstdtl in FirmRequestDetailList)
{
DALRequest.DeleteDetail(rqstdtl.ID);
}
DALRequest.Delete(rqst.ID);
}
List <ENTPRJPROJECTTASKRESOURSE> ProjectTaskResourseList = DALProjectTaskResourse.GetAllListFirmResoursesID(user.ID);
foreach (ENTPRJPROJECTTASKRESOURSE rsr in ProjectTaskResourseList)
{
List <ENTPRJPROJECTTASKRESOURSEACTIVITY> ProjectTaskResourseActivityList = DALProjectTaskResourseActivity.GetAllListTaskResoursesActivityID(rsr.ID);
foreach (ENTPRJPROJECTTASKRESOURSEACTIVITY act in ProjectTaskResourseActivityList)
{
DALProjectTaskResourseActivity.Delete(act.ID);
}
DALProjectTaskResourse.Delete(rsr.ID);
}
DALUser.Delete(user.ID);
}
List <ENTPRJPROJECT> FirmProjectList = DALProject.GetAllListTaskID(Guid.Parse(e.CommandArgument.ToString()));
foreach (ENTPRJPROJECT prj in FirmProjectList)
{
List <ENTPRJPROJECTTASK> ProjectTaskList = DALProjectTask.GetAllListTaskID(prj.ID);
foreach (ENTPRJPROJECTTASK tsk in ProjectTaskList)
{
DALProjectTask.Delete(tsk.ID);
}
DALProject.Delete(prj.ID);
}
DALFirm.Delete(Guid.Parse(e.CommandArgument.ToString()));
FillFirm();
break;
}
}
public List <NotificationConnection> GetNotificationConnections(string userid)
{
IUser userDAL = new DALUser();
api.getdelays.POCO.User u = userDAL.GetUser(Convert.ToInt32(userid));
List <NotificationConnection> listS = new List <NotificationConnection>();
IGetAll newaccessapi = SNCBAPI.GetAll.Instance();
DateTime now = DateTime.UtcNow;
now = now.AddHours(2);
if (u != null)
{
foreach (api.getdelays.POCO.FollowedConnection s in u.followedConnections)
{
DataApiConnection stat = newaccessapi.GetConnection(s.departure, s.arrival, s.DateTime);
foreach (SNCBAPI.Connection c in stat.connection)
{
DateTime hourTrain = new DateTime();
hourTrain = hourTrain.AddHours(2);
hourTrain = hourTrain.AddSeconds(c.departure.time);
int year = DateTime.Now.Year - hourTrain.Year;
hourTrain = hourTrain.AddYears(year);
if (s.DateTime.TimeOfDay == hourTrain.TimeOfDay)
{
hourTrain = hourTrain.AddMinutes(c.departure.delay);
if (hourTrain.TimeOfDay > now.TimeOfDay)
{
hourTrain = hourTrain.AddMinutes(-c.departure.delay);
if (c.departure.delay >= 15 && c.departure.delay < 30)
{
listS.Add(new NotificationConnection {
Arrival = s.arrival, Departure = s.departure, DelaysArrival = Convert.ToInt32(c.arrival.delay), DelaysDeparture = Convert.ToInt32(c.departure.delay), Time = hourTrain, Priority = "warning"
});
}
else if (c.departure.delay < 15 && c.departure.delay >= 0)
{
listS.Add(new NotificationConnection {
Arrival = s.arrival, Departure = s.departure, DelaysArrival = Convert.ToInt32(c.arrival.delay), DelaysDeparture = Convert.ToInt32(c.departure.delay), Time = hourTrain, Priority = "normal"
});
}
else if (c.departure.delay >= 30)
{
listS.Add(new NotificationConnection {
Arrival = s.arrival, Departure = s.departure, DelaysArrival = Convert.ToInt32(c.arrival.delay), DelaysDeparture = Convert.ToInt32(c.departure.delay), Priority = "danger"
});
}
}
}
}
}
return(listS);
}
else
{
return(null);
}
}
protected void rptUsers_ItemCommand(object source, RepeaterCommandEventArgs e)
{
switch (e.CommandName)
{
case "Delete":
{
DALUser.Delete(Guid.Parse(e.CommandArgument.ToString()));
FillUser();
break;
}
}
}
public bool updateUser(PROPUser User)
{
if (string.IsNullOrEmpty(User.UserName) || User.Id <= 0)
{
return(false);
}
else
{
DALUser dalUser = new DALUser();
dalUser.UpdateEquipe(User);
return(true);
}
}
public List <PROPUser> getUser(string searchUser)
{
DALUser dalUser = new DALUser();
if (string.IsNullOrEmpty(searchUser))
{
return(dalUser.getAllEquipe());
}
else
{
return(dalUser.getEquipe(searchUser));
}
}
public User validateUser(string userName, string userPassword)
{
User user = new User()
{
UserName = userName,
UserPassword = userPassword
};
dalUser = new DALUser();
var validateUser = dalUser.dalValidateUser(user);
return(validateUser);
}
public api.getdelays.POCO.User GetUser(string email)
{
IUser user = new DALUser();
api.getdelays.POCO.User testUserInformation = user.GetUser(email);
if (testUserInformation == null)
{
return(null);
}
else
{
return(testUserInformation);
}
}
public static Users ReadUser(int id, ref List <string> errors)
{
if (id <= 0)
{
errors.Add("Invalid id");
}
if (errors.Count > 0)
{
return(null);
}
return(DALUser.ReadUser(id, ref errors));
}
public static int DeleteUser(int id, ref List <string> errors)
{
if (id <= 0)
{
errors.Add("Invalid id");
}
if (errors.Count > 0)
{
return(-1);
}
return(DALUser.DeleteUser(id, ref errors));
}
public int CreateUser(string UserName, string UserPrenom, string sexe)
{
if (string.IsNullOrEmpty(UserName))
{
return(-1);
}
else
{
DALUser dalUser = new DALUser();
PROPUser joueur = new PROPUser(0, UserName, UserPrenom, sexe);
return(dalUser.CreateEquipe(joueur));
}
}
public api.getdelays.POCO.User Login(string email, string password)
{
IUser user = new DALUser();
api.getdelays.POCO.User testUserInformation = user.Login(email, password);
if (testUserInformation == null)
{
return(null);
}
else
{
return(testUserInformation);
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
if (ValidateRecord())
{
ENTMEMUSER user = DALUser.GetUser(txtMail.Text, MD5(txtPassword.Text));
if (user != null)
{
if (user.STATUS)
{
ONLINEUSER.ID = user.ID;
ONLINEUSER.NAME = user.NAME;
ONLINEUSER.SURNAME = user.SURNAME;
ONLINEUSER.FULLNAME = user.NAME + " " + user.SURNAME;
ONLINEUSER.MAIL = user.MAIL;
ONLINEUSER.TYPEUSERID = user.TYPEUSERID;
ONLINEUSER.FIRMID = user.FIRMID;
ONLINEUSER.ISADMIN = user.ISADMIN;
ONLINEUSER.STATUS = user.STATUS;
if (chkRememberMe.Checked)
{
HttpCookie cookie = new HttpCookie(COOKIENAME);
cookie.Values.Add("MAIL", ONLINEUSER.MAIL);
cookie.Values.Add("PASSWORD", MD5(txtPassword.Text));
cookie.Expires = DateTime.Now.AddDays(1);
Response.Cookies.Add(cookie);
}
else
{
if (Request.Cookies[COOKIENAME] != null)
{
HttpCookie cookie = Request.Cookies[COOKIENAME];
cookie.Values.Clear();
cookie.Expires = DateTime.MinValue;
Response.Cookies.Add(cookie);
}
}
Response.Redirect("/Default.aspx");
}
else
{
AddMessage(lblError, "Hesabınız pasiftir!", false);
}
}
else
{
AddMessage(lblError, "Kullanıcı adı yada Şifre yanlış!", false);
}
}
}
public bool DeleteUser(string userid)
{
IUser userDAL = new DALUser();
api.getdelays.POCO.User user = userDAL.GetUser(Convert.ToInt32(userid));
if (user == null)
{
return(false);
}
else
{
userDAL.DeleteUser(user);
return(true);
}
}
public string getUserByID(string stringUserID)
{
int UserID;
DALUser dalUser = new DALUser();
int.TryParse(stringUserID, out UserID);
if (UserID == 0)
{
return(string.Empty);
}
else
{
return(dalUser.GetEquipeById(UserID));
}
}
protected void btnSendEmail_Click(object sender, EventArgs e)
{
DALUser obj = new DALUser();
DataSet ds = obj.User_GetLoginDetails(txtEmail.Text.Trim());
if (ds.Tables[0].Rows.Count > 0)
{
string from = "*****@*****.**";
string to = txtEmail.Text.Trim();
MailMessage mail = new MailMessage();
mail.To.Add(to);
mail.From = new MailAddress(from, "My Pharmacy", System.Text.Encoding.UTF8);
mail.Subject = "Password Recovery Email";
mail.SubjectEncoding = System.Text.Encoding.UTF8;
mail.Body = "Dear Valued Customer," + ds.Tables[0].Rows[0]["FullName"].ToString() + "<br/>" +
"Your login details are as follows:<br/><br/>" +
"<b>Member ID:" + txtEmail.Text.Trim() + "</b> <br/>" +
"<b>Password:"******"Password"].ToString() + "</b> <br/><br/>" +
"MyPharmacy Support Team<br/>" +
"www.mypharmacy.com";
mail.BodyEncoding = System.Text.Encoding.UTF8;
mail.IsBodyHtml = true;
mail.Priority = MailPriority.High;
SmtpClient client = new SmtpClient();
client.Credentials = new System.Net.NetworkCredential(from, "bsit6861668");
//client.UseDefaultCredentials = true;
client.Port = 25; // Gmail works on this port
client.Host = "smtp.gmail.com";
client.EnableSsl = true; //Gmail works on Server Secured Layer
try
{
client.Send(mail);
lblMessage.Text = "Email sent successfully!";
}
catch (Exception ex)
{
obj.ErrorLog_Add(ex.Message);
lblMessage.Text = "Our email server is in process of upgradation.\nTry after sometime.";
}
}
else
{
lblMessage.Text = "Invalid Email";
}
}
public static UserEntity ToBLLEntity(this DALUser item)
{
if (ReferenceEquals(item, null))
{
return(null);
}
return(new UserEntity
{
Id = item.Id,
Name = item.Name,
Password = item.Password,
RoleID = item.RoleId,
Mail = item.Mail
});
}
public int deleteUser(string stringUserID)
{
int UserID;
DALUser dalUser = new DALUser();
int.TryParse(stringUserID, out UserID);
if (UserID == 0)
{
return(0);
}
else
{
return(dalUser.DeleteEquipe(UserID));
}
}
public List <api.getdelays.POCO.User> GetUsers()
{
IUser user = new DALUser();
List <api.getdelays.POCO.User> users = user.GetUsers();
foreach (api.getdelays.POCO.User u in users)
{
u.followedConnections = null;
u.followedStations = null;
u.Id = 0;
u.name = "";
u.password = "";
u.phoneNumber = 0;
u.surname = "";
}
return(users);
}
public api.getdelays.POCO.User MakeAccount(string email, string name, string surname, string password, string phoneNumber)
{
IUser userDAL = new DALUser();
if (userDAL.GetUser(email) == null)
{
api.getdelays.POCO.User user = new api.getdelays.POCO.User {
name = name, surname = surname, email = email, password = password, phoneNumber = Convert.ToInt32(phoneNumber)
};
userDAL.AddUser(user);
return(user);
}
else
{
return(null);
}
}
public api.getdelays.POCO.User DeleteFollowConnection(string userid, string idConnection)
{
IFollowedConnection followedConnection = new DALFollowedConnection();
IUser userDAL = new DALUser();
api.getdelays.POCO.User u = userDAL.GetUser(Convert.ToInt32(userid));
if (u != null)
{
api.getdelays.POCO.FollowedConnection f = followedConnection.GetFollowedConnection(Convert.ToInt32(idConnection));
followedConnection.DeleteFollowedConnection(f);
u.followedConnections = followedConnection.GetFollowedConnections(u);
return(u);
}
else
{
return(null);
}
}
public api.getdelays.POCO.User UpdateUser(string name, string surname, string phoneNumber, string userid)
{
IUser userDAL = new DALUser();
api.getdelays.POCO.User user = userDAL.GetUser(Convert.ToInt32(userid));
if (user == null)
{
return(null);
}
else
{
api.getdelays.POCO.User newUser = new api.getdelays.POCO.User {
Id = Convert.ToInt32(userid), name = name, surname = surname, email = user.email, phoneNumber = Convert.ToInt32(phoneNumber), followedConnections = user.followedConnections, followedStations = user.followedStations
};
userDAL.UpdateUser(user, newUser);
return(newUser);
}
}
public static UserEntity ToBllUser(this DALUser user)
{
return(new UserEntity()
{
Id = user.Id,
Nickname = user.Nickname,
Password = user.Password,
Email = user.Email,
Rating = (ushort)user.Rating,
Role = (Role)user.Role,
Firstname = user.Firstname,
Lastname = user.Lastname,
Age = user.Age,
Gender = user.Gender,
//CreatedTasks = new List<TaskEntity>(user.CreatedTasks.Select(i=>i.ToBllEntity())),
//DevelopedTasks = new List<TaskEntity>(user.DevelopedTasks.Select(i=>i.ToBllEntity()))
});
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (ValidateRecord())
{
ENTMEMUSER user = DALUser.GetUser(ONLINEUSER.ID);
if (user != null)
{
user.NAME = txtName.Text;
user.SURNAME = txtSurname.Text;
user.MAIL = txtEposta.Text;
user.PHONE = txtTelephone.Text;
user.PASSWORD = MD5(txtPassword.Text);
DALUser.UpdateProfile(user);
Response.Redirect("/Login.aspx");
}
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string userID = txtUserID.Text;
string password = txtPassword.Text;
DALUser obj = new DALUser();
DataSet ds = obj.User_Login(userID, password);
if (ds.Tables[0].Rows.Count > 0)
{
Session.Add("IsValid", "kuchbhi");
Response.Redirect("Home.aspx");
}
else
{
lblMessage.Text = "Your User Id or Password don't match";
}
}
public void Delete(DALUser user)
{
User userToDel = context.Set <User>().FirstOrDefault(u => u.Email == user.Email);
if (ReferenceEquals(userToDel, null))
{
throw new InvalidOperationException();
}
UserInfo userInfoToDel = userToDel.UserInfo;
context.Set <User>().Remove(userToDel);
if (!ReferenceEquals(userInfoToDel, null))
{
context.Set <UserInfo>().Remove(userInfoToDel);
}
context.SaveChanges();
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (p2.Text != p3.Text)
{
Session[WebHint.Web_Hint] = new WebHint("两次输入的新密码不一致，请重新输入！", "#", HintFlag.错误);
Response.Redirect(WebHint.HintURL);
}
DALUser du = new DALUser();
UserInfo u = du.GetByUserName(uc.UserName);
if (u.Pwd != p1.Text)
{
Session[WebHint.Web_Hint] = new WebHint("原密码输入错误！", "#", HintFlag.错误);
Response.Redirect(WebHint.HintURL);
}
u.Pwd = p2.Text;
du.Save(u);
Session[WebHint.Web_Hint] = new WebHint("操作成功！", "Default.aspx", HintFlag.跳转);
Response.Redirect(WebHint.HintURL);
}
