public bool CreateRecord(Object levelobj)
{
Boolean flag = false;
PropertyLevelMaster Level = (PropertyLevelMaster)levelobj;
try
{
PropertyLevel _Level = new PropertyLevel();
if (Level.LevelName != null)
{
_Level.LevelName = Level.LevelName.Trim();
}
if (Level.ClientID != null)
{
_Level.ClientID = Level.ClientID;
}
if (Level.SiteID != null)
{
_Level.SiteID = Level.SiteID;
}
_Level.CreateBy = Level.CreateBy;
_Level.CreateDate = DateTime.Now;
if (_Level.LevelName != null)
{
flag = DAL.DALPropertyLevel.CreatePropertyLevel(_Level);
}
}
catch (Exception ex)
{
throw;
}
return flag;
}
public static bool IsExistingPropertyLevel(PropertyLevel level)
{
using (var context = new SycousCon())
{
try
{
PropertyLevel objlevel = context.PropertyLevels.SingleOrDefault(p => p.LevelName.ToUpper() == level.LevelName.ToUpper() && p.ClientID == level.ClientID && p.SiteID == level.SiteID);
if (objlevel != null)
{ return true; }
else
{
return false;
}
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
}
public static PropertyLevel EditPropertyLevel(Int32 LevelID)
{
PropertyLevel level = new PropertyLevel();
using (var context = new SycousCon())
{
try
{
level = context.PropertyLevels.SingleOrDefault(s => s.ID == LevelID);
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
return level;
}
public static Boolean CreatePropertyLevel(PropertyLevel level)
{
Boolean flag = false;
if (!(IsExistingPropertyLevel(level)))
{
using (TransactionScope scope = new TransactionScope())
{
using (var context = new SycousCon())
{
try
{
context.PropertyLevels.AddObject(level);
context.SaveChanges();
scope.Complete();
context.AcceptAllChanges();
flag = true;
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}//
}// using
}//if
return flag;
}
public static Boolean UpdatePropertyLevel(PropertyLevel Level)
{
using (TransactionScope scope = new TransactionScope())
{
Boolean bol = false;
using (var context = new SycousCon())
{
try
{
var Update = context.PropertyLevels.Where(c => c.ID == Level.ID);
foreach (PropertyLevel p in Update)
{
if (Level.LevelName != null)
{
p.LevelName = Level.LevelName;
}
if (Level.SiteID != null)
{
p.SiteID = Level.SiteID;
}
if (Level.ClientID != null)
{
p.ClientID = Level.ClientID;
}
p.ModifyBy = Level.ModifyBy;
p.ModifyDate = DateTime.Now;
}//
context.SaveChanges();
context.AcceptAllChanges();
scope.Complete();
context.Dispose();
bol = true;
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}// using
return bol;
} //trans
}
public bool UpdateRecord(Object Typeobj)
{
Boolean flag = false;
PropertyLevelMaster Level = (PropertyLevelMaster)Typeobj;
try
{
PropertyLevel _Level = new PropertyLevel();
_Level.ID = Convert.ToInt32(Level.ID);
if (Level.LevelName != null)
{
_Level.LevelName = Level.LevelName.Trim();
}
if (Level.ClientID != null)
{
_Level.ClientID = Level.ClientID;
}
if (Level.SiteID != null)
{
_Level.SiteID = Level.SiteID;
}
_Level.ModifyBy = Level.modifyBy;
_Level.ModifyDate = DateTime.Now;
if (_Level.ID != null)
{
flag = DAL.DALPropertyLevel.UpdatePropertyLevel(_Level);
}
}
catch (Exception ex)
{
throw;
}
return flag;
}
/// <summary>
/// Create a new PropertyLevel object.
/// </summary>
/// <param name="id">Initial value of the ID property.</param>
/// <param name="isDeleted">Initial value of the IsDeleted property.</param>
public static PropertyLevel CreatePropertyLevel(global::System.Int32 id, global::System.Int32 isDeleted)
{
PropertyLevel propertyLevel = new PropertyLevel();
propertyLevel.ID = id;
propertyLevel.IsDeleted = isDeleted;
return propertyLevel;
}
/// <summary>
/// Deprecated Method for adding a new object to the PropertyLevels EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToPropertyLevels(PropertyLevel propertyLevel)
{
base.AddObject("PropertyLevels", propertyLevel);
}
