/// <summary>
/// An item is being added.
/// </summary>
public override void ItemAdded(SPItemEventProperties properties)
{
base.ItemAdded(properties);
try
{
SPListItem curItem = properties.ListItem;
var departmentRepo = new DepartmentDAL(properties.Site.Url);
departmentRepo.CreateDepartmentSite(properties.SiteId, properties.Web.ID, curItem);
// Add bod approver to BOD group
var userBodString = Convert.ToString(properties.ListItem[StringConstant.DepartmentList.BODField]);
if (!string.IsNullOrEmpty(userBodString))
{
var employeeInfoRepo = new EmployeeInfoDAL(properties.Site.Url);
employeeInfoRepo.AddUserToGroup(properties.Site.ID, properties.Web.ID, curItem, StringConstant.Group.BODGroupName, userBodString);
}
}
catch (Exception ex)
{
ULSLogging.Log(new SPDiagnosticsCategory("STADA - Department Event Receiver - ItemAdded fn",
TraceSeverity.Unexpected, EventSeverity.Error), TraceSeverity.Unexpected,
string.Format(CultureInfo.InvariantCulture, "{0}:{1}", ex.Message, ex.StackTrace));
}
}
public void GetById()
{
DepartmentDAL dal = new DepartmentDAL();
Department department = dal.GetById(1);
log.Debug(department);
}
private void button1_Click(object sender, RoutedEventArgs e)
{
//using (TransactionScope ts = new TransactionScope())
//{
// DepartmentDAL deptDal = new DepartmentDAL();
// deptDal.Insert("aaa");
// deptDal.Insert("fffffffffffffffffffffffffff");
// test2();//嵌套事务
// throw new Exception();
// ts.Complete();
//}
using (TransactionScope ts = new TransactionScope())
{
DepartmentDAL dal = new DepartmentDAL();
dal.Insert("测试1");
//EmployeeDAL employeeDAl = new EmployeeDAL();
//Employee emp = new Employee();
//emp.
//employeeDAl.Insert(emp);
Operator op = new Operator();
op.UserName = "******";
op.Password = "******";
op.RealName = "haha";
new OperatorDAL().Insert(op);
ts.Complete();
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
EmployeeInformationDAL EmpInforDAL = new EmployeeInformationDAL();
RankDAL rankDAL = new RankDAL();
DepartmentDAL departDAL = new DepartmentDAL();
cmbGender.ItemsSource = EmpInforDAL.GetNameByCategory("Gender");
cmbRank.ItemsSource = rankDAL.ListAll();
cmbDepartment.ItemsSource = departDAL.ListAll();
Employee employee = new Employee();
employee.Birthday = DateTime.Today;
employee.ContractStartDate = DateTime.Today;
employee.ContractEndDate = DateTime.Today.AddYears(1);
employee.RankID = rankDAL.GetRankIDByRankName("Staff");
//employee.Password = pwdPassword.Password;
employee.DepartmentID = EditerDptID;
employee.PaidFreq = txtPaidFreq.Text;
if (IsEdited == false)
{
gridEdit.DataContext = employee;
}
else
{
Employee newemployee = new EmployeeDAL().GetByUerName(SelectedUserName);
gridEdit.DataContext = newemployee;
}
}
private void Admin_UpdateCourse_Load(object sender, EventArgs e)
{
textBox1.Text = MyCourse.C.Name;
depts = DepartmentDAL.GetAll();
for (int i = 0; i < depts.Count; i++)
{
ComboboxItem item = new ComboboxItem();
item.Text = depts[i].Name;
item.Value = depts[i].Id;
comboBox1.Items.Add(item);
}
String text;
int id;
int super = 0;
for (int i = 0; i < depts.Count; i++)
{
if (depts[i].Id == MyCourse.C.Deparment.Id)
{
super = i;
break;
}
}
comboBox1.SelectedText = MyCourse.C.Deparment.Name;
comboBox1.SelectedValue = MyCourse.C.Deparment.Id;
comboBox1.SelectedIndex = super;
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
cbDepartment.ItemsSource = DepartmentDAL.ListALL();
cbEducation.ItemsSource = IdNameDAL.GetByCatagory("学历");
cbGender.ItemsSource = IdNameDAL.GetByCatagory("性别");
cbMarriage.ItemsSource = IdNameDAL.GetByCatagory("婚姻状况");
cbPartyStatus.ItemsSource = IdNameDAL.GetByCatagory("政治面貌");
if (IsAddNew)
{
Employee employee = new Employee();
employee.InDate = DateTime.Today;
employee.ContractStartDay = DateTime.Today;
employee.ContractEndDay = DateTime.Today.AddYears(1);
employee.Nationality = "汉族";
employee.Email = "*****@*****.**";
//employee.Number = "Ideas";
employee.Number = SettingDAL.GetValue("员工工号前缀");
gridEmployee.DataContext = employee;
}
else
{
Employee employee = EmployeeDAL.GetById(EditingId);
gridEmployee.DataContext = employee;
if (employee.Photo != null)
{
ShowImage(employee.Photo);
}
}
}
private void ReadWriteCSVFile()
{
string date = System.DateTime.Now.ToString("ddMMyyhhmmss");
if (File.Exists(Server.MapPath(uppath)))
{
StreamReader sr = new StreamReader(Server.MapPath(uppath));
StreamWriter write = new StreamWriter(Server.MapPath(output));
CsvReader csvread = new CsvReader(sr);
CsvWriter csw = new CsvWriter(write);
IEnumerable <Department> record = csvread.GetRecords <Department>();
foreach (var rec in record) // Each record will be fetched and printed on the screen
{
csw.WriteRecord <Department>(rec);
csw.NextRecord();
DepartmentDAL departmentDAL = new DepartmentDAL();
departmentDAL.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString();
departmentDAL.InsertDepartment(rec);
}
sr.Close();
write.Close();//close file streams
if (File.Exists(Server.MapPath(uppath)))
{
File.Delete(Server.MapPath(uppath));
}
}
}
public List <DepartmentInfo> GetDepartmentsByLcid(string lcid, string locationIds)
{
try
{
List <DepartmentInfo> departments = new List <DepartmentInfo>();
DepartmentDAL departmentDAL = new DepartmentDAL(SPContext.Current.Web.Url);
List <int> locationCollection = locationIds.SplitStringOfLocations().ConvertAll(e => Convert.ToInt32(e));
var departmentList = departmentDAL.GetByLocations(locationCollection);
if (departmentList.Any())
{
foreach (var item in departmentList)
{
string departmentName = lcid.Equals("1066") ? item.VietnameseName : item.Name;
departments.Add(new DepartmentInfo()
{
Id = item.ID, DepartmentName = departmentName
});
}
}
return(departments);
}
catch (Exception ex)
{
ULSLogging.Log(new SPDiagnosticsCategory("STADA - Department Service - GetDepartmentsByLcid",
TraceSeverity.Unexpected, EventSeverity.Error), TraceSeverity.Unexpected,
string.Format(CultureInfo.InvariantCulture, "{0}:{1}", ex.Message, ex.StackTrace));
return(null);
}
}
private void _Save()
{
msg = "";
DepartmentModel dpt = new DepartmentModel();
dpt.DepartmentName = txtDepartmentName.Text.Trim();
dpt.Description = txtDescription.Text.Trim();
if (ckbIsActive.Checked == true)
{
dpt.IsActive = true;
}
else
{
dpt.IsActive = false;
}
DepartmentDAL objDal = new DepartmentDAL();
if (btnSave.Text == "Save")
{
msg = objDal._insertUpdateDeleteDepartment(dpt, "Insert");
}
else
{
dpt.DepartmentId = Convert.ToInt32(HdnDepartmentId.Value);
msg = objDal._insertUpdateDeleteDepartment(dpt, "Update");
}
if (msg != "")
{
_Refresh();
}
}
/// <summary>
/// 添加一个部门
/// </summary>
/// <returns>返回新部门的ID</returns>
public int Add()
{
DepartmentDAL dal = new DepartmentDAL(connectionString);
_id = dal.Add(_deptid, _deptname, _state);
return(_id);
}
/// <summary>
/// Get All Department
/// </summary>
/// <returns></returns>
public ActionResult GetAllDepartment()
{
DepartmentDAL departmentDAL = new DepartmentDAL();
ModelState.Clear();
return(View(departmentDAL.GetAllDepartment()));
}
protected void btnAddNewDept_Click(object sender, EventArgs e)
{
string confirmValue = Request.Form["confirm_value"];
if (confirmValue == "Yes")
{
//this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('You clicked YES!')", true);
}
else
{
//this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('You clicked NO!')", true);
}
DepartmentDAL departmentDAL = new DepartmentDAL();
Department com = new Department();
departmentDAL.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString();
com.ID = Convert.ToInt32(tbAddID.Text);
com.Name = tbAddDepartmentName.Text;
com.NameAr = tbAddArname.Text;
com.CompanyName = tbAddCompName.Text;
departmentDAL.InsertDepartment(com);
gvDept.EditIndex = -1;
tbAddID.Text = string.Empty;
tbAddDepartmentName.Text = string.Empty;
tbAddArname.Text = string.Empty;
tbAddCompName.Text = string.Empty;
GetDepartments();
}
public bool IsMemberOfDepartmentByCode(string employeeId, string departmentCode)
{
try
{
var departmentDal = new DepartmentDAL(SPContext.Current.Web.Url);
var employeeDal = new EmployeeInfoDAL(SPContext.Current.Web.Url);
var department = departmentDal.GetByCode(departmentCode);
if (department != null)
{
var employee = employeeDal.GetByDepartment(Convert.ToInt32(employeeId), Convert.ToInt32(department.ID), true); //get user active
if (employee != null)
{
return(true);
}
}
return(false);
}
catch (Exception ex)
{
SPDiagnosticsService.Local.WriteTrace(0,
new SPDiagnosticsCategory("STADA - Employee Service - IsMemberOfDepartmentByCode fn",
TraceSeverity.Unexpected, EventSeverity.Error), TraceSeverity.Unexpected,
string.Format(CultureInfo.InvariantCulture, "{0}:{1}", ex.Message, ex.StackTrace));
return(false);
}
}
private void FillDepartmentDetails(long iDeptId)
{
Department oDepartment = new Department();
DepartmentDAL oDepartmentDAL = new DepartmentDAL();
if (iDeptId > 0)
{
oDepartment.Cmd_Name = "SelectSingleDepartment";
oDepartment.Dept_id = iDeptId;
DataTable dt = oDepartmentDAL.GetDepartmentList(oDepartment);
if (dt.Rows.Count > 0)
{
txtDeptName.Text = dt.Rows[0]["Dept_Name"].ToString().Trim();
}
btnAdd.Visible = false;
btnDelete.Visible = true;
btnUpdate.Visible = true;
}
else
{
oDepartment.Cmd_Name = "SelectAllDepartment";
DataTable dt = oDepartmentDAL.GetDepartmentList(oDepartment);
grvDepartment.DataSource = dt;
grvDepartment.DataBind();
btnAdd.Visible = true;
btnDelete.Visible = false;
btnUpdate.Visible = false;
}
}
private void LoadDataByID(int iDptID)
{
Department oDpt = new Department(iDptID);
DepartmentDAL oDptDAL = new DepartmentDAL();
Result oResult = new Result();
oResult = oDptDAL.LoadByID(oDpt);
ClearTextValue();
if (oResult.Status)
{
oDpt = (Department)oResult.Return;
if (oDpt != null)
{
txtDepartmentID.Text = oDpt.DepartmentID.ToString();
txtDepartmentName.Text = oDpt.Description.ToString();
ucUserDet.UserDetail = oDpt.UserDetails;
hdDptID.Value = iDptID.ToString();
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("Delete"), true);
}
}
// ok
protected void btnDelete_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(hdDptID.Value))
{
DepartmentDAL oDptDAL = new DepartmentDAL();
Result oResult = (Result)oDptDAL.Detete(hdDptID.Value);
if (oResult.Status)
{
this.LoadList();
this.ClearTextValue();
ucMessage.OpenMessage(Constants.MSG_SUCCESS_DELETE, Constants.MSG_TYPE_SUCCESS);
}
else
{
if (oResult.Message.Equals(Constants.TABLE_MAIN))
{
ucMessage.OpenMessage(Constants.MSG_APPROVED_DELETE_DATA, Constants.MSG_TYPE_ERROR);
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_DELETE, Constants.MSG_TYPE_ERROR);
}
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_DELETE, Constants.MSG_TYPE_ERROR);
}
}
/// <summary>
/// Delete Department
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult DeleteDepartment(int id)
{
DepartmentDAL departmentDAL = new DepartmentDAL();
string result = departmentDAL.DeleteDepartment(id);
ViewData["result"] = result;
ModelState.Clear();
return(RedirectToAction("GetAllDepartment"));
}
public DataSet Find_Depdet(String str)
{
DepartmentDAL PDALF = new DepartmentDAL();
DataSet data = null;
data = PDALF.Find_dep(str); //PDAL.Find(str);
return(data);
}
public ActionResult UpdateDepartment(DepartmentCustom data)
{
DepartmentDAL departmentDAL = new DepartmentDAL();
string result = departmentDAL.UpdateDepartment(data);
ViewData["result"] = result;
ModelState.Clear();
return(View());
}
public void Update()
{
DepartmentDAL dal = new DepartmentDAL();
Department department = dal.GetById(1);
department.Name = "DIT .NET";
dal.Update(department);
//department = dal.GetById(1);
}
protected void gvDept_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "DeleteDepartment")
{
DepartmentDAL departmentDAL = new DepartmentDAL();
departmentDAL.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString();
departmentDAL.DeleteDepartment(e.CommandArgument.ToString());
GetDepartments();
}
}
public EmployeeService()
{
var url = SPContext.Current.Web.Url;
_employeeInfoDAL = new EmployeeInfoDAL(url);
_departmentDAL = new DepartmentDAL(url);
_overtimeManagementDAL = new OverTimeManagementDAL(url);
_overtimeManagementDetailDAL = new OverTimeManagementDetailDAL(url);
_employeePositionDAL = new EmployeePositionDAL(url);
}
private void GetDepartments(string Name)
{
DepartmentDAL departmentDAL = new DepartmentDAL();
departmentDAL.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString();
List <Department> DepartmentsList = departmentDAL.GetDepartment(Name);
gvDept.DataSource = DepartmentsList;
gvDept.DataBind();
}
private void Window_Loaded_1(object sender, RoutedEventArgs e)
{
if (!IsAddNew)
{
Department dept = new DepartmentDAL().GetById(EditingId);
txtName.Text = dept.Name;
}
txtName.Focus();
}
// 修改验证是否存在
public static bool IsTrue(string Name, int Id)
{
Department model = DepartmentDAL.GetIdByName(Name);
if (model != null && model.DeptId != 0 && model.DeptId != Id)
{
return(true);
}
return(false);
}
public static IList <Department> DepartmentListInstance(string siteURL)
{
// TODO: not thread-safe, should lock object to ensure thread-safe
if (departments == null)
{
departmentDAL = new DepartmentDAL(siteURL);
departments = departmentDAL.GetAll();
}
return(departments);
}
private void _LoadGrid()
{
DepartmentDAL Dept = new DepartmentDAL();
DataTable dt = new DataTable();
dt = Dept._SelectAllDepartment();
gvDepartment.DataSource = dt;
gvDepartment.DataBind();
Session["Ses_Department"] = dt;
}
static void Main(string[] args)
{
int studentId = 3;
StudentDAL studentDAL = new StudentDAL();
DepartmentDAL departmentDAL = new DepartmentDAL();
CoueseTeacherDAL courseTeacherDAL = new CoueseTeacherDAL();
var StudentEnroll = from s in studentDAL.StudentEnrollListGetAll()
join c in courseTeacherDAL.CourseGetAll() on s.CourseId equals c.CourseId
select new
{
StudentId = s.StudentId,
StudentName = s.StudentName,
StudentEmail = s.StudentEmail,
DepartmentName = s.DepartmentName,
CourseCode = c.CourseCode,
CourseName = c.CourseName,
CourseId = c.CourseId,
};
var StudentEnrollByStudentId = StudentEnroll.Where(c => c.StudentId == studentId).ToList();
var StudentResulByStudentId = studentDAL.SaveStudentResultGetAll().Where(c => c.StudentId == studentId).ToList();
var result = from e in StudentEnrollByStudentId
join d in StudentResulByStudentId
on e.CourseId equals d.CourseId into eGroup
from d in eGroup.DefaultIfEmpty()
select new
{
StudentId = e.StudentId,
StudentName = e.StudentName,
StudentEmail = e.StudentEmail,
DepartmentName = e.DepartmentName,
CourseId = e.CourseId,
CourseCode = e.CourseCode,
CourseName = e.CourseName,
GradeLatter = d == null ? "Not Graded Yet" : d.GradeLetter
};
foreach (var c in result)
{
Console.WriteLine(c.StudentId + "\t" + c.StudentName + "\t"
+ c.StudentEmail + "\t" + c.DepartmentName + "\t"
+ c.CourseId + "\t" + c.CourseCode + "\t" + c.CourseName + "\t" + c.GradeLatter
);
}
Console.ReadKey();
//foreach (var c in result)
//{
// Console.WriteLine(c.StudentId + "\t" + c.StudentName + "\t"
// + c.StudentEmail + "\t" + c.DepartmentName + "\t"
// + c.CourseCode + "\t" + c.CourseName + "\t" + c.GradeLatter
// );
//}
//Console.ReadKey();
}
public static bool DeleteOrganisationComm(int departmentID)
{
try
{
return(DepartmentDAL.DeleteDepartment(departmentID));
}
catch (Exception ex)
{
throw new EvolutionBusinessLogic.Exceptions.EvolutionException(ex.Message, ex.InnerException);
}
}
public static bool InsertOrganisationComm(Department department)
{
try
{
return(DepartmentDAL.InsertDepartment(department));
}
catch (Exception ex)
{
throw new EvolutionBusinessLogic.Exceptions.EvolutionException(ex.Message, ex.InnerException);
}
}
