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);
}
