public TEUnit_Onboarding AddUnit_Onboarding(TEUnit_Onboarding value) { try { TEUnit_Onboarding result = value; if (!(value.Uniqueid + "".Length > 0)) { //Create result.CreatedOn = System.DateTime.Now; result.LastModifiedOn = System.DateTime.Now; result = db.TEUnit_Onboarding.Add(value); } else { //Edit db = new TEHRIS_DevEntities(); db.TEUnit_Onboarding.Attach(value); foreach (System.Reflection.PropertyInfo item in result.GetType().GetProperties()) { string propname = item.Name; if (propname.ToLower() == "createdon") { continue; } object propValue = item.GetValue(value); if (propValue != null || Convert.ToString(propValue).Length != 0) { db.Entry(value).Property(propname).IsModified = true; } } value.LastModifiedOn = System.DateTime.Now; db.Entry(value).Property(x => x.LastModifiedOn).IsModified = true; } } catch (Exception ex) { db.ApplicationErrorLogs.Add( new ApplicationErrorLog { Error = ex.Message, ExceptionDateTime = System.DateTime.Now, InnerException = ex.InnerException != null ? ex.InnerException.Message : "", Source = "From TEUnitonboard| AddUnit_Onboarding | " + this.GetType().ToString(), Stacktrace = ex.StackTrace } ); } db.SaveChanges(); return(db.TEUnit_Onboarding.Find(value.Uniqueid)); }
public TEDocument Post(TEDocument value) { TEDocument result = value; using (var scope = new System.Transactions.TransactionScope()) { //Create if (!(value.Uniqueid + "".Length > 0)) { result.UploadedOn = System.DateTime.Now; result.LastModifiedOn = System.DateTime.Now; result = db.TEDocuments.Add(value); } //Edit | Delete else { db = new TEHRIS_DevEntities(); db.TEDocuments.Attach(value); foreach (System.Reflection.PropertyInfo item in result.GetType().GetProperties()) { string propname = item.Name; if (propname.ToLower() == "createdon") { continue; } object propValue = item.GetValue(value); if (propValue != null || Convert.ToString(propValue).Length != 0) { db.Entry(value).Property(propname).IsModified = true; } } value.LastModifiedOn = System.DateTime.Now; db.Entry(value).Property(x => x.LastModifiedOn).IsModified = true; } //Save and Complete db.SaveChanges(); scope.Complete(); } return(db.TEDocuments.Find(result.Uniqueid)); }
public TEContact Post(TEContact value) { TEContact result = value; if (!(value.Uniqueid + "".Length > 0)) { //Create result.CreatedOn = System.DateTime.UtcNow; result.LastModifiedOn = System.DateTime.UtcNow; result = db.TEContacts.Add(value); } else { //Edit db.TEContacts.Attach(value); foreach (System.Reflection.PropertyInfo item in result.GetType().GetProperties()) { string propname = item.Name; if (propname.ToLower() == "createdon") { continue; } object propValue = item.GetValue(value); if (propValue != null || Convert.ToString(propValue).Length != 0) { db.Entry(value).Property(propname).IsModified = true; } } value.LastModifiedOn = System.DateTime.UtcNow; db.Entry(value).Property(x => x.LastModifiedOn).IsModified = true; } db.SaveChanges(); //CRUD Mobile //CRUD Email //CRUD Address return(db.TEContacts.Find(value.Uniqueid)); }
public TEDepartment AddTEDepartment(TEDepartment value) { db.Configuration.ProxyCreationEnabled = false; TEDepartment result = value; if (!(value.Uniqueid + "".Length > 0)) { //Create result.CreatedOn = System.DateTime.Now; result.LastModifiedOn = System.DateTime.Now; result = db.TEDepartments.Add(value); } else { //Edit db = new TEHRIS_DevEntities(); db.TEDepartments.Attach(value); foreach (System.Reflection.PropertyInfo item in result.GetType().GetProperties()) { string propname = item.Name; if (propname.ToLower() == "createdon") { continue; } object propValue = item.GetValue(value); if (propValue != null || Convert.ToString(propValue).Length != 0) { db.Entry(value).Property(propname).IsModified = true; } } value.LastModifiedOn = System.DateTime.Now; db.Entry(value).Property(x => x.LastModifiedOn).IsModified = true; } db.SaveChanges(); return(db.TEDepartments.Find(value.Uniqueid)); }
public TEIssuesDisposition PostDisposition(TEIssuesDisposition request) { db.Configuration.ProxyCreationEnabled = false; TEIssuesDisposition Disposition = new TEIssuesDisposition(); Disposition = request; if (request.Uniqueid + "".Length == 0) { //Create request.CreatedOn = System.DateTime.Now; request.LastModifiedOn = System.DateTime.Now; request.ResolvedDate = System.DateTime.Now; Disposition = db.TEIssuesDispositions.Add(request); } else { db.TEIssuesDispositions.Attach(request); foreach (System.Reflection.PropertyInfo item in Disposition.GetType().GetProperties()) { string propname = item.Name; if (propname.ToLower() == "createdon") { continue; } object propValue = item.GetValue(request); if (propValue != null || Convert.ToString(propValue).Length != 0) { db.Entry(request).Property(propname).IsModified = true; } } request.LastModifiedOn = System.DateTime.Now; db.Entry(request).Property(x => x.LastModifiedOn).IsModified = true; } db.SaveChanges(); return(db.TEIssuesDispositions.Find(request.Uniqueid)); }
public TEProjects_UNIT Post(TEProjects_UNIT value) { TEProjects_UNIT result = value; if (!(value.Uniqueid + "".Length > 0)) { result.CreatedOn = System.DateTime.Now; result.LastModifiedOn = System.DateTime.Now; result = db.TEProjects_UNIT.Add(value); } else { db = new TEHRIS_DevEntities(); db.TEProjects_UNIT.Attach(value); foreach (System.Reflection.PropertyInfo item in result.GetType().GetProperties()) { string propname = item.Name; if (propname.ToLower() == "createdon") { continue; } object propValue = item.GetValue(value); if (propValue != null || Convert.ToString(propValue).Length != 0) { db.Entry(value).Property(propname).IsModified = true; } } value.LastModifiedOn = System.DateTime.Now; db.Entry(value).Property(x => x.LastModifiedOn).IsModified = true; } db.SaveChanges(); return(db.TEProjects_UNIT.Find(value.Uniqueid)); }
public string AutoCloseIssues() { string status = IssuesStatus.IssuesStatusRes.RESOLVED.ToString(); string Rule = IssuesStatus.TEComplaintsRules.TicketAutoClose.ToString(); DateTime Today = System.DateTime.Today; List <TEComplainceModel> teissueresult = Mgr.GetIssues().Where(x => x.Status == status).ToList(); TERule ResolvingDays = db.TERules.Where(x => x.RuleName == Rule).FirstOrDefault(); int EstimantionDay = Convert.ToInt32(ResolvingDays.Value); foreach (TEComplainceModel item in teissueresult) { DateTime ResolvedDate = Convert.ToDateTime(item.Resolved_Date); if (Today > ResolvedDate.AddDays(EstimantionDay)) { try { TEIssue Issues = db.TEIssues.Find(item.Uniqueid); Issues.Status = IssuesStatus.IssuesStatusList[0]; db.Entry(Issues).State = EntityState.Modified; //db.Entry(Issues).Property(X=>X.Status).IsModified = true; //db.TEIssues.Attach(Issues); db.SaveChanges(); //EmailSendModel SendDetails = new EmailSendModel(); //var potemp1 = db.TEEmailTemplates.Where(x => x.ModuleName == "Ticket Closed").FirstOrDefault(); //SendDetails.Subject = potemp1.Subject.Replace("@ticket number@", Issues.Uniqueid.ToString()); //SendDetails.Html = potemp1.EmailTemplate.Replace("@Requestor Name@", (from x in db.UserProfiles where (x.UserId == Issues.RaisedBy) select x.CallName).Distinct().FirstOrDefault()); //SendDetails.Html = SendDetails.Html.Replace("@ticket number@", Issues.Uniqueid.ToString()); //SendDetails.To = (from x in db.UserProfiles where (x.UserId == Issues.RaisedBy) select x.email).Distinct().FirstOrDefault() == null ? (from x in db.TEContacts where (x.UserId == Issues.RaisedBy) select x.Emailid).Distinct().FirstOrDefault() : (from x in db.UserProfiles where (x.UserId == Issues.RaisedBy) select x.email).Distinct().FirstOrDefault(); //EmailMgr.SendEmail(SendDetails); } catch (Exception ex) { } } } return("Success"); }
public TENotification AddNotifications(TENotification value) { try { TENotification result = value; if (!(value.Uniqueid + "".Length > 0)) { //Create result.CreatedOn = System.DateTime.Now; result.LastModifiedOn = System.DateTime.Now; result = db.TENotifications.Add(value); } else { //IEnumerable<TENotification> updatenotif = (db.TENotifications.Where(x=>(x.SendBy == value.SendBy)&&(x.ReadStatus == false))); //foreach (System.Reflection.PropertyInfo value1 in updatenotif.GetType().GetProperties()) //{ // //Edit // TENotification value1 = updatenotif(; // db = new TEHRIS_DevEntities(); // db.TENotifications.Attach(value1); // foreach (System.Reflection.PropertyInfo item in result.GetType().GetProperties()) // { // string propname = item.Name; // if (propname.ToLower() == "createdon") // continue; // object propValue = item.GetValue(value); // if (propValue != null || Convert.ToString(propValue).Length != 0) // db.Entry(value).Property(propname).IsModified = true; // } // value.LastModifiedOn = System.DateTime.Now; // db.Entry(value).Property(x => x.LastModifiedOn).IsModified = true; // db.SaveChanges(); //} if (value.ReceivedBy != null) { foreach (var some in db.TENotifications.Where(x => (x.ReceivedBy == value.ReceivedBy) && (x.ReadStatus == false)).ToList()) { some.ReadStatus = true; some.LastModifiedOn = System.DateTime.Now; } } else { //Edit db = new TEHRIS_DevEntities(); db.TENotifications.Attach(value); foreach (System.Reflection.PropertyInfo item in result.GetType().GetProperties()) { string propname = item.Name; if (propname.ToLower() == "createdon") { continue; } object propValue = item.GetValue(value); if (propValue != null || Convert.ToString(propValue).Length != 0) { db.Entry(value).Property(propname).IsModified = true; } } value.LastModifiedOn = System.DateTime.Now; db.Entry(value).Property(x => x.LastModifiedOn).IsModified = true; } } } catch (Exception ex) { db.ApplicationErrorLogs.Add( new ApplicationErrorLog { Error = ex.Message, ExceptionDateTime = System.DateTime.Now, InnerException = ex.InnerException != null ? ex.InnerException.Message : "", Source = "From TENotifications API | AddNotifications | " + this.GetType().ToString(), Stacktrace = ex.StackTrace } ); } db.SaveChanges(); return(db.TENotifications.Find(value.Uniqueid)); }
public TEUnit_Onboarding AddTEUnitOnboarding(TEUnit_Onboarding value) { TEUnit_Onboarding result = value; if (!(value.Uniqueid + "".Length > 0)) { //Create result.CreatedOn = System.DateTime.Now; result.LastModifiedOn = System.DateTime.Now; result = db.TEUnit_Onboarding.Add(value); } else { //Edit db = new TEHRIS_DevEntities(); db.TEUnit_Onboarding.Attach(value); foreach (System.Reflection.PropertyInfo item in result.GetType().GetProperties()) { string propname = item.Name; if (propname.ToLower() == "createdon") { continue; } object propValue = item.GetValue(value); if (propValue != null || Convert.ToString(propValue).Length != 0) { db.Entry(value).Property(propname).IsModified = true; } } value.LastModifiedOn = System.DateTime.Now; db.Entry(value).Property(x => x.LastModifiedOn).IsModified = true; if (value.Status == "Active") { db.Configuration.ProxyCreationEnabled = false; TEUnit_Onboarding unit = db.TEUnit_Onboarding.Where(x => x.Uniqueid == value.Uniqueid).ToList().First(); if (unit != null) { string email = (from teuser in db.UserProfiles where (teuser.UserId == unit.UserID) select teuser.email).ToList().First(); //string tecontact = (from teoint in db.TEContacts // where ((teoint.Emailid == email) && (teoint.Projectid == value.Project) && (teoint.Unitid == value.Unit)) // select teoint.CallName).ToList().First(); //if (tecontact == null) try { TEContact contact = db.TEContacts.Where(x => (x.Emailid == email) && (x.Projectid == value.Project) && (x.Unitid == value.Unit)).ToList().First(); if (contact != null) { SendContact(value); } } catch (Exception ex) { SendContact(value); ex.Message.ToString(); } } } } db.SaveChanges(); //CRUD Mobile //CRUD Email //CRUD Address return(db.TEUnit_Onboarding.Find(value.Uniqueid)); }