private void ValidateEmployeeAccess()
{
Int32 employeeId = Convert.ToInt32(Session["EmployeeID"]);
SqlConnection con = new SqlConnection(Configuration.ConnectionString);
var Engineer = new Engineer();
bool pmFiscalSummary = false;
bool picFiscalSummary = false;
con.Open();
SqlDataReader dr = Engineer.GetByEmployeeID(employeeId, con);
if (dr.HasRows)
{
dr.Read();
pmFiscalSummary = dr.GetValueOrDefault<bool>("PMFiscalSummary");
picFiscalSummary = dr.GetValueOrDefault<bool>("PICFiscalSummary");
}
con.Close();
dr.Close();
con = null;
dr = null;
bool displayFiscalSummary = pmFiscalSummary | picFiscalSummary;
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "displayFiscalSummary", string.Format("displayFiscalSummary = '{0}'", displayFiscalSummary), true);
}
public List<Task> GetAssignedTasks(Engineer e, Task task)
{
target = e;
assignedTasks = new List<Task>();
Visit((dynamic)task);
return assignedTasks;
}
public ActionResult AddMachine(Engineer engineer, int MachineId)
{
var joinExists = _db.EngineerMachine.FirstOrDefault(join => join.MachineId == MachineId && join.EngineerId == engineer.EngineerId);
if (joinExists != null)
{
return(RedirectToAction("Details", new { id = engineer.EngineerId }));
}
if (MachineId != 0)
{
_db.EngineerMachine.Add(new EngineerMachine()
{
MachineId = MachineId, EngineerId = engineer.EngineerId
});
}
_db.SaveChanges();
return(RedirectToAction("Details", new { id = engineer.EngineerId }));
}
void SaveToMemory()
{
double[] Data = { sL, sR, sB, sT };
double[] SenseData = { pL, pR, pB, pT };
Memory.Add(Data);
MemorySense.Add(SenseData);
if (Memory.Count > 2000)
{
if (nearcount == 0)
{
World.Remove(this);
Engineer newlife = new Engineer(World, x, y);
World.Add(newlife);
}
Memory.RemoveAt(0);
MemorySense.RemoveAt(0);
}
//Console.SetCursorPosition(0, 3);
//Console.Write(Memory.Count.ToString());
}
public Engineer CreateEngineer()
{
var id = GenerateId();
if (id.IsEmpty)
{
return(null);
}
var setup = SelectSetup();
var engineer = new Engineer(
id,
setup.FixTime.Random(),
new Money(setup.Price.RandomInclusive()),
new Money(setup.Salary.RandomInclusive()),
setup.Level,
false
);
return(engineer);
}
public ActionResult Create(Engineer engineers, int MachineId, int LocationId)
{
_db.Engineers.Add(engineers);
if (MachineId != 0)
{
_db.EngineerLocationMachine.Add(new EngineerLocationMachine()
{
MachineId = MachineId, EngineerId = engineers.EngineerId
});
}
if (LocationId != 0)
{
_db.EngineerLocationMachine.Add(new EngineerLocationMachine()
{
LocationId = LocationId, EngineerId = engineers.EngineerId
});
}
_db.SaveChanges();
return(RedirectToAction("Details", new { id = engineers.EngineerId }));
}
private static IEngineer CreateEngineer(string[] cmdArgs, int id, string firstName, string lastName, decimal salary, string corps)
{
IEngineer engineer = new Engineer(id, firstName, lastName, salary, corps);
string[] repairArgs = cmdArgs
.Skip(6)
.ToArray();
for (int i = 0; i < repairArgs.Length; i += 2)
{
string partName = repairArgs[i];
int hoursWorked = int.Parse(repairArgs[i + 1]);
IRepair repair = new Repair(partName, hoursWorked);
engineer.AddRepair(repair);
}
return(engineer);
}
private ISoldier GetEngineer(int id, string firstName, string lastName, decimal salary, string[] inputArgs)
{
string corpsAsString = inputArgs[5];
if (!Enum.TryParse(corpsAsString, out Corps corps))
{
return(null);
}
IEngineer engineer = new Engineer(id, firstName, lastName, salary, corps);
for (int i = 6; i < inputArgs.Length; i += 2)
{
string partName = inputArgs[i];
int workedHours = int.Parse(inputArgs[i + 1]);
IRepair repair = new Repair(partName, workedHours);
engineer.Repairs.Add(repair);
}
return(engineer);
}
static void Main(string[] args)
{
#region Static
//Student s1 = new Student();
//s1.Name = "Kamran";
//Student.Count = 5;
//Console.WriteLine(Student.Count);
//s1.Test();
#endregion
#region Sealed
Engineer engineer = new Engineer();
#endregion
#region Generic
//MyList<int> intList = new MyList<int>();
//MyList<string> strList = new MyList<string>();
MyList <Student, Person> list = new MyList <Student, Person>();
Area area = new Area();
#endregion
#region Extension
string word = "Hello";
//Console.WriteLine(word.GetFirstChar());
#endregion
#region Boxing,Upcasting
//object str = "Aqil";
#endregion
#region Downcasting
object s = "Word";
int x = (int)s;
#endregion
#region Operator overloading
Student s1 = new Student();
Student s2 = new Student();
Console.WriteLine(s1 > s2);
#endregion
}
private ISoldier GenerateEngineer(int id, string firstName, string lastName, string[] args)
{
string corpsAsString = args[5];
if (!Enum.TryParse(corpsAsString, out Corps corps))
{
return(null);
}
IEngineer engineer = new Engineer(firstName, lastName, id, decimal.Parse(args[4]), corps);
for (int i = 6; i < args.Length; i += 2)
{
string partName = args[i];
int hoursWorked = int.Parse(args[i + 1]);
IRepairs repair = new Repair(partName, hoursWorked);
engineer.AddRepair(repair);
}
return(engineer);
}
public bool GenerateEngineer(int amount)
{
if (engineerPrefab != null)
{
for (int i = 0; i < amount; i++)
{
float spawnPosX = UnityEngine.Random.Range(floorBounds.bounds.min.x, floorBounds.bounds.max.x);
float spawnPosY = UnityEngine.Random.Range(floorBounds.bounds.min.z, floorBounds.bounds.max.z);
Vector3 spawnPos = new Vector3(spawnPosX, 0, spawnPosY);
Engineer e = Instantiate(
engineerPrefab,
spawnPos,
Quaternion.Euler(0, UnityEngine.Random.Range(0, 359), 0),
engineerContainer.transform
);
e.gameObject.SetActive(true);
}
return(true);
}
return(false);
}
private static void ExecuteEngineerCommand(List <string> inputLineArgs)
{
int id = int.Parse(inputLineArgs[0]);
string firstName = inputLineArgs[1];
string lastName = inputLineArgs[2];
double salary = double.Parse(inputLineArgs[3]);
string corps = inputLineArgs[4];
IEngineer engineer = new Engineer(id, firstName, lastName, salary, corps);
var repairPairs = inputLineArgs.Skip(5).ToList();
for (int i = 0; i < repairPairs.Count - 1; i += 2)
{
string partName = repairPairs[i];
int hours = int.Parse(repairPairs[i + 1]);
IRepair repair = new Repair(partName, hours);
engineer.Repairs.Add(repair);
}
Console.WriteLine(engineer.ToString());
}
public static void AddEngineer(string[] info, List <ISoldier> soldiers)
{
var id = int.Parse(info[1]);
var firstName = info[2];
var lastName = info[3];
double salary = double.Parse(info[4]);
string corps = info[5];
List <Repair> repairs = new List <Repair>();
if (corps == "Airforces" || corps == "Marines")
{
for (int i = 6; i < info.Length; i += 2)
{
Repair repair = new Repair(info[i], int.Parse(info[i + 1]));
repairs.Add(repair);
}
Engineer engineer = new Engineer(firstName, lastName, id, salary, corps, repairs);
soldiers.Add(engineer);
}
}
public void Add(Engineer engineer)
{
string engineerString = engineer.BaseWorking.ToString();
if (!queueTKey.Contains(engineer))
{
sortedDictTKey.Add(engineer.BaseWorking, engineer);
}
else
{
throw new MyException("Объект с данными фамилией и именем уже существует!", engineer.Firstname, engineer.Surname);
}
queueTKey = new Queue <Working>(sortedDictTKey.Keys);
queueString = new Queue <string>();
sortedDictString = new SortedDictionary <string, Engineer>();
foreach (var obj in sortedDictTKey)
{
queueString.Enqueue(obj.Key.ToString());
sortedDictString.Add(obj.Key.ToString(), obj.Value);
}
}
/// <summary>
/// 重载Dapper查询方法
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="cnn"></param>
/// <param name="sql"></param>
/// <param name="author"></param>
/// <param name="param"></param>
/// <param name="transaction"></param>
/// <param name="buffered"></param>
/// <param name="commandTimeout"></param>
/// <param name="commandType"></param>
/// <returns></returns>
public static IEnumerable <T> Query <T>(this IDbConnection cnn, string sql, Engineer author, object param = null, IDbTransaction transaction = null, bool buffered = true, int?commandTimeout = null, CommandType?commandType = null)
{
//是否开启查询监控
if (Common.PubConstant.IsOpenQuerySqlMonitorLog)
{
#region 计算时间
Stopwatch sw = new Stopwatch();
sw.Start();
var command = new CommandDefinition(sql, (object)param, transaction, commandTimeout, commandType, buffered ? CommandFlags.Buffered : CommandFlags.None);
var data = QueryImpl <T>(cnn, command, typeof(T));
sw.Stop();
#endregion
#region 判断执行时间 是否大于1秒
//if (sw.Elapsed.TotalSeconds >= GetTime())
//{
// #region 异步发送消息
// string ProjectName = "主项目";
// string SqlHash = sql.GetHashCode().ToString();
// string Runtime = sw.Elapsed.TotalSeconds.ToString();
// string SqlMsg = sql.Replace("\r\n", "");
// string SqlParam = GetString(param);
// AddMessageEntity(Runtime, ProjectName, SqlHash, SqlMsg, SqlParam, author.ToString(), DateTime.Now.ToString());
// #endregion
//}
#endregion
return(command.Buffered ? data.ToList() : data);
}
else
{
//没有开启监控
var command = new CommandDefinition(sql, (object)param, transaction, commandTimeout, commandType, buffered ? CommandFlags.Buffered : CommandFlags.None);
var data = QueryImpl <T>(cnn, command, typeof(T));
return(command.Buffered ? data.ToList() : data);
}
}
public static void Main()
{
IDList <Engineer> plist = new IDList <Engineer>();
plist.add(new Engineer("T", "1"));
plist.add(new Engineer("G", "6"));
plist.add(new Engineer("M", "9"));
try
{
Engineer frnd = plist.findByName("G");
Console.Write(frnd.Name + ": " + frnd.Number);
}
catch (NotFoundException)
{
Console.WriteLine("Not Found");
}
Console.WriteLine();
IDList <Manager> plist2 = new IDList <Manager>();
plist2.add(new Manager("H", "8"));
plist2.add(new Manager("C", "2"));
plist2.add(new Manager("N", "4"));
try
{
Manager sp = plist2.findByNumber("4");
Console.WriteLine(sp.Name + ": " + sp.Number);
}
catch (NotFoundException)
{
Console.WriteLine("Not Found");
}
// The following declaration is invalid
// because Guest does NOT implement IUserID.
// IDList<Guest> plist3 = new IDList<Guest>(); // Error!
}
public static ISoldier CreateSoldier(List <ISoldier> soldiers, string[] tokens, string soldierType, int id, string firstName, string lastName, decimal salary)
{
switch (soldierType)
{
case "Private":
return(new Private(id, firstName, lastName, salary));
case "LeutenantGeneral":
var commandingSoldiers = tokens.Skip(5);
var liutenant = new LeutenantGeneral(id, firstName, lastName, salary);
GetPrivates(soldiers, tokens, liutenant);
return(liutenant);
case "Commando":
var commandoCorps = tokens[5];
var commando = new Commando(id, firstName, lastName, salary, commandoCorps);
GetMissions(tokens, commando);
return(commando);
case "Engineer":
var engineerCorps = tokens[5];
var repairs = tokens.Skip(5);
var engineer = new Engineer(id, firstName, lastName, salary, engineerCorps);
GetRepairs(tokens, engineer);
return(engineer);
case "Spy":
var codeNumber = (int)salary;
return(new Spy(id, firstName, lastName, codeNumber));
default:
return(null);
}
}
private ISoldier GetEngineer(int id, string firstName, string lastName, decimal salary,
string[] splitted)
{
string corpsVal = splitted[5];
if (!Enum.TryParse(corpsVal, out Corps corps))
{
return(null);
}
IEngineer engineer = new Engineer(id, firstName, lastName, salary, corps);
for (int i = 6; i < splitted.Length; i += 2)
{
string repairPart = splitted[i];
int repairHour = int.Parse(splitted[i + 1]);
IRepair repair = new Repair(repairPart, repairHour);
engineer.Repairs.Add(repair);
}
return(engineer);
}
private ISoldier GetEngineer(int id, string firstName, string lastName, decimal salary, string[] args)
{
//In case of invalid corps the entire line should be skipped
var isValidCorps = Enum.TryParse(args[5], out Corps corps);
if (!isValidCorps)
{
return(null);
}
IEngineer engineer = new Engineer(id, firstName, lastName, salary, corps);
for (int i = 6; i < args.Length; i += 2)
{
string partName = args[i];
int hours = int.Parse(args[i + 1]);
IRepair repair = new Repair(partName, hours);
engineer.Repairs.Add(repair);
}
return(engineer);
}
/// <summary>
/// 写入日志
/// baochen
/// 2015年1月20日15:06:53
/// </summary>
/// <typeparam name="T">实体</typeparam>
/// <param name="t">当前类</param>
/// <param name="functionName">方法名称</param>
/// <param name="author">作者</param>
/// <param name="entity">参数实体</param>
/// <param name="ex">错误信息</param>
public static void WriteLog <T>(Type t, string functionName, Engineer author, T entity, Exception ex)
{
try
{
string str = string.Empty;
if (entity != null)
{
str = JsonConvertTool.SerializeObject(entity);
}
var log = LogManager.GetLogger(t);
var strInfo = "Error:方法名：" + functionName + "--作者：" + author.ToString() + "\r\n传入参数：\r\n" + str + "\r\n错误信息：" +
ex.Message + "\r\n" + ex.StackTrace + "\r\n" + "客户端ip:" + ip + ",请求连接：" + rawUrl;
log.Error(strInfo);
//EmailDelegate dn = new EmailDelegate(new SendEmail().Send);
//IAsyncResult ias = dn.BeginInvoke("屌丝你程序出错了", strInfo, author.ToString().Trim(), null, dn);
//dn.EndInvoke(ias);
}
catch
{
//记录日志时有可能出现异常
}
}
public ActionResult AddMachine(Engineer engineer, int MachineId, List <int> machines)
{
if (machines.Count != 0)
{
foreach (int machine in machines)
{
_db.EngineerMachine.Add(new EngineerMachine()
{
MachineId = machine, EngineerId = engineer.EngineerId
});
}
}
if (MachineId != 0)
{
_db.EngineerMachine.Add(new EngineerMachine()
{
MachineId = MachineId, EngineerId = engineer.EngineerId
});
}
_db.SaveChanges();
return(RedirectToAction("Index"));
}
public static void clearAndReloadRoles()
{
Jester.clearAndReload();
Mayor.clearAndReload();
Engineer.clearAndReload();
Sheriff.clearAndReload();
Lighter.clearAndReload();
Godfather.clearAndReload();
Mafioso.clearAndReload();
Janitor.clearAndReload();
Detective.clearAndReload();
TimeMaster.clearAndReload();
Medic.clearAndReload();
Shifter.clearAndReload();
Swapper.clearAndReload();
Lovers.clearAndReload();
Seer.clearAndReload();
Morphling.clearAndReload();
Camouflager.clearAndReload();
Spy.clearAndReload();
Child.clearAndReload();
}
private ISoldier GetEngineer(int id, string firstName, string lastName, decimal salary, string[] input)
{
var corpsParse = input[5];
if (!Enum.TryParse(corpsParse, out Corps corps))
{
return(null);
}
Engineer engineer = new Engineer(id, firstName, lastName, salary, corps);
for (int i = 6; i < input.Length; i += 2)
{
var repairPart = input[i];
var repairHours = int.Parse(input[i + 1]);
IRepair repair = new Repair(repairPart, repairHours);
engineer.Repairs.Add(repair);
}
return(engineer);
}
private void AddEngineer(string id, string firstName, string lastName, string[] data)
{
decimal salary = decimal.Parse(data[4]);
string corpsAsString = data[5];
bool isValidCorps = Enum.TryParse(corpsAsString, out Corps corps);
if (!isValidCorps)
{
return;
}
IEngineer engineer = new Engineer(id, firstName, lastName, salary, corps);
for (int i = 6; i < data.Length; i += 2)
{
string partName = data[i];
int hoursWorked = int.Parse(data[i + 1]);
engineer.Repairs.Add(new Repair(partName, hoursWorked));
}
this.soldiers.Add(engineer);
}
public void GivenTwoCandidatesReturned_Schedule_ReturnsNewSchedule()
{
using (var autoMock = AutoMock.GetLoose())
{
var firstEngineer = new Engineer(1, "1", "1");
var secondEngineer = new Engineer(2, "2", "2");
var engineers = new[] { firstEngineer, secondEngineer };
autoMock.Mock <ISupportCandidateSelector>()
.Setup(selector => selector.Select(_specification))
.Returns(engineers);
autoMock.Mock <IRandomSelector>()
.Setup(selector => selector.Select(It.IsAny <IEnumerable <Engineer> >()))
.Returns(engineers);
var sut = autoMock.Create <SupportScheduler>();
var result = sut.Schedule(_specification);
Assert.Equal(_specification.Date, result.Date);
Assert.Equal(engineers, result.Engineers);
}
}
public IActionResult CreateEngineer([FromBody] Engineer engineer)
{
try
{
if (engineer.IsObjectNull())
{
return(BadRequest("Engineer object is null"));
}
if (!ModelState.IsValid)
{
return(BadRequest("Invalid model object"));
}
_repository.Engineer.CreateEngineer(engineer);
return(CreatedAtRoute("EngineerById", new { id = engineer.Id }, engineer));
}
catch (Exception ex)
{
return(StatusCode(500, "Internal server error"));
}
}
private void CreateEngineer(string[] tokens, string soldierType, int soldierId, string firstName, string lastName)
{
if (soldierType == typeof(Engineer).Name)
{
decimal salary = decimal.Parse(tokens[4]);
List <IRepair> repairs = new List <IRepair>();
SoldierCropEnum crop;
if (Enum.TryParse(tokens[5], out crop))
{
for (int i = 6; i < tokens.Length - 1; i++)
{
string partName = tokens[i];
int hours = int.Parse(tokens[i + 1]);
var repair = new Repair(partName, hours);
repairs.Add(repair);
i++;
}
ISoldier currentSoldier = new Engineer(soldierId, firstName, lastName, salary, crop, repairs);
soldiers.Add(currentSoldier);
}
}
}
public override void add()
{
try
{
Engineer Engineer = new Engineer();
//setting the default company
Engineer.CompanyID = getDefaultCompany().Id;
EngineerForm EngineerViewer = new EngineerForm();
EngineerViewer.mainEntity = Engineer;
EngineerViewer.controller = this;
if (EngineerViewer.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
db.Engineer.Add(Engineer);
db.SaveChanges();
}
}
catch (System.InvalidOperationException ex)
{
MessageBox.Show(ex.Message);
}
}
private ISoldier GetEngineerType(int id, string firstName, string lastName, decimal salary, string[] newArgs)
{
IEngineer engineer = null;
Corp corp;
bool isCastToCorp = Enum.TryParse <Corp>(newArgs[0], out corp);
if (isCastToCorp)
{
engineer = new Engineer(id, firstName, lastName, salary, corp);
string partName;
int hoursWorked;
for (int i = 1; i < newArgs.Length; i += 2)
{
partName = newArgs[i];
hoursWorked = int.Parse(newArgs[i + 1]);
IRepair repair = new Repair(partName, hoursWorked);
engineer.AddRepairs(repair);
}
}
return(engineer);
}
private async Task CheckIfWeAreRespectingRestDays(Engineer engineer, DateTime date, Team team)
{
var lastShiftBeforeDate = engineer.Shifts
.Where(s => s.Date <= date)
.OrderByDescending(s => s.Date)
.FirstOrDefault();
if (lastShiftBeforeDate == null)
{
return;
}
int restDays = (date - lastShiftBeforeDate.Date).Days;
if (restDays > team.MinimumRestDaysAfterSupporting)
{
return;
}
// This may happen in real life, so instead of throwing an exception (because it's not),
// we just notify someone (INotifierService is responsible for knowing who and how to notify)...
await notifierService.MinimumRestDaysNotBeingRespected(engineer, lastShiftBeforeDate.Date, date).ConfigureAwait(false);
}
public void Should_Not_Allow_Vacation_When_Not_Available()
{
var engineer = new Engineer();
var date = DateTime.Now.AddMonths(1);
engineer.Id = Guid.NewGuid();
engineer.JobTitle = JobTitle.ProgrammerI;
engineer.Firstname = "Taylor";
engineer.TimeOffs.AddRange(new TimeOff[] {
new TimeOff(DateTime.Now.AddMonths(-9), 20),
new TimeOff(DateTime.Now.AddMonths(-7), 20),
new TimeOff(DateTime.Now.AddMonths(-5), 20),
new TimeOff(DateTime.Now.AddMonths(-3), 20),
new TimeOff(DateTime.Now.AddMonths(-1), 20)
});
engineer.TakeVacation(10, date);
//Assert.AreEqual(1, engineer.TimeOffs.Count);
//Assert.AreEqual(8, engineer.TimeOffs.First().HoursTaken);
//Assert.AreEqual(date.Date, engineer.TimeOffs.First().Date);
}
private ISoldier GetEngeneer(int id, string firstName, string lastName, decimal salary, string[] input)
{
var corpsStr = input[5];
Corps corps;
if (Enum.TryParse(corpsStr, out corps) == false)
{
return(null);
}
IEngineer engineer = new Engineer(id, firstName, lastName, salary, corps);
for (int i = 6; i < input.Length; i += 2)
{
var partName = input[i];
var workedHours = int.Parse(input[i + 1]);
IRepair repair = new Repair(partName, workedHours);
engineer.Repairs.Add(repair);
}
return(engineer);
}
public bool RemoveMember(Engineer gangMember)
{
DataAccess objADO = new DataAccess();
ArrayList colParameters = new ArrayList();
string strStoredProcedure = "delGangMember";
int intRowsAffected = 0;
colParameters.Add(new SqlParameter("@GangID", this.UserID));
colParameters.Add(new SqlParameter("@MemberID", gangMember.UserID));
intRowsAffected = objADO.ExecuteSQL(strStoredProcedure, (SqlParameter[])colParameters.ToArray(typeof(SqlParameter)));
objADO = null;
return (intRowsAffected > 0);
}
public List<Task> GetTaskList(Engineer e)
{
return new TaskListVisitor().GetAssignedTasks(e, this);
}
public void FromBin(NetSocket.ByteArray bin, twp.app.resource.AreaResourceType type)
{
switch (type) {
case twp.app.resource.AreaResourceType.AREA_RESOURCE_TYPE_RESOURCE:
goto case twp.app.resource.AreaResourceType.AREA_RESOURCE_TYPE_RESOURCE_MAX;
case twp.app.resource.AreaResourceType.AREA_RESOURCE_TYPE_RESOURCE_MAX:
{
resouce = new Resouce();
resouce.FromBin(bin);
}
break;
case twp.app.resource.AreaResourceType.AREA_RESOURCE_TYPE_ENGINEER:
goto case twp.app.resource.AreaResourceType.AREA_RESOURCE_TYPE_ENGINEER_MAX;
case twp.app.resource.AreaResourceType.AREA_RESOURCE_TYPE_ENGINEER_MAX:
{
engineer = new Engineer();
engineer.FromBin(bin);
}
break;
default:
break;
}
}
public static WorkerCollection PopulateTyped(DataSet collectionMembers, string sortPropertyName)
{
WorkerCollection colMembers = new WorkerCollection();
Worker objWorker = null;
DataRow[] gangMembers = null;
DataRow[] contractorDetails = null;
DataRow drContractor = null;
string filterExpression = string.Empty;
collectionMembers.Tables[0].TableName = "Common";
if (collectionMembers.Tables.Count > 1)
{
collectionMembers.Tables[1].TableName = "GangMembers";
collectionMembers.Tables[2].TableName = "ContractorDetails";
}
foreach (DataRow drMember in collectionMembers.Tables["Common"].Rows)
{
if (drMember["MobileIdentityType"].ToString().ToUpper() == "GANG")
{
objWorker = new Gang();
}
else if (drMember["MobileIdentityType"].ToString().ToUpper() == "CONTRACTOR")
{
objWorker = new Contractor();
}
else
{
objWorker = new Engineer(); // Assume Engineer
}
objWorker.UserID = drMember["UserID"].ToString();
objWorker.LoginName = drMember["ADLoginID"].ToString();
objWorker.EmpNo = drMember["EmpNo"].ToString();
if (drMember["EmpSurname"] != System.DBNull.Value)
{
objWorker.Surname = drMember["EmpSurname"].ToString();
}
if (drMember["EmpForenames"] != System.DBNull.Value)
{
objWorker.Forenames = drMember["EmpForenames"].ToString();
}
if (drMember["EmpPrefname"] != System.DBNull.Value)
{
objWorker.EmpPrefname = drMember["EmpPrefname"].ToString();
}
else
{
objWorker.EmpPrefname = objWorker.Forenames;
}
if (drMember["EmpAddress"] != System.DBNull.Value)
{
objWorker.EmpAddress = drMember["EmpAddress"].ToString();
}
else
{
objWorker.EmpAddress = string.Empty;
}
if (!drMember["EmailAddress"].Equals(DBNull.Value))
{
objWorker.Email = drMember["EmailAddress"].ToString();
}
if (!drMember["EmpMobileTelNo"].Equals(DBNull.Value))
{
objWorker.MobileNo = drMember["EmpMobileTelNo"].ToString();
}
objWorker.AreaDetails = new AreaDetails();
objWorker.AreaDetails.PrimaryArea = new Area();
objWorker.AreaDetails.PrimaryArea.Name = "UNKNOWN";
objWorker.AreaDetails.SubArea = new Area();
objWorker.AreaDetails.SubArea.Name = "UNKNOWN";
if (!drMember["PrimaryArea"].Equals(DBNull.Value))
{
objWorker.AreaDetails.PrimaryArea.Name = drMember["PrimaryArea"].ToString();
}
if (!drMember["SubArea"].Equals(DBNull.Value))
{
objWorker.AreaDetails.SubArea.Name = drMember["SubArea"].ToString();
}
if (drMember["IsClickEngineer"] != System.DBNull.Value)
{
objWorker.IsClickEngineer = (bool)drMember["IsClickEngineer"];
}
if (collectionMembers.Tables.Count > 1)
{
if (objWorker is Gang)
{
try
{
int numericUserID = 0;
if (int.TryParse(objWorker.UserID, out numericUserID))
{
throw new Exception("Gang ID must start with a non-numeric character");
// NB: .Select(filterExpression) can't handle it otherwise
}
filterExpression = string.Format("GangID='{0}'", objWorker.UserID);
gangMembers = collectionMembers.Tables["GangMembers"].Select(filterExpression);
if (gangMembers != null && gangMembers.Length > 0)
{
string[] gangUserIDs = new string[gangMembers.Length];
for (int index = 0; index < gangMembers.Length; index++)
{
gangUserIDs[index] = gangMembers[index]["MemberID"].ToString();
}
((Gang)objWorker).Members = WorkerCollection.GetTypedWorkers(string.Empty, gangUserIDs);
}
}
catch (Exception excE)
{
throw new Exception("Error attemping to load GangMembers : " + excE.Message, excE);
}
}
if (objWorker is Contractor)
{
// 2 types of contractor so only add extra properties to sub contractor
if (objWorker.AreaDetails.SubArea.Name.ToUpper() == "CONTRACTOR")
{
try
{
filterExpression = string.Format("UserID='{0}'", objWorker.UserID);
contractorDetails = collectionMembers.Tables["ContractorDetails"].Select(filterExpression);
if (contractorDetails != null && contractorDetails.Length > 0)
{
drContractor = contractorDetails[0];
objWorker.Email = drContractor[1].ToString();//Email
((Contractor)objWorker).Telephone = drContractor[2].ToString(); //Telephone
((Contractor)objWorker).Mobile = drContractor[3].ToString(); //Mobile
((Contractor)objWorker).Password = drContractor[4].ToString(); //Password
}
}
catch (Exception excE)
{
throw new Exception("Error attemping to load Contractors : " + excE.Message, excE);
}
}
}
}
colMembers.Add(objWorker);
}
if (!string.IsNullOrEmpty(sortPropertyName))
{
string actualPropertyName = sortPropertyName;
if (actualPropertyName.EndsWith(" DESC"))
{
actualPropertyName = actualPropertyName.Replace(" DESC", "");
colMembers.Sort(actualPropertyName, System.ComponentModel.ListSortDirection.Descending);
}
else
{
colMembers.Sort(actualPropertyName, System.ComponentModel.ListSortDirection.Ascending);
}
}
return colMembers;
}
public static void Main()
{
Engineer eng = new Engineer();
Console.WriteLine(eng.Name);
}
partial void InsertEngineer(Engineer instance);
partial void UpdateEngineer(Engineer instance);
partial void DeleteEngineer(Engineer instance);