public static int CreatePlayer(Player player)
{
lock (DBHelper.Lock)
{
if (DBHelper.DBWrapper.IsTableExists <TblPlayer>())
{
DBHelper.DBWrapper.ExecuteNonQuery("DELETE from TblPlayer WHERE FirstName = ? AND LastName = ? AND Gender = ? AND DOB = ?",
new object[] { player.FirstName, player.LastName, player.Gender, player.DOB });
}
var tblPlayerRow = new TblPlayer()
{
ID = player.ID,
FirstName = player.FirstName,
LastName = player.LastName,
Gender = player.Gender,
Level = player.Level,
DOB = player.DOB,
DateTimeWhenPlayerSetInTheQueue = player.DateTimeWhenPlayerSetInTheQueue,
PlayerState = (PlayerState)player.PlayerState,
};
return(DBHelper.DBWrapper.InsertNewRow <TblPlayer>(tblPlayerRow));
}
}
public static int SaveOrUpdatePlayer(Player player)
{
lock (DBHelper.Lock)
{
if (DBHelper.DBWrapper.IsTableExists <TblPlayer>())
{
var result = GetPlayer(player.ID);
if (result != null && result.Item1 != null)
{
return(DBHelper.DBWrapper.Update("Update TblPlayer set FirstName = ?, LastName =?, Gender= ? , Level = ? , DOB =?, ProfilePhotoFilePath = ? , DateTimeWhenPlayerSetInTheQueue =? , PlayerState = ? where ID = ?"
, new object[] { player.FirstName, player.LastName, player.Gender, player.Level, player.DOB, player.ProfilePhotoFilePath, player.DateTimeWhenPlayerSetInTheQueue, player.PlayerState, player.ID }));
}
}
var tblPlayerRow = new TblPlayer()
{
ID = player.ID,
FirstName = player.FirstName,
LastName = player.LastName,
Gender = player.Gender,
Level = player.Level,
DOB = player.DOB,
ProfilePhotoFilePath = player.ProfilePhotoFilePath,
DateTimeWhenPlayerSetInTheQueue = player.DateTimeWhenPlayerSetInTheQueue,
PlayerState = (PlayerState)player.PlayerState,
};
return(DBHelper.DBWrapper.InsertNewRow <TblPlayer>(tblPlayerRow));
}
}
public ActionResult EditProfile(int id, TblPlayer model, string city, HttpPostedFileBase postedFile)
{
List <TblCountry> countries = db.Country_tbl.ToList();
ViewBag.CountryList = new SelectList(countries, "CountryId", "Country");
if (postedFile != null)
{
using (BinaryReader br = new BinaryReader(postedFile.InputStream))
{
bytes = br.ReadBytes(postedFile.ContentLength);
}
}
var EditPlayerList = db.Player_tbl.Where(x => x.PlayerId == id && x.Status == 1).FirstOrDefault();
if (EditPlayerList != null)
{
EditPlayerList.Player = model.Player;
EditPlayerList.DOB = model.DOB;
EditPlayerList.Length = model.Length;
EditPlayerList.Weight = model.Weight;
EditPlayerList.PlayingFoot = model.PlayingFoot;
EditPlayerList.Mobile = model.Mobile;
if (bytes != null)
{
EditPlayerList.Photo = bytes;
}
db.SaveChanges();
}
//db.Entry(model).State = System.Data.Entity.EntityState.Modified;
//db.SaveChanges();
return(Content("<script>alert('Updated Successfully');location.href='PlayerView';</script>"));
}
public ActionResult PlayerRegistration(TblPlayer model, string city, List <string> PlayingPlace, HttpPostedFileBase postedFile)
{
var userid = Session["UserId"].ToString();
List <TblCountry> countries = db.Country_tbl.ToList();
ViewBag.CountryList = new SelectList(countries, "CountryId", "Country");
List <TblUser> user = db.User_tbl.ToList();
ViewBag.UserList = new SelectList(user, "UserId", "UserId");
//if (PlayingPlace != null)
//{
// string selectedvalue = string.Join(",", PlayingPlace);
//}
if (ModelState.IsValid)
{
byte[] bytes;
using (BinaryReader br = new BinaryReader(postedFile.InputStream))
{
bytes = br.ReadBytes(postedFile.ContentLength);
}
//TblPlayer tblPlayer = new TblPlayer();
db.Player_tbl.Add(new TblPlayer
{
PlayerReferenceNumber = "1",
//PlayerId = model.PlayerId,
Player = model.Player,
DOB = model.DOB,
CityId = Convert.ToInt32(city),
Length = model.Length,
Weight = model.Weight,
PlayingFoot = model.PlayingFoot,
PlayingPlace = model.PlayingPlace,
//if(file!=null)
//{
// string path = Path.Combine(Server.MapPath("~/UserImages"), Path.GetFileName(file.FileName));
//file.SaveAs(path);
//}
Photo = bytes,
Confirmed = 1,
RegistrationDate = DateTime.Now,
ExpirationDate = DateTime.Now.AddYears(1),
SponsorId = 1,
Mobile = model.Mobile,
UserId = Convert.ToInt32(userid),
Status = 1,
CreatedId = 1,
CreatedDate = DateTime.Now,
ModifiedId = 0,
ModifiedDate = DateTime.Now
});
db.SaveChanges();
return(RedirectToAction("Player"));
}
return(View());
}
public int Edit(TblPlayer player)
{
return(objplayer.UpdatePlayer(player));
}
public int Create(TblPlayer player)
{
return(objplayer.AddPlayer(player));
}
