public static Boolean CreateDataLoggerMapping(SiteInLogger logger)
{
Boolean flag = false;
using (TransactionScope scope = new TransactionScope())
{
using (var context = new SycousCon())
{
try
{
context.SiteInLoggers.AddObject(logger);
context.SaveChanges();
scope.Complete();
context.AcceptAllChanges();
flag = true;
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}//
}// using
return flag;
}
public Boolean UpdateMapping(DataLoggerMapClass loggerobj)
{
Boolean flag = false;
try
{
SiteInLogger _logger = new SiteInLogger();
if (loggerobj.Mapid != null)
{
_logger.MapID = Convert.ToInt64(loggerobj.Mapid);
}
if (loggerobj.EndDate != null)
{
_logger.Enddate = Common.DateGB(loggerobj.EndDate);
}
_logger.ModifyBy = loggerobj.modifyBy;
_logger.ModifyDate = DateTime.Now;
if ((_logger.MapID != null) && (_logger.Enddate != null))
{
flag = DAL.DALDataLogger.UpdateDataLoggerMapping(_logger);
}
}
catch (Exception ex)
{
throw;
}
return flag;
}
public Boolean CreateMapping(DataLoggerMapClass loggerobj)
{
Boolean flag = false;
try
{
SiteInLogger _logger = new SiteInLogger();
if (loggerobj.ClientId != null)
{
_logger.ClientID = loggerobj.ClientId;
}
if (loggerobj.SiteId != null)
{
_logger.SiteID = loggerobj.SiteId;
}
if (loggerobj.LoggerId != null)
{
_logger.LoggerID = loggerobj.LoggerId;
}
if (loggerobj.CommunicationId != null)
{
_logger.CommunicationID = loggerobj.CommunicationId;
}
if (loggerobj.StartDate != null)
{
_logger.StartDate = Common.DateGB(loggerobj.StartDate);
}
_logger.CreateBy = loggerobj.CreateBy;
_logger.CreateDate = DateTime.Now;
if ((_logger.LoggerID != null) && (_logger.ClientID != null) && (_logger.SiteID != null) && (_logger.CommunicationID != null))
{
flag = DAL.DALDataLogger.CreateDataLoggerMapping(_logger);
}
}
catch (Exception ex)
{
throw;
}
return flag;
}
public static Boolean UpdateDataLoggerMapping(SiteInLogger logger)
{
using (TransactionScope scope = new TransactionScope())
{
Boolean bol = false;
using (var context = new SycousCon())
{
try
{
var Update = context.SiteInLoggers.Where(c => c.MapID == logger.MapID);
foreach (SiteInLogger p in Update)
{
if (logger.Enddate != null)
{
p.Enddate = logger.Enddate;
}
// p.IsDeleted = 2;
p.ModifyBy = logger.ModifyBy;
p.ModifyBy = logger.ModifyBy;
}//
context.SaveChanges();
context.AcceptAllChanges();
scope.Complete();
context.Dispose();
bol = true;
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}// using
return bol;
} //trans
}
// Mapping Insert --------------------------------
Boolean IRecordInsert.AddRecord(Object loggerobj)
{
bool flag = false;
SiteInloggerClass logger = (SiteInloggerClass)loggerobj;
try
{
SiteInLogger _logger = new SiteInLogger();
if (logger.SiteID != null)
{
_logger.SiteID = logger.SiteID;
}
if (logger.LoggerId != null)
{
_logger.LoggerID = logger.LoggerId;
}
if (logger.CommunicationID != null)
{
_logger.CommunicationID = logger.CommunicationID;
}
if (logger.AssignDate != null)
{
_logger.StartDate = Common.DateGB(logger.AssignDate);
}
if (logger.SiteID != null)
{
SiteInfo siteinfo = new SiteInfo();
siteinfo.SiteID = Convert.ToInt64(logger.SiteID);
_logger.ClientID = siteinfo.GetSiteClientID();
}
_logger.CreateBy = logger.CreateBy;
_logger.CreateDate = DateTime.Now;
_logger.EntryDate = DateTime.Now;
if ((_logger.SiteID != null) && (_logger.LoggerID != null) && (_logger.CommunicationID != null))
{
flag = DAL.DALSite.CreateSiteInLogger(_logger);
}
}
catch (Exception ex)
{
throw;
}
return flag;
}
Boolean IUpdate.UpdateRecord(object loggerobj)
{
Boolean flag = false;
SiteInloggerClass logger = (SiteInloggerClass)loggerobj;
try
{
SiteInLogger _logger = new SiteInLogger();
if (logger.MappID != null)
{
_logger.MapID = Convert.ToInt64(logger.MappID);
}
if (logger.ReleaseDate != null)
{
_logger.Enddate = Common.DateGB(logger.ReleaseDate);
}
_logger.ModifyBy = logger.CreateBy;
_logger.ModifyDate = DateTime.Now;
if (_logger.MapID != null)
{
flag = DAL.DALSite.IsDeletedSiteInLogger(_logger);
}
return flag;
}
catch (Exception ex)
{
throw;
}
}
public static bool IsExistingSiteInLogger(SiteInLogger siteinlogger)
{
using (var context = new SycousCon())
{
try
{
SiteInLogger objsite = context.SiteInLoggers.SingleOrDefault(p => p.SiteID == siteinlogger.SiteID && p.LoggerID == siteinlogger.LoggerID && p.CommunicationID== siteinlogger.CommunicationID && p.IsDeleted==0);
if (objsite != null)
{ return false; }
else
{
return true;
}
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
}
public static Boolean IsDeletedSiteInLogger(SiteInLogger logger)
{
using (TransactionScope scope = new TransactionScope())
{
Boolean bol = false;
using (var context = new SycousCon())
{
try
{
var Update = context.SiteInLoggers.Where(p => p.MapID == logger.MapID);
if (Update.Count() > 0)
{
foreach (SiteInLogger p in Update)
{
if (logger.Enddate != null)
{
p.Enddate = logger.Enddate;
}
p.IsDeleted = 2;
if (logger.CreateBy != null)
{
p.ModifyBy = logger.CreateBy;
p.ModifyDate = DateTime.Now;
}
else
{
p.ModifyBy = logger.ModifyBy;
p.ModifyDate = DateTime.Now;
}
context.SaveChanges();
context.AcceptAllChanges();
bol = true;
}//
}
else
{
bol = true;
}
scope.Complete();
context.Dispose();
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}// using
return bol;
} //trans
}
//public static IEnumerable<ClintInSiteList> ClientInSiteList(int Mode)
//{
// IEnumerable<ClintInSiteList> MappingList = null;
// try
// {
// using (var context = new SycousCon())
// {
// var parmode = new SqlParameter
// {
// ParameterName = "mode",
// Value = Mode,
// Direction = ParameterDirection.Input
// };
// MappingList = context.ExecuteStoreQuery<ClintInSiteList>("exec ClientInSiteMap @mode", parmode).ToList();
// }
// }
// catch (Exception ex)
// {
// throw;
// }
// return MappingList;
//}//ClintInSiteList
//public static IEnumerable<ClintInSiteList> ClientInSiteList(int Mode, String ID)
//{
// IEnumerable<ClintInSiteList> MappingList = null;
// try
// {
// using (var context = new SycousCon())
// {
// if (Mode == 3)
// {
// var parmode = new SqlParameter
// {
// ParameterName = "mode",
// Value = 3,
// Direction = ParameterDirection.Input
// };
// var parMapID = new SqlParameter
// {
// ParameterName = "MapID",
// Value = "3",
// Direction = ParameterDirection.Input
// };
// var parClient = new SqlParameter
// {
// ParameterName = "ClientID",
// Value = ID,
// Direction = ParameterDirection.Input
// };
// MappingList = context.ExecuteStoreQuery<ClintInSiteList>("exec ClientInSiteMap @mode,@MapID,@ClientID", parmode, parMapID, parClient).ToList();
// }
// }
// }
// catch (Exception ex)
// {
// throw;
// }
// return MappingList;
//}//ClientInSiteList
//public static Boolean CreateClientInSite(ClientInSite site)
//{
// Boolean flag = false;
// if ((IsExistingClientInSite(site)))
// {
// using (TransactionScope scope = new TransactionScope())
// {
// using (var context = new SycousCon())
// {
// try
// {
// context.ClientInSites.AddObject(site);
// context.SaveChanges();
// scope.Complete();
// context.AcceptAllChanges();
// flag = true;
// }
// catch (Exception ex)
// {
// context.Dispose();
// throw;
// }
// }
// }
// }
// return flag;
//}//CreateSite
//public static bool IsExistingClientInSite(ClientInSite site)
//{
// using (var context = new SycousCon())
// {
// try
// {
// ClientInSite objsite = context.ClientInSites.SingleOrDefault(p => p.ClientID == site.ClientID && p.SiteID == site.SiteID && p.IsDeleted == 0);
// if (objsite != null)
// { return false; }
// else
// {
// return true;
// }
// }
// catch (Exception ex)
// {
// context.Dispose();
// throw;
// }
// }
//}//IsExistingSite
//public static Boolean UpdateClientInSite(ClientInSite site)
//{
// using (TransactionScope scope = new TransactionScope())
// {
// Boolean bol = false;
// using (var context = new SycousCon())
// {
// try
// {
// var Update = context.ClientInSites.Where(c => c.ID == site.ID);
// foreach (ClientInSite p in Update)
// {
// if (site.ReleaseDate != null)
// {
// p.ReleaseDate = site.ReleaseDate;
// }
// if (site.IsDeleted != null)
// {
// p.IsDeleted = site.IsDeleted;
// }
// p.ModifyDate = DateTime.Now;
// p.ModifyBy = site.ModifyBy;
// }//
// context.SaveChanges();
// context.AcceptAllChanges();
// scope.Complete();
// context.Dispose();
// bol = true;
// }
// catch (Exception ex)
// {
// context.Dispose();
// throw;
// }
// }// using
// return bol;
// } //trans
//}//UpdateClientInSite
//public static ClintInSiteList EditClientInSite(Int64 MapId)
//{
// ClintInSiteList Mapping = new ClintInSiteList();
// using (var context = new SycousCon())
// {
// try
// {
// var parmode = new SqlParameter
// {
// ParameterName = "mode",
// Value = 4,
// Direction = ParameterDirection.Input
// };
// var parMapID = new SqlParameter
// {
// ParameterName = "MapID",
// Value = MapId.ToString(),
// Direction = ParameterDirection.Input
// };
// Mapping = context.ExecuteStoreQuery<ClintInSiteList>("exec ClientInSiteMap @mode,@MapID", parmode, parMapID).FirstOrDefault();
// }
// catch (Exception ex)
// {
// context.Dispose();
// throw;
// }
// }
// return Mapping;
//}//EditClientInSite
//----------------------------------SiteInDataLogger Mapping -------------------------------------------------------
public static Boolean CreateSiteInLogger(SiteInLogger siteinlogger)
{
Boolean flag = false;
if (IsExistingSiteInLogger(siteinlogger))
{
using (TransactionScope scope = new TransactionScope())
{
using (var context = new SycousCon())
{
try
{
context.SiteInLoggers.AddObject(siteinlogger);
context.SaveChanges();
scope.Complete();
context.AcceptAllChanges();
flag = true;
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
}
}
return flag;
}
/// <summary>
/// Create a new SiteInLogger object.
/// </summary>
/// <param name="mapID">Initial value of the MapID property.</param>
/// <param name="isDeleted">Initial value of the IsDeleted property.</param>
public static SiteInLogger CreateSiteInLogger(global::System.Int64 mapID, global::System.Int32 isDeleted)
{
SiteInLogger siteInLogger = new SiteInLogger();
siteInLogger.MapID = mapID;
siteInLogger.IsDeleted = isDeleted;
return siteInLogger;
}
/// <summary>
/// Deprecated Method for adding a new object to the SiteInLoggers EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToSiteInLoggers(SiteInLogger siteInLogger)
{
base.AddObject("SiteInLoggers", siteInLogger);
}
