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;
}
