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 GetMadadkarInfo() { MadadkarModel model = new MadadkarModel(); var identity = (ClaimsIdentity)User.Identity; var MadadkarId = identity.Claims.Where(s => s.Type == "MadadkarId").FirstOrDefault(); int MadadkarID = int.Parse(MadadkarId.Value); var SIPResult = SipDataEntity.SIPExtensions.Where(s => s.MadadkarId == MadadkarID).FirstOrDefault(); if (SIPResult == null) { var selectedExt = SipDataEntity.SIPExtensions.Where(s => s.MadadkarId == null).FirstOrDefault(); selectedExt.MadadkarId = MadadkarID; selectedExt.MadadkarName = identity.Name; selectedExt.RegDate = DateTime.Now; SipDataEntity.SaveChanges(); } SIPResult = SipDataEntity.SIPExtensions.Where(s => s.MadadkarId == MadadkarID).FirstOrDefault(); return(Ok(new MadadkarModel { MadadkarName = identity.Name, MadadkarId = MadadkarID, SipDisplayname = SIPResult.DisplayName, SipExtention = SIPResult.Extention.ToString(), SipPassword = SIPResult.Password, SipUrl = string.Format("sip:{0}@vs.sharifngo.com", SIPResult.Extention), SipWsUrl = "ws://vs.sharifngo.com:8088/ws" })); }
public IHttpActionResult GetMadadkarInfo() { MadadkarModel model = new MadadkarModel(); var identity = (ClaimsIdentity)User.Identity; var MadadkarId = identity.Claims.Where(s => s.Type == "MadadkarId").FirstOrDefault(); int MadadkarID = int.Parse(MadadkarId.Value); var SIPResult = SipDataEntity.SIPExtensions.Where(s => s.MadadkarId == MadadkarID).FirstOrDefault(); if (SIPResult == null) { if (SipDataEntity.SIPExtensions.Where(s => s.MadadkarId == null).Count() == 0) { int max = int.Parse(SipDataEntity.SIPExtensions.OrderByDescending(x => x.Id).Select(x => x.DisplayName).FirstOrDefault()); max += 1; var s = new SIPExtensions() { DisplayName = max.ToString(), Extention = max, MadadkarId = MadadkarID, MadadkarName = identity.Name, RegDate = DateTime.Now, Password = System.Web.Security.Membership.GeneratePassword(15, 5), Enabled = false }; SipDataEntity.SIPExtensions.Add(s); SipDataEntity.SaveChanges(); } else { var selectedExt = SipDataEntity.SIPExtensions.Where(s => s.MadadkarId == null).FirstOrDefault(); selectedExt.MadadkarId = MadadkarID; selectedExt.MadadkarName = identity.Name; selectedExt.RegDate = DateTime.Now; SipDataEntity.SaveChanges(); } } SIPResult = SipDataEntity.SIPExtensions.Where(s => s.MadadkarId == MadadkarID).FirstOrDefault(); return(Ok(new MadadkarModel { MadadkarName = identity.Name, MadadkarId = MadadkarID, SipDisplayname = SIPResult.DisplayName, SipExtention = SIPResult.Extention.ToString(), SipPassword = SIPResult.Password, SipUrl = string.Format("sip:{0}@vs.sharifngo.com", SIPResult.Extention), SipWsUrl = "ws://vs.sharifngo.com:8088/ws" })); }