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