private static EAD_Project.Models.Shopper_Information FillDTO(SqlDataReader reader)
{
//Display_Name,User_Name,password,password2
var dto = new EAD_Project.Models.Shopper_Information();
dto.Display_Name = reader.GetString(0);
dto.User_Name = reader.GetString(1);
dto.password = reader.GetString(2);
dto.password2 = reader.GetString(3);
return(dto);
}
public static int Save(EAD_Project.Models.Shopper_Information dto)
{
String sqlQuery = "";
sqlQuery = String.Format("INSERT INTO dbo.Shopper_Information(Display_Name,User_Name,password,password2) VALUES('{0}','{1}','{2}','{3}')",
dto.Display_Name, dto.User_Name, dto.password, dto.password2);
using (DBHelper helper = new DBHelper())
{
return(helper.ExecuteQuery(sqlQuery));
}
}
public static EAD_Project.Models.Shopper_Information GetUserById(string User_Name)
{
var query = String.Format("Select * from dbo.Shopper_Information Where User_Name='{0}'", User_Name);
using (DBHelper helper = new DBHelper())
{
var reader = helper.ExecuteReader(query);
EAD_Project.Models.Shopper_Information dto = null;
if (reader.Read())
{
dto = FillDTO(reader);
}
return(dto);
}
}