private void SaveData()
{
string sUserName = Session["User"].ToString();
oDAL = new UsersDAL();
oClass = new UserModel();
oClass.UserName = UserName.Value;
oClass.UserPassword = EncryptDecryptProvider.EncryptString("b14ca5898a4e4133bbce2ea2315a1916", UserPassword.Value);
oClass.LastName = LastName.Value;
oClass.FirstName = FirstName.Value;
oClass.AccountType = AccountType.Value;
oClass.Address = txtAddress.InnerText;
oClass.Phone = txtContact.Value;
oClass.Email = txtEmail.Value;
string id = UserID.Value;
if (id == "")
{
oDAL.InsertData(sUserName, oClass);
//lblMsg.Text = "New Record has been saved";
}
else
{
oClass.ID = Convert.ToInt16(id);
oDAL.UpdateData(sUserName, oClass);
// lblMsg.Text = "Record has been updated";
}
}
public void WritePost(string username, string message)
{
var ctx = new MessagingBoardContext();
var post = new Post {
Message = EncryptDecryptProvider.Encrypt(message), Username = username, DatePosted = DateTime.Now
};
ctx.Posts.Add(post);
ctx.SaveChanges();
Clients.All.receivedNewPost(post.Id, post.Username, EncryptDecryptProvider.Decrypt(post.Message), post.DatePosted);
}
public void AddComment(int postId, string comment, string username)
{
var ctx = new MessagingBoardContext();
var post = ctx.Posts.FirstOrDefault(p => p.Id == postId);
if (post != null)
{
var newComment = new Comment {
ParentPost = post, Message = EncryptDecryptProvider.Encrypt(comment), Username = username, DatePosted = DateTime.Now
};
ctx.Comments.Add(newComment);
ctx.SaveChanges();
Clients.All.receivedNewComment(newComment.ParentPost.Id, newComment.Id, EncryptDecryptProvider.Decrypt(newComment.Message), newComment.Username, newComment.DatePosted);
}
}
// GET api/<controller>
public IEnumerable <Post> Get()
{
var allPosts = this._ctx.Posts.OrderByDescending(x => x.DatePosted).ToList();
foreach (var post in allPosts)
{
post.Message = EncryptDecryptProvider.Decrypt(post.Message);
var allCommentsOnThisPost = _ctx.Comments.Where(p => p.ParentPost.Id == post.Id).ToList();
foreach (var comment in allCommentsOnThisPost)
{
comment.Message = EncryptDecryptProvider.Decrypt(comment.Message);
post.Comments.Add(comment);
}
}
return(allPosts);
}
//private void LoadCountry()
//{
// CountryDAL countryDAL = new CountryDAL();
// ddlCountryCode.DataSource = countryDAL.SelectAll();
// ddlCountryCode.DataTextField = "Name";
// ddlCountryCode.DataValueField = "Code";
// ddlCountryCode.DataBind();
//}
private void PopulateData(int id)
{
oDAL = new UsersDAL();
oClass = new UserModel();
oDs = new DataSet();
oClass.ID = id;
oDs = oDAL.SelectByID(oClass);
UserID.Value = oDs.Tables[0].Rows[0][0].ToString();
//UserName.Value = oDs.Tables[0].Rows[0][1].ToString();
UserName.Value = oDs.Tables[0].Rows[0][2].ToString();
UserPassword.Value = EncryptDecryptProvider.DecryptString("b14ca5898a4e4133bbce2ea2315a1916", oDs.Tables[0].Rows[0][3].ToString());
LastName.Value = oDs.Tables[0].Rows[0][4].ToString();
FirstName.Value = oDs.Tables[0].Rows[0][5].ToString();
AccountType.Value = oDs.Tables[0].Rows[0][6].ToString();
txtEmail.Value = oDs.Tables[0].Rows[0][9].ToString();
txtContact.Value = oDs.Tables[0].Rows[0][10].ToString();
}
private void HealthAssistLogin()
{
UserClass oClass = new UserClass();
UserDAL oDal = new UserDAL();
DataSet oDS = new DataSet();
// oClass.UserID = UserName.text;
//TextBox un = LoginUser.FindControl("UserName") as TextBox;
oClass.UserName = txbUsername.Text;
oDS = oDal.CheckUserName(oClass);
if (oDS != null)
{
if (oDS.Tables[0].Rows.Count > 0)
{
oClass = new UserClass();
oDal = new UserDAL();
DataSet oDSPwd = new DataSet();
//TextBox un1 = UserName.Text;//LoginUser.FindControl("UserName") as TextBox;
//TextBox pwd = LoginUser.FindControl("Password") as TextBox;
oClass.UserName = txbUsername.Text;
oClass.Password = EncryptDecryptProvider.EncryptString("b14ca5898a4e4133bbce2ea2315a1916", txbPassword.Text);
oDSPwd = oDal.CheckUserNamePassword(oClass);
if (oDSPwd.Tables[0].Rows.Count > 0)
{
//Response.Redirect("WebFormClientList.aspx");
Session["UserType"] = oDSPwd.Tables[0].Rows[0]["account_type"].ToString();
Session["UserID"] = oDSPwd.Tables[0].Rows[0][0].ToString();
Session["User"] = txbUsername.Text;
//Session["UserLoginCode"] = GenerateRandomNumber(1000,9999);
//SendEmail(oDSPwd.Tables[0].Rows[0]["email"].ToString());
//Response.Redirect("ConfirmLogin.aspx");
//Response.Redirect("Dashboard.aspx");
if (Session["UserType"].ToString() == "Admin")
{
Response.Redirect("Dashboard.aspx");
}
else if (Session["UserType"].ToString() == "Staff")
{
Response.Redirect("Patient.aspx");
}
else if (Session["UserType"].ToString() == "Physician")
{
Response.Redirect("Physician/EncounterList.aspx?View=Pending");
}
}
else
{
//Label lb = LoginUser.FindControl("lblError") as Label;
string script = "<script type=\"text/javascript\">alert('Please check your password');</script>";
Response.Write(script);
}
}
else
{
//Label lb = LoginUser.FindControl("lblError") as Label;
string script = "<script type=\"text/javascript\">alert('Invalid User');</script>";
Response.Write(script);
// Response.Write("<script>alert('Invalid User');</script>");
}
}
}
