//public static int Update(EAD_Project.Models.Bill_To dto) //{ // String sqlQuery = ""; // sqlQuery = String.Format("Update dbo.Bill_To Set Login='******',Password='******',Designation='{2}',Email='{3}',isActive='{4}',UsersType = {5} WHERE UserId='{6}')", // dto.Login, dto.Password, dto.Designation, dto.Email, dto.isActive, dto.UsersType, dto.UserId); // using (DBHelper helper = new DBHelper()) // { // return helper.ExecuteQuery(sqlQuery); // } //} //public static EAD_Project.Models.Bill_To GetUserById(int pid) //{ // var query = String.Format("Select * from dbo.Bill_To Where UserId={0}", pid); // using (DBHelper helper = new DBHelper()) // { // var reader = helper.ExecuteReader(query); // Bill_To dto = null; // if (reader.Read()) // { // dto = FillDTO(reader); // } // return dto; // } //} //public static List<EAD_Project.Models.Bill_To> GetAllUser() //{ // using (DBHelper helper = new DBHelper()) // { // var query = "Select * from dbo.Bill_To Where IsActive = 1;"; // var reader = helper.ExecuteReader(query); // List<EAD_Project.Models.Bill_To> list = new List<EAD_Project.Models.Bill_To>(); // while (reader.Read()) // { // var dto = FillDTO(reader); // if (dto != null) // { // list.Add(dto); // } // } // return list; // } //} //public static int DeleteUser(int pid) //{ // String sqlQuery = String.Format("Update dbo.Bill_To Set IsActive=0 Where UserId={0}", pid); // using (DBHelper helper = new DBHelper()) // { // return helper.ExecuteQuery(sqlQuery); // } //} private static EAD_Project.Models.Bill_To FillDTO(SqlDataReader reader) { //Company_Name,Email,Title,First_Name,Middle_Name,Last_Name,Address_1,Address_2,Zip,Country,State,Confirm_password,Phone,Mobile_Phone,Fax,message,Shipping //BillNo,Display_Name,User_Name,Password ,confirm_password,Company_Name,Email,Title,First_Name,Middle_Name,Last_Name,Address_1,Address_2,Zip,Country,State,Phone1,Phone2,Mobile_Phone,Fax,message,Shipping *@ var dto = new EAD_Project.Models.Bill_To(); dto.BillNo = reader.GetInt32(0); dto.Display_Name = reader.GetString(0); dto.User_Name = reader.GetString(0); dto.Password = reader.GetString(0); dto.confirm_password = reader.GetString(0); dto.Email = reader.GetString(1); dto.Title = reader.GetString(2); dto.First_Name = reader.GetString(3); dto.Middle_Name = reader.GetString(4); dto.Last_Name = reader.GetString(5); dto.Address_1 = reader.GetString(6); dto.Address_2 = reader.GetString(7); dto.Zip = reader.GetString(8); dto.Country = reader.GetString(9); dto.State = reader.GetString(10); dto.Phone1 = reader.GetString(11); dto.Phone2 = reader.GetString(12); dto.Mobile_Phone = reader.GetString(13); dto.Fax = reader.GetString(14); dto.message = reader.GetString(15); dto.Shipping = reader.GetString(16); return(dto); }
public static int Save(EAD_Project.Models.Bill_To dto) { String sqlQuery = ""; sqlQuery = String.Format("INSERT INTO dbo.Bill_To(Display_Name,User_Name,Password ,confirm_password,Company_Name,Email,Title,First_Name,Middle_Name,Last_Name,Address_1,Address_2,Zip,Country,State,Phone1,Phone2,Mobile_Phone,Fax,message,Shipping) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}')", dto.Display_Name, dto.User_Name, dto.Password, dto.confirm_password, dto.Company_Name, dto.Email, dto.Title, dto.First_Name, dto.Middle_Name, dto.Last_Name, dto.Address_1, dto.Address_2, dto.Zip, dto.Country, dto.State, dto.Phone1, dto.Phone2, dto.Mobile_Phone, dto.Fax, dto.message, dto.Shipping); using (DBHelper helper = new DBHelper()) { return(helper.ExecuteQuery(sqlQuery)); } }