public static int SaveUsers(PMS.Entities.UserDTO dto) { String sqlQuery = ""; sqlQuery = String.Format("INSERT INTO dbo.Users(Name ,Login ,Password,IsAdmin,IsActive,PictureName ,Designation,Email) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", dto.Name, dto.Login, dto.Password, dto.IsAdmin, dto.IsActive, dto.PictureName, dto.Designation, dto.Email); using (DBHelper helper = new DBHelper()) { return(helper.ExecuteQuery(sqlQuery)); } }
public static PMS.Entities.UserDTO GetUserById(int pid) { var query = String.Format("Select * from dbo.Users Where UserId={0}", pid); using (DBHelper helper = new DBHelper()) { var reader = helper.ExecuteReader(query); PMS.Entities.UserDTO dto = null; if (reader.Read()) { dto = FillDTO1(reader); } return(dto); } }
public JsonResult SaveUsers1(PMS.Entities.UserDTO u) { u.Name = Request["name"]; u.Login = Request["name"]; u.Password = Request["Password"]; u.Designation = Request["Designation"]; u.Email = Request["Email"]; u.IsAdmin = false; u.IsActive = true; var uniqueName = ""; if (Request.Files["Image"] != null) { var file = Request.Files["Image"]; if (file.FileName != "") { var ext = System.IO.Path.GetExtension(file.FileName); //Generate a unique name using Guid uniqueName = Guid.NewGuid().ToString() + ext; //Get physical path of our folder where we want to save images var rootPath = Server.MapPath("~/UploadedFiles"); var fileSavePath = System.IO.Path.Combine(rootPath, uniqueName); // Save the uploaded file to "UploadedFiles" folder file.SaveAs(fileSavePath); u.PictureName = uniqueName; } } var pid = UserBO.SaveUsers(u); var data = new { success = true, ProductID = pid, PictureName = u.PictureName }; return(Json(data, JsonRequestBehavior.AllowGet)); }
public static List <PMS.Entities.SellDTO> GetProductForSell() { var query = String.Format("Select * from dbo.addToCart "); using (DBHelper helper = new DBHelper()) { var reader = helper.ExecuteReader(query); // List<PMS.Entities.ProductDTO> list = new List<PMS.Entities.ProductDTO>(); List <PMS.Entities.SellDTO> list = new List <PMS.Entities.SellDTO>(); List <PMS.Entities.ProductDTO> ProductDTOlist = new List <PMS.Entities.ProductDTO>(); List <PMS.Entities.UserDTO> UserDTOlist = new List <PMS.Entities.UserDTO>(); PMS.Entities.SellDTO s; var dto = new PMS.Entities.ProductDTO(); var dto1 = new PMS.Entities.UserDTO(); // dto.ProductID = reader.GetInt32(0); while (reader.Read()) { dto.ProductID = reader.GetInt32(1); dto1.UserID = reader.GetInt32(2); if (dto != null) { s = new PMS.Entities.SellDTO(); s.Users = GetUserById(dto1.UserID); UserDTOlist.Add(s.Users); PMS.Entities.ProductDTO P1 = GetProductById(dto.ProductID); s.Products = P1; ProductDTOlist.Add(P1); list.Add(s); //s.Products.Add(GetProductById(dto.ProductID)); } } //for (int i = 0; i < s.Count; i++) //{ // list.Add(s[i]); //} // list.Add(s); return(list); } }
public static int SaveUsers(PMS.Entities.UserDTO dto) { return(DAL.User_DAO.SaveUsers(dto)); }