public string addNewDept(string code, string name, int contact, int ph, int fax, int head, int col) { Department dept = new Department(); dept.Department_Code = code; dept.Department_Name = name; dept.Contact_Person = contact; dept.Phone = ph; dept.Fax = fax; dept.Department_Head = head; dept.CollectionID = col; entity.Departments.AddObject(dept); entity.SaveChanges(); string z = "New Dept \"" + code + "\" is added."; return z; }
public string UpdateDepartmentInfo(Department updateDeptInfo) { //Department updateInfo = this.GetDepartmentByCode(updateDeptInfo.Department_Code); Department updateInfo = entity.Departments.First(c => c.Department_Code == updateDeptInfo.Department_Code); if (updateInfo != null) { //Debug.WriteLine("DeptBLL update if loop."); //updateInfo.Department_Code = updateDeptInfo.Department_Code; updateInfo.Department_Name = updateDeptInfo.Department_Name; updateInfo.Contact_Person = updateDeptInfo.Contact_Person; updateInfo.Phone = updateDeptInfo.Phone; updateInfo.Fax = updateDeptInfo.Fax; updateInfo.Department_Head = updateDeptInfo.Department_Head; updateInfo.CollectionID = updateDeptInfo.CollectionID; //updateInfo.CollectionPoint = updateDeptInfo.CollectionPoint; } this.entity.SaveChanges(); string s = "Update is successful"; return s; }
/// <summary> /// Deprecated Method for adding a new object to the Departments EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToDepartments(Department department) { base.AddObject("Departments", department); }
/// <summary> /// Create a new Department object. /// </summary> /// <param name="department_Code">Initial value of the Department_Code property.</param> /// <param name="department_Name">Initial value of the Department_Name property.</param> /// <param name="contact_Person">Initial value of the Contact_Person property.</param> /// <param name="phone">Initial value of the Phone property.</param> /// <param name="collectionID">Initial value of the CollectionID property.</param> /// <param name="department_Head">Initial value of the Department_Head property.</param> public static Department CreateDepartment(global::System.String department_Code, global::System.String department_Name, global::System.Int32 contact_Person, global::System.Int32 phone, global::System.Int32 collectionID, global::System.Int32 department_Head) { Department department = new Department(); department.Department_Code = department_Code; department.Department_Name = department_Name; department.Contact_Person = contact_Person; department.Phone = phone; department.CollectionID = collectionID; department.Department_Head = department_Head; return department; }