public List <Mail> getAllReceivedMails(string LoggedEmailID) { List <Mail> Mails = new List <Mail>(); SqlCommand cmd = ExecuteSql.ExecuteCommand("Select * from YCET_Mails Where EMAILID=@EMAILID AND ISDRAFT=0 AND Isdeleted=0 order by 1 desc"); cmd.Parameters.AddWithValue("@EMAILID", LoggedEmailID); cmd.ExecuteNonQuery(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Mail _mail = new Mail(); _mail.EmailID = rdr["EmailID"].ToString(); _mail.Subject = rdr["Subject"].ToString(); _mail.Message = rdr["Message"].ToString(); _mail.FromEmailId = rdr["SenderId"].ToString(); _mail.IsRead = (int)rdr["IsRead"]; _mail.IsDraft = (int)rdr["IsDraft"]; _mail.MsgId = (int)rdr["MsgID"]; _mail.FileName = rdr["FileName"].ToString(); Mails.Add(_mail); } return(Mails); }
public bool ResentDraftMail(int Msgid) { try { SqlCommand cmd = ExecuteSql.ExecuteCommand("UPDATE YCET_Mails SET IsDraft=0 Where MsgId=@MsgId"); cmd.Parameters.AddWithValue("@MsgId", Msgid); cmd.ExecuteNonQuery(); return(true); } catch { return(false); } }
internal bool HardDeleteMail(int Msgid) { try { SqlCommand cmd = ExecuteSql.ExecuteCommand("UPDATE YCET_Mails SET Isdeleted=2 Where MsgId=@MsgId"); cmd.Parameters.AddWithValue("@MsgId", Msgid); cmd.ExecuteNonQuery(); return(true); } catch { return(false); } }
public bool DeleteUser(string Name) { try { SqlCommand cmd = ExecuteSql.ExecuteCommand(" DELETE FROM YCET_Mails WHERE USERID IN (select USERID from YCET_USERS Where Name=@NAME) DELETE FROM YCET_USERS Where NAME=@NAME"); cmd.Parameters.AddWithValue("@Name", Name); cmd.ExecuteNonQuery(); return(true); } catch { return(false); } }
public bool MarkMailAsUnDelete(int MsgId) { try { SqlCommand cmd = ExecuteSql.ExecuteCommand("UPDATE YCET_Mails SET Isdeleted=0 Where MsgId=@MsgId"); cmd.Parameters.AddWithValue("@MsgId", MsgId); cmd.ExecuteNonQuery(); return(true); } catch { return(false); } }
internal bool SetNewPassword(User _user) { try { SqlCommand cmd = ExecuteSql.ExecuteCommand("UPDATE YCET_USERS SET PASSWORD=@Password WHERE Name=@NAME"); cmd.Parameters.AddWithValue("@Name", _user.Name); cmd.Parameters.AddWithValue("@Password", _user.Password); cmd.ExecuteNonQuery(); return(true); } catch { return(false); } }
public bool IfexistsUser(User _user) { SqlCommand cmd = ExecuteSql.ExecuteCommand("Select * from YCET_USERS Where EmailId=@EmailID"); cmd.Parameters.AddWithValue("@EmailID", _user.EmailID); cmd.ExecuteNonQuery(); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { return(false); } else { return(true); } }
public static string GetMailCounts(string Username) { string Count = "0"; SqlCommand cmd = ExecuteSql.ExecuteCommand("select count(*) AS Count from ycet_mails WHERE EMAILID=@EMAILID"); cmd.Parameters.AddWithValue("@EMAILID", Username); cmd.ExecuteNonQuery(); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { while (rdr.Read()) { Count = rdr["COUNT"].ToString(); } } return(Count); }
public List <User> GetUsers() { List <User> listuser = new List <User>(); SqlCommand cmd = ExecuteSql.ExecuteCommand("Select * from YCET_USERS"); cmd.ExecuteNonQuery(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { User _user = new User(); _user.Name = rdr["Name"].ToString(); _user.EmailID = rdr["EmailID"].ToString(); _user.Password = rdr["Password"].ToString(); listuser.Add(_user); } return(listuser); }
public static int GetUser(string EmailId) { int User_id = 0; SqlCommand cmd = ExecuteSql.ExecuteCommand("Select UserID from YCET_USERS where EmailID=@EmailID"); cmd.Parameters.AddWithValue("@EmailID", EmailId); cmd.ExecuteNonQuery(); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { while (rdr.Read()) { User_id = (int)rdr["UserID"]; } } return(User_id); }
public bool InsertUsertoDatabase(User _user) { try { SqlCommand cmd = ExecuteSql.ExecuteCommand("Insert into YCET_USERS (Name,DOB,Gender,Password,EmailID,SecurityQues,SecurityAns) Values (@Name,@DOB,@Gender,@Password,@Email,@SecurityQues,@SecurityAns)"); cmd.Parameters.AddWithValue("@Name", _user.Name); cmd.Parameters.AddWithValue("@DOB", Convert.ToDateTime(_user.DOB)); cmd.Parameters.AddWithValue("@Gender", _user.Gender); cmd.Parameters.AddWithValue("@Email", _user.EmailID); cmd.Parameters.AddWithValue("@Password", _user.Password); cmd.Parameters.AddWithValue("@SecurityQues", _user.SecutityQues); cmd.Parameters.AddWithValue("@SecurityAns", _user.SecurityAns); cmd.ExecuteNonQuery(); return(true); } catch { return(false); } }
internal static List <string> GetSecQues(string Email) { List <string> SecurityParameters = new List <string>(); SqlCommand cmd = ExecuteSql.ExecuteCommand("select SecurityQues,SecurityAns from YCET_USERS WHERE EMAILID=@EMAILID"); cmd.Parameters.AddWithValue("@EMAILID", Email); cmd.ExecuteNonQuery(); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { while (rdr.Read()) { SecurityParameters.Add(rdr["SecurityQues"].ToString()); SecurityParameters.Add(rdr["SecurityAns"].ToString()); } } return(SecurityParameters); }