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