public static int Update(tblVehicleType vehicletype)
{
var _db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
_db.Connection.Open();
var _vehicletype = (from vt in _db.tblVehicleTypes
where vt.VehicleTypeID == vehicletype.VehicleTypeID
select vt).First();
_vehicletype.Name = vehicletype.Name;
_vehicletype.Capacity = vehicletype.Capacity;
_vehicletype.Description = vehicletype.Description;
vehicletype.UpdatedDate = CommonFactory.GetCurrentDate();
try
{
if (_db.Connection.State == ConnectionState.Closed) _db.Connection.Open();
_db.SaveChanges();
}
catch (Exception ex)
{
return 1;
}
finally
{
if (_db.Connection.State == ConnectionState.Closed) _db.Connection.Open();
_db.Connection.Close();
}
return 0;
}
/// <summary>
/// Delete Decleration by ID
/// </summary>
/// <param name="declerationID">DeclerationID</param>
/// <returns>Number of rows are effected</returns>
public static int DeleteByID(int declerationID)
{
var db = new dbEcustomEntities(Utilities.Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
var declaration = db.tblDeclarations.Where(g => g.DeclarationID == declerationID).FirstOrDefault();
db.DeleteObject(declaration);
return db.SaveChanges();
}
/// <summary>
/// Delete vehicle by ID
/// </summary>
/// <param name="vehicleID">Vehicle ID</param>
/// <returns>Number of rows are effected</returns>
public static int DeleteByID(int vehicleID)
{
var db = new dbEcustomEntities(Utilities.Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
var vehicle = db.tblVehicles.Where(g => g.VehicleID == vehicleID).FirstOrDefault();
db.DeleteObject(vehicle);
return db.SaveChanges();
}
public bool DeleteItem(string[] itemParams)
{
if (itemParams.Length < 2) return false;
string id = itemParams[0];
string branchId = itemParams[1];
var _db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
try
{
var deleteItem =
_db.tblPermissionTypes.FirstOrDefault(
item => item.TypeCode == id && item.BranchId == branchId);
if (deleteItem != null)
{
_db.DeleteDirectly(deleteItem);
_db.SaveChanges();
}
return true;
}
catch (Exception exception)
{
LogManager.GetLogger("ECustoms.PermissionTypeFactory").Error(exception.ToString());
throw;
}
finally
{
_db.Connection.Close();
}
}
public bool DeleteItem(string[] itemParams)
{
if (itemParams.Length < 3) return false;
int id = itemParams[0].StringToInt();
int verhiceId = itemParams[1].StringToInt();
string branchId = itemParams[2];
var _db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
try
{
var deleteItem =
_db.tblDeclarationVehicles.FirstOrDefault(
item => item.DeclarationID == id && item.VehicleID == verhiceId && item.BranchId == branchId);
if (deleteItem != null)
{
_db.DeleteDirectly(deleteItem);
_db.SaveChanges();
}
return true;
}
catch (Exception exception)
{
LogManager.GetLogger("ECustoms.DeclarationVehicleFactory").Error(exception.ToString());
throw;
}
finally
{
_db.Connection.Close();
}
}
public bool BatchInsert(object[] items)
{
var _db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
try
{
_db.Connection.Open();
foreach (object item in items)
{
_db.AddObjectDirectly("tblProfileConfigs", item);
}
_db.SaveChanges();
return true;
}
catch (Exception ex)
{
LogManager.GetLogger("ECustoms.AllFactory").Error(ex.ToString());
throw;
}
finally
{
_db.Connection.Close();
}
return false;
}
public static int Insert(tblUserInGroup userGroup)
{
var db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
db.AddTotblUserInGroups(userGroup);
int re= db.SaveChanges();
db.Connection.Close();
return re;
}
/// <summary>
/// Update Vehicle
/// </summary>
/// <param name="vehicle"></param>
/// <returns></returns>
public static int UpdateVehicle(tblVehicle vehicle )
{
var db = new dbEcustomEntities(Utilities.Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
// Get orgin vehicle
var vehicleOrgin = db.tblVehicles.Where(g => g.VehicleID == vehicle.VehicleID).FirstOrDefault();
db.Attach(vehicleOrgin);
db.ApplyPropertyChanges("tblVehicles", vehicle);
return db.SaveChanges();
}
public static int Insert(tblVehicleCheck tblVehicleCheck)
{
var db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
tblVehicleCheck.CreatedDate = CommonFactory.GetCurrentDate();
db.AddTotblVehicleChecks(tblVehicleCheck);
int re = db.SaveChanges();
db.Connection.Close();
return re;
}
public static int DeleteUserInGroup(int groupID, int userID)
{
var db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
tblUserInGroup tblUserInGroup = db.tblUserInGroups.Where(g => g.GroupID == groupID && g.UserID == userID).FirstOrDefault();
if(tblUserInGroup != null)
db.DeleteObject(tblUserInGroup);
int re = db.SaveChanges();
db.Connection.Close();
return re;
}
public static int Insert(tblGroup group)
{
var db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
group.CreatedDate = CommonFactory.GetCurrentDate();
group.ModifiedDate = CommonFactory.GetCurrentDate();
db.AddTotblGroups(group);
int re = db.SaveChanges();
db.Connection.Close();
return re;
}
public static int Delete(long checkID)
{
var db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
var check = db.tblChecks.Where(g => g.CheckID == checkID).FirstOrDefault();
if (check == null) return -1;
db.DeleteObject(check);
int re = db.SaveChanges();
db.Connection.Close();
return re;
}
/// <summary>
/// update declaration
/// </summary>
/// <param name="declaration"></param>
/// <param name="modifiedByID"></param>
/// <returns></returns>
public static int Update(tblDeclaration declaration)
{
var db = new dbEcustomEntities(Utilities.Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
declaration.ModifiedDate = DateTime.Now;
// Get orgin object
var objOrginDeclaration = db.tblDeclarations.Where(g => g.DeclarationID.Equals(declaration.DeclarationID)).FirstOrDefault();
db.Attach(objOrginDeclaration);
db.ApplyPropertyChanges("tblDeclarations", declaration);
return db.SaveChanges();
}
/// <summary>
/// Insert User
/// </summary>
/// <param name="userInfo">UserInfo object</param>
/// <returns>Number of rows are effected</returns>
public static int Insert(tblUser userInfo)
{
// Encode password & username
userInfo.Password = Common.Encode(userInfo.Password);
var db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
db.AddTotblUsers(userInfo);
int re = db.SaveChanges();
db.Connection.Close();
return re;
}
public static bool UpdateSettings(string version, DateTime lastSync, int interval, string syncTime, bool isStartSync)
{
dbEcustomEntities _db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
try
{
if (_db.Connection.State == ConnectionState.Closed) _db.Connection.Open();
var existing = _db.tblSettings.FirstOrDefault(p => p.Version == version);
if(existing==null)
{
tblSetting setting = new tblSetting();
setting.Version = version;
setting.LastSync = lastSync;
setting.SyncInterval = interval;
setting.SyncTime = syncTime;
setting.IsStartingSync = isStartSync;
_db.AddTotblSettings(setting);
return _db.SaveChanges() > 0;
}
else
{
//existing.Version = version;
existing.LastSync = lastSync;
existing.SyncInterval = interval;
existing.SyncTime = syncTime;
existing.IsStartingSync = isStartSync;
return _db.SaveChanges() > 0;
}
}
catch(Exception e)
{
return false;
}
finally
{
_db.Connection.Close();
}
return false;
}
public static int Update(tblGroup group)
{
var db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
var groupOrgin = db.tblGroups.Where(g => g.GroupID == group.GroupID).FirstOrDefault();
if (groupOrgin == null) return -1;
db.Attach(groupOrgin);
db.ApplyPropertyChanges("tblGroups", group);
int re = db.SaveChanges();
db.Connection.Close();
return re;
}
public static int Insert(long vehicleID, long declarationID)
{
var db = new dbEcustomEntities(Utilities.Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
var declarationVehicle = new tblDeclarationVehicle();
declarationVehicle.VehicleID = vehicleID;
declarationVehicle.DeclarationID = declarationID;
db.AddTotblDeclarationVehicles(declarationVehicle);
int re = db.SaveChanges();
db.Connection.Close();
return re;
}
public static int Update(tblVehicleCheck vehicleCheck)
{
var db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
// Get orgin object
var objOrginVehicleCheck = db.tblVehicleChecks.Where(g => g.VehicleCheckID == vehicleCheck.VehicleCheckID).FirstOrDefault();
db.Attach(objOrginVehicleCheck);
db.ApplyPropertyChanges("tblVehicleChecks", vehicleCheck);
int re = db.SaveChanges();
db.Connection.Close();
return re;
}
public static int Insert(List<tblUserGroupPermission> listUserGroupPermission)
{
var db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
foreach (tblUserGroupPermission userGroupPermission in listUserGroupPermission)
{
db.AddTotblUserGroupPermissions(userGroupPermission);
}
int re = db.SaveChanges();
db.Connection.Close();
return re;
}
public static int DeleteUserInGroupByGroupID(Int32 groupID)
{
var db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
List<tblUserInGroup> listTblUserInGroup = db.tblUserInGroups.Where(g => g.GroupID == groupID).ToList();
foreach (tblUserInGroup userInGroup in listTblUserInGroup)
{
db.DeleteObject(userInGroup);
}
int re = db.SaveChanges();
db.Connection.Close();
return re;
}
public static int DeleteUserGroupPermissionByUserID(int userID)
{
var db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
List<tblUserGroupPermission> listUserGroupPermission = db.tblUserGroupPermissions.Where(g => g.UserID == userID && g.PermissionType == PERMISSION_TYPE_USER).ToList();
foreach (tblUserGroupPermission userGroupPermission in listUserGroupPermission)
{
db.DeleteObject(userGroupPermission);
}
int re = db.SaveChanges();
db.Connection.Close();
return re;
}
public static int Update(tblCheck check)
{
check.ModifedDate = CommonFactory.GetCurrentDate();
var db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
var checkOrgin = db.tblChecks.Where(g => g.CheckID == check.CheckID).FirstOrDefault();
if (checkOrgin == null) return -1;
db.Attach(checkOrgin);
db.ApplyPropertyChanges("tblChecks", check);
int re = db.SaveChanges();
db.Connection.Close();
return re;
}
public static int Update(tblDeclarationLoan loan)
{
var db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
loan.ModifiedDate = CommonFactory.GetCurrentDate();
// Get orgin object
var objOrginDeclaration = db.tblDeclarationLoans.Where(g => g.ID.Equals(loan.ID)).FirstOrDefault();
db.Attach(objOrginDeclaration);
db.ApplyPropertyChanges("tblDeclarationLoans", loan);
int re = db.SaveChanges();
db.Connection.Close();
return re;
}
public static void DeleteVehicleByDecarationID(long declarationID)
{
var db = new dbEcustomEntities(Utilities.Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
var declarationVehicles =
db.tblDeclarationVehicles.Where((g => g.DeclarationID == declarationID)).ToList();
foreach (var tblDeclarationVehicle in declarationVehicles)
{
db.DeleteObject(tblDeclarationVehicle);
db.SaveChanges();
}
db.Connection.Close();
}
public static int Update(tblTrain train)
{
var _db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
train.ModifiedDate = CommonFactory.GetCurrentDate();
var originTrain = _db.tblTrains.Where(g => g.TrainID == train.TrainID).FirstOrDefault();
if (originTrain == null)
{
return -1;
}
_db.Attach(originTrain);
_db.ApplyPropertyChanges("tblTrains", train);
return _db.SaveChanges();
}
public static int DeleteByVehicleDeclarationID(long vehicleID, long declarationID)
{
var db = new dbEcustomEntities(Utilities.Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
var declarationVehicle =
db.tblDeclarationVehicles.Where((g => g.DeclarationID == declarationID && g.VehicleID == vehicleID)).
FirstOrDefault();
if (declarationVehicle != null)
{
db.DeleteObject(declarationVehicle);
int re = db.SaveChanges();
db.Connection.Close();
return re;
}
return -1;
}
public static int Delete(long trainId)
{
var _db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
try
{
if (_db.Connection.State == ConnectionState.Closed) _db.Connection.Open();
var train = _db.tblTrains.FirstOrDefault(g => g.TrainID == trainId);
_db.DeleteObject(train);
return _db.SaveChanges();
}
catch
{
return -1;
}
finally
{
_db.Connection.Close();
}
}
public static int Insert(tblTrain train)
{
var _db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
_db.Connection.Open();
train.CreatedDate = CommonFactory.GetCurrentDate();
train.BranchId= FDHelper.RgCodeOfUnit();
_db.AddTotblTrains(train);
try
{
if (_db.Connection.State == ConnectionState.Closed) _db.Connection.Open();
return _db.SaveChanges();
}
catch (Exception ex)
{
return -1;
}
finally
{
_db.Connection.Close();
}
}
public static int Insert(tblType type)
{
dbEcustomEntities _db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
_db.Connection.Open();
type.CreatedDate = CommonFactory.GetCurrentDate();
type.ModifiedDate = CommonFactory.GetCurrentDate();
_db.AddTotblTypes(type);
try
{
if (_db.Connection.State == ConnectionState.Closed) _db.Connection.Open();
return _db.SaveChanges();
}
catch (Exception ex)
{
return -1;
}
finally
{
_db.Connection.Close();
}
}
public bool UpdatePatch(object[] items)
{
var _db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
try
{
_db.Connection.Open();
var updateItems = items.OfType<tblApplicationObject>().ToList();
foreach (var updateItem in updateItems)
{
var item =
_db.tblApplicationObjects.FirstOrDefault(
p => p.BranchId == updateItem.BranchId && p.ApplicationObjectID == updateItem.ApplicationObjectID);
item.IsSynced = true;
}
_db.SaveChanges();
_db.Connection.Close();
return true;
}
catch (Exception ex)
{
LogManager.GetLogger("ECustoms.ApplicationObjectFactory").Error(ex.ToString());
throw;
}
finally
{
_db.Connection.Close();
}
}