public static Boolean CreateReadFrequency(ReadFrequency Frequency) { Boolean flag = false; if (!(IsExistingReadFrequency(Frequency))) { using (TransactionScope scope = new TransactionScope()) { using (var context = new SycousCon()) { try { context.ReadFrequencies.AddObject(Frequency); context.SaveChanges(); scope.Complete(); context.AcceptAllChanges(); flag = true; } catch (Exception ex) { context.Dispose(); throw; } }// }// using }//if return flag; }
public static ReadFrequency EditReadFrequency(Int32 FrequencyID) { ReadFrequency Frequency = new ReadFrequency(); using (var context = new SycousCon()) { try { Frequency = context.ReadFrequencies.SingleOrDefault(s => s.ID == FrequencyID); } catch (Exception ex) { context.Dispose(); throw; } } return Frequency; }
public static bool IsExistingReadFrequency(ReadFrequency Frequency) { using (var context = new SycousCon()) { try { ReadFrequency objFrequency = context.ReadFrequencies.SingleOrDefault(p => p.FrequencyName.ToUpper() == Frequency.FrequencyName.ToUpper() && p.ClientID == Frequency.ClientID && p.SiteID == Frequency.SiteID && p.IsDeleted == 0); if (objFrequency != null) { return true; } else { return false; } } catch (Exception ex) { context.Dispose(); throw; } } }
public static Boolean UpdateReadFrequency(ReadFrequency Frequency) { using (TransactionScope scope = new TransactionScope()) { Boolean bol = false; using (var context = new SycousCon()) { try { var Update = context.ReadFrequencies.Where(c => c.ID == Frequency.ID); foreach (ReadFrequency p in Update) { if (Frequency.FrequencyName != null) { p.FrequencyName = Frequency.FrequencyName.Trim(); } if (Frequency.ClientID != null) { p.ClientID = Frequency.ClientID; } if (Frequency.SiteID != null) { p.SiteID = Frequency.SiteID; } if (Frequency.FrequencyMode != null) { p.FrequencyMode = Frequency.FrequencyMode; } if (Frequency.FrequencyDay != null) { p.FrequencyDay = Frequency.FrequencyDay; } else { p.FrequencyDay = null; } if (Frequency.DayOfMonth != null) { p.DayOfMonth = Frequency.DayOfMonth; } else { p.DayOfMonth = null; } p.Modifydate = Frequency.Modifydate; p.ModifyBy = Frequency.ModifyBy; }// context.SaveChanges(); context.AcceptAllChanges(); scope.Complete(); context.Dispose(); bol = true; } catch (Exception ex) { context.Dispose(); throw; } }// using return bol; } //trans }
/// <summary> /// Create a new ReadFrequency object. /// </summary> /// <param name="id">Initial value of the ID property.</param> /// <param name="isDeleted">Initial value of the IsDeleted property.</param> public static ReadFrequency CreateReadFrequency(global::System.Int32 id, global::System.Int32 isDeleted) { ReadFrequency readFrequency = new ReadFrequency(); readFrequency.ID = id; readFrequency.IsDeleted = isDeleted; return readFrequency; }
/// <summary> /// Deprecated Method for adding a new object to the ReadFrequencies EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToReadFrequencies(ReadFrequency readFrequency) { base.AddObject("ReadFrequencies", readFrequency); }
public bool CreateRecord(Object Frequenceobj) { Boolean flag = false; ReadFrequencyMaster Frequence = (ReadFrequencyMaster)Frequenceobj; try { ReadFrequency _Frequence = new ReadFrequency(); if (Frequence.ClientID != null) { _Frequence.ClientID = Frequence.ClientID; } if (Frequence.SiteID != null) { _Frequence.SiteID = Frequence.SiteID; } if (Frequence.FrequencyName != null) { _Frequence.FrequencyName = Frequence.FrequencyName.Trim(); } if (!String.IsNullOrEmpty(Frequence.SelectFrequencyMode)) { _Frequence.FrequencyMode = Convert.ToInt32(Frequence.SelectFrequencyMode); } if ((!String.IsNullOrEmpty(Frequence.SelectFrequencyMode)) && (Frequence.SelectFrequencyMode == "2")) { if (Frequence.Weeklyday != null) { _Frequence.FrequencyDay = Convert.ToInt32(Frequence.Weeklyday); } } else { _Frequence.FrequencyDay = null; } if ((!String.IsNullOrEmpty(Frequence.SelectFrequencyMode)) && (Frequence.SelectFrequencyMode == "3")) { if (Frequence.DayOfMonth != null) { _Frequence.DayOfMonth = Frequence.DayOfMonth.Trim(); } } else { _Frequence.DayOfMonth = null; } _Frequence.CreateBy = Frequence.CreateBy; _Frequence.CreateDate = DateTime.Now; if ((_Frequence.ClientID != null)&&(_Frequence.SiteID != null)) { flag = DAL.DALReadFrequency.CreateReadFrequency(_Frequence); } } catch (Exception ex) { throw; } return flag; }