private InterActionMessageEmployeeStatus GetNullValue()
{
var nullResult = new InterActionMessageEmployeeStatus
{
EmployeeID = 0,
UserName = "******",
NewMessageStatus = 0
};
return(nullResult);
}
public MyInterActionMessageEmployeeStatus(string userName)
{
if (userName == null)
{
Value = GetNullValue();
return;
}
if (userName.Length < 2)
{
Value = GetNullValue();
return;
}
_userName = userName;
Value = GetValue();
}
private InterActionMessageEmployeeStatus GetValue()
{
var iam = _dbml.InterActionMessageEmployeeStatus.FirstOrDefault(x => x.UserName == _userName);
if (iam != null)
{
var result = new InterActionMessageEmployeeStatus
{
EmployeeID = iam.EmployeeID,
UserName = iam.UserName,
NewMessageStatus = iam.NewMessageStatus,
};
return(result);
}
var employee = _dbml.FW_Employees.FirstOrDefault(x => x.UserName == _userName);
var eID = 0;
if (employee != null)
{
eID = employee.EmployeeNumber;
}
var nullResult = new InterActionMessageEmployeeStatus
{
EmployeeID = eID,
UserName = _userName,
NewMessageStatus = 0
};
if (eID != 0)
{
_dbml.InterActionMessageEmployeeStatus.InsertOnSubmit(nullResult);
_dbml.SubmitChanges();
}
return(nullResult);
}
public MyInterActionMessageEmployeeStatusUpdate(int employeeID)
{
if (employeeID < 10)
{
return;
}
_employeeID = employeeID;
var es = _dbml.InterActionMessageEmployeeStatus.SingleOrDefault(x => x.EmployeeID == _employeeID);
if (es == null)
{
var emp = _dbml.FW_Employees.Single(x => x.EmployeeNumber == _employeeID);
var nullResult = new InterActionMessageEmployeeStatus
{
EmployeeID = _employeeID,
UserName = emp.UserName,
NewMessageStatus = 0
};
_dbml.InterActionMessageEmployeeStatus.InsertOnSubmit(nullResult);
_dbml.SubmitChanges();
}
}