public IHttpActionResult GetHamisForEdit()
{
var identity = (ClaimsIdentity)User.Identity;
var MadadkarId = identity.Claims.Where(s => s.Type == "MadadkarId").FirstOrDefault();
int MadadkarID = int.Parse(MadadkarId.Value);
//int MadadkarID = 230;
var result = SharifDataEntity.FG_HamiMadadkarsInfo.Where(x => x.MadadkarId == MadadkarID && x.Deleted != true && x.HamiMobile1 != null).OrderBy(r => r.HamiLName);
foreach (var item in result)
{
var search = SipDataEntity.HamiEditSet.FirstOrDefault(x => x.HamiId == item.HamiId);
if (search == null)
{
HamiEditSet hami = new HamiEditSet();
hami.HamiId = (int)item.HamiId;
hami.HamiFname = item.HamiFName;
hami.HamiLname = item.HamiLName;
hami.OldMobile1 = item.HamiMobile1;
hami.OldMobile2 = item.HamiMobile2 ?? "";
hami.MadadkarId = MadadkarID;
hami.MadadkarName = identity.Name;
SipDataEntity.HamiEditSet.AddOrUpdate(hami);
SipDataEntity.SaveChanges();
}
}
var fresult = SipDataEntity.HamiEditSet.Where(x => x.MadadkarId == MadadkarID);
var res = SipDataEntity.HamiEditSet.Where(x => x.MadadkarId == MadadkarID && x.Deleted != true).Select(d => new
{
d.Id,
d.HamiId,
d.HamiFname,
d.HamiLname,
d.MadadkarId,
d.MadadkarName,
d.NationalCode,
d.NewHamiFname,
d.NewHamiLname,
d.NewMobile1,
d.NewMobile2,
d.NewPhone1,
d.NewPhone2,
d.OldMobile1,
d.OldMobile2,
d.OldPhone1,
d.OldPhone2,
d.TempSave,
d.DeleteOldMobile1,
d.DeleteOldMobile2,
d.DeleteOldPhone1,
d.DeleteOldPhone2,
d.EditDate,
d.Email,
d.FinalSave,
HamiMadadjouSet = SipDataEntity.HamiMadadjouSet.Where(f => f.Deleted != true && f.HamiId == d.HamiId).Select(
t => new { t.HamiId, t.Id, t.MadadjouFname, t.MadadjouLname, t.MadadjouId, t.Deleted }
).ToList()
}).ToList();
return(Ok(res));
}
public IHttpActionResult SaveHamiEditInfo(HamiEditSet hami)
{
try
{
SipDataEntity.HamiEditSet.AddOrUpdate(hami);
SipDataEntity.SaveChanges();
return(Ok("Saved"));
}catch (Exception err)
{
throw err;
}
}
public IHttpActionResult GetHamiInfo(int HamiId)
{
//var identity = (ClaimsIdentity)User.Identity;
//var MadadkarId = identity.Claims.Where(s => s.Type == "MadadkarId").FirstOrDefault();
// int MadadkarID = int.Parse(MadadkarId.Value);
//var MadadkarFullName = identity.Name;
HamiEditSet hamiEdit = new HamiEditSet();
try
{
var result = SipDataEntity.HamiEditSet.FirstOrDefault(a => a.HamiId == HamiId);
if (result == null)
{
var request = SharifDataEntity.FG_Hamis.FirstOrDefault(a => a.HamiId == HamiId);
hamiEdit.HamiId = HamiId;
hamiEdit.HamiFname = request.HamiFName ?? "";
hamiEdit.HamiLname = request.HamiLName ?? "";
hamiEdit.OldMobile1 = request.HamiMobile1 ?? "";
hamiEdit.OldMobile2 = request.HamiMobile2 ?? "";
hamiEdit.OldPhone1 = request.HamiPhone1 ?? "";
hamiEdit.OldPhone2 = request.HamiPhone2 ?? "";
hamiEdit.Email = request.HamiEmail ?? "";
SipDataEntity.HamiEditSet.Add(hamiEdit);
SipDataEntity.SaveChanges();
}
}
catch (Exception err)
{
throw err;
}
var res = SipDataEntity.HamiEditSet.Where(x => x.HamiId == HamiId).Select(d => new { d.Id, d.HamiId, d.HamiFname, d.HamiLname, d.MadadkarId, d.MadadkarName, d.NationalCode,
d.NewHamiFname, d.NewHamiLname, d.NewMobile1, d.NewMobile2, d.NewPhone1, d.NewPhone2, d.OldMobile1, d.OldMobile2, d.OldPhone1, d.OldPhone2, d.TempSave, d.DeleteOldMobile1, d.DeleteOldMobile2,
d.DeleteOldPhone1, d.DeleteOldPhone2, d.EditDate, d.Email, d.FinalSave, HamiMadadjouSet = SipDataEntity.HamiMadadjouSet.Where(f => f.Deleted != true && f.HamiId == HamiId).Select(
t => new { t.HamiId, t.Id, t.MadadjouFname, t.MadadjouLname, t.MadadjouId, t.Deleted }
).ToList() }).FirstOrDefault();
return(Ok(res));
}
