/// <summary> /// Function to delete entity whose primary key is passes. /// </summary> /// <param name="pk">Primary key of entity to be deleted</param> /// <param name="context">context to maintain transaction</param> public void Delete(object pk, StandardEngEntities context) { DbSet <T> table = context.Set <T>(); T existing = table.Find(pk); context.Entry(existing).State = EntityState.Deleted; }
/// <summary> /// Function to update entity. /// </summary> /// <param name="entity">entity to be updated</param> /// <param name="context">context to maintain transaction</param> public void Update(T entity, StandardEngEntities context) { DbSet <T> table = context.Set <T>(); table.Attach(entity); context.Entry(entity).State = EntityState.Modified; }
public static void GetListOfWarrantyExpiry() { List <GetWarrantyExpiryCustomerList_Result> listExpitry = new List <GetWarrantyExpiryCustomerList_Result>(); using (StandardEngEntities context = BaseContext.GetDbContext()) { listExpitry = context.GetWarrantyExpiryCustomerList().Where(m => m.IsReadyForAMC == false).ToList(); if (listExpitry.Count > 0) { string bodyTemplate = System.IO.File.ReadAllText(System.Web.Hosting.HostingEnvironment.MapPath("~/Template/WarrantyExpiryReminder.html")); foreach (GetWarrantyExpiryCustomerList_Result obj in listExpitry) { tblCommissioning commisioningObj = new tblCommissioning(); bodyTemplate = bodyTemplate.Replace("[@CustomerName]", obj.CustomerName); bodyTemplate = bodyTemplate.Replace("[@MachineModel]", obj.MachineName); bodyTemplate = bodyTemplate.Replace("[@MachineType]", obj.MachineTypeName); bodyTemplate = bodyTemplate.Replace("[@MachineSerialNo]", obj.MachineSerialNo); bodyTemplate = bodyTemplate.Replace("[@ExpiryDate]", obj.WarrantyExpireDate); Task task = new Task(() => EmailHelper.SendAsyncEmail(obj.CustomerEmail, "Machine Warranty Expiry Reminder", bodyTemplate, true)); task.Start(); commisioningObj = context.tblCommissioning.Where(m => m.CommissioningId == obj.CommissioningId).FirstOrDefault(); commisioningObj.IsReadyForAMC = true; context.Entry(commisioningObj).State = EntityState.Modified; context.SaveChanges(); } } } }
/// <summary> /// Function to update entity. /// </summary> /// <param name="entity">entity to be updated</param> public string Update(T entity) { try { using (StandardEngEntities context = BaseContext.GetDbContext()) { DbSet <T> table = context.Set <T>(); table.Attach(entity); context.Entry(entity).State = EntityState.Modified; context.SaveChanges(); return(string.Empty); } } catch (Exception ex) { return(CommonHelper.GetErrorMessage(ex)); } }
//public int SelectId(object pk) //{ // using (CosmosEntities context = BaseContext.GetDbContext()) // { // return Convert.ToInt32(pk); // } //} /// <summary> /// /// </summary> /// <param name="pk">Primary key of entity to be deleted</param> public string Delete(object pk) { try { using (StandardEngEntities context = BaseContext.GetDbContext()) { DbSet <T> table = context.Set <T>(); T existing = table.Find(pk); context.Entry(existing).State = EntityState.Deleted; context.SaveChanges(); return(string.Empty); } } catch (Exception ex) { return(CommonHelper.GetDeleteException(ex)); } }