public ActionResult Edit(CustomView cv)
{
int mnth = Convert.ToInt32(DateTime.Now.Month);
int day = Convert.ToInt32(DateTime.Now.Day);
int year = Convert.ToInt32(DateTime.Now.Year - cv.Age);
DateTime bday = new DateTime(year, mnth, day);
DateTime dob;
dob = bday;
CommonClass1 cc = new CommonClass1();
cc.UserPersonalId = cv.UserPersonalId;
cc.EMail = cv.EMail;
cc.FName = cv.FName;
cc.LName = cv.LName;
cc.Phone = cv.Phone;
cc.DOB = dob;
cc.Gender = cv.Gender;
var isThere = bl.editUser(cc);
if (isThere)
{
return(RedirectToAction("Home"));
}
return(View());
}
public bool EditUser(CommonClass1 c)
{
var eml = c.EMail.ToString();
var UserId = db.t_Users
.FirstOrDefault(u => u.EMail == eml).UserId;
var CreatedDt = db.t_User_PersonalDetails
.FirstOrDefault(u => u.UserPersonalId__UserPersonalId__UserPersonalId == c.UserPersonalId).CreatedDate;
//t_User_PersonalDetails ts = new t_User_PersonalDetails();
//ts.UserPersonalId__UserPersonalId__UserPersonalId = c.UserPersonalId;
//ts.UserId = Convert.ToInt32(UserId);
t_User_PersonalDetails ts = db.t_User_PersonalDetails.FirstOrDefault(s => s.UserPersonalId__UserPersonalId__UserPersonalId == UserId);
ts.FName = c.FName;
ts.LName = c.LName;
ts.Phone = c.Phone;
ts.Gender = c.Gender;
ts.DOB = Convert.ToDateTime(c.DOB);
ts.CreatedDate = CreatedDt;
db.Entry(ts).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(true);
}
public IEnumerable <CommonClass1> Edit(int id)
{
t_User_PersonalDetails t = db.t_User_PersonalDetails.Find(id);
List <CommonClass1> Listr = new List <CommonClass1>();
int uid = t.UserId;
t_Users k = db.t_Users.Find(uid);
int uid1 = k.UserId;
var JoinResult = (from p in db.t_Users
join s in db.t_User_PersonalDetails
on p.UserId equals t.UserId
where p.UserId == uid1
select new
{
UserPersonalId = t.UserPersonalId__UserPersonalId__UserPersonalId,
FName = t.FName,
LName = t.LName,
Gender = t.Gender,
Phone = t.Phone,
DOB = t.DOB,
EMail = p.EMail,
}
).ToList();
foreach (var item in JoinResult)
{
CommonClass1 c = new CommonClass1();
c.UserPersonalId = item.UserPersonalId;
c.EMail = item.EMail;
c.Gender = item.Gender;
c.FName = item.FName;
c.LName = item.LName;
c.Phone = item.Phone;
c.DOB = item.DOB;
Listr.Add(c);
}
return(Listr);
//db.t_User_PersonalDetails.ToList();
}
public IEnumerable <CommonClass1> userDbDetails()
{
List <CommonClass1> tuser = dc.userDetails().ToList();
List <CommonClass1> list = new List <CommonClass1>();
foreach (var item in tuser)
{
CommonClass1 Details = new CommonClass1();
// Details.UserId = item.UserId;
Details.FName = item.FName;
Details.LName = item.LName;
Details.EMail = item.EMail;
Details.Phone = item.Phone;
Details.Gender = item.Gender;
Details.DOB = item.DOB;
//Details.Adderss = item.Adderss;
Details.UserPersonalId = item.UserPersonalId;
// Details.CreatedDate = item.CreatedDate;
//Details.LastUpdatedDate = item.LastUpdatedDate;
list.Add(Details);
}
return(list);
}
public IEnumerable <CommonClass1> userDetails()
{
List <CommonClass1> lt = new List <CommonClass1>();
var joindata = (from t1 in db.t_User_PersonalDetails
join t2 in db.t_Users on t1.UserId equals t2.UserId
select new
{
UserPersonalId = t1.UserPersonalId__UserPersonalId__UserPersonalId,
FName = t1.FName,
LName = t1.LName,
Gender = t1.Gender,
Phone = t1.Phone,
DOB = t1.DOB,
EMail = t2.EMail,
}
).ToList();
foreach (var k in joindata)
{
CommonClass1 c = new CommonClass1();
c.UserPersonalId = k.UserPersonalId;
c.FName = k.FName;
c.EMail = k.EMail;
c.Phone = k.Phone;
c.LName = k.LName;
c.Gender = k.Gender;
// c.Password = k.Password;
c.DOB = k.DOB;
//c.Age = age;
// c.Address = k.Address;
lt.Add(c);
}
return(lt.ToList());
}
public bool editDbUser(CommonClass1 cu)
{
return(dc.EditUser(cu));
}
