//Tharrani – End //Esther public string CreateAdjustment(String token, WCF_Adjustment adj) { if (AuthenticateToken(token)) { String now = DateTime.Now.ToString("yyyy-MM-dd"); WCF_Employee employee = GetEmployeeByToken(token); adjustment a = new adjustment() { adjustment_date = DateTime.ParseExact(now, "yyyy-MM-dd", null), employee_id = employee.EmployeeId, item_number = adj.ItemNumber.Trim(), adjustment_quantity = Int32.Parse(adj.AdjustmentQty.Trim()), adjustment_price = BusinessLogic.Adjprice(adj.ItemNumber) * Int32.Parse(adj.AdjustmentQty.Trim()), adjustment_status = "Pending", employee_remark = adj.EmployeeRemark, manager_remark = null, }; String result1 = BusinessLogic.CreateAdjustment(a); String email = BusinessLogic.SendEmailAdjustmentApproval(a); try { BusinessLogic.sendMail(email, "New Adjustment Request", employee.EmployeeName + " raised new adjustment request."); } catch (Exception ex) { return("email exception " + ex.Message); } return(result1); } else { return("invalid token"); } }
//Add new requisition order public string AddNewRequest(WCF_Token token) { string x = token.gettoken.Replace(@"\", "").Trim(); if (AuthenticateToken(x)) { WCF_Employee emp = GetEmployeeByToken(x); int emp_id = Convert.ToInt32(emp.EmployeeId); //16; string Depid = emp.DepartmentId.Trim(); //ENGL; DateTime d = DateTime.Now.Date; unique_id u = BusinessLogic.getlastrequestid(Depid); int i = (int)u.req_id + 1; string id = Depid + "/" + DateTime.Now.Year.ToString() + "/" + i; BusinessLogic.AddNewRequisitionOrder(id, emp_id, d); BusinessLogic.updatelastrequestid(Depid, i); int head_id = Convert.ToInt32(BusinessLogic.GetDepartmenthead(Depid).head_id); string to = BusinessLogic.GetEmployee(head_id).email_id; //string to = "*****@*****.**"; string ename = BusinessLogic.GetEmployee(emp_id).employee_name; string sub = "Stationery System: New request raised for your approval"; string body = "New Request ID" + id + "has been placed by" + ename + "for your approval"; BusinessLogic.sendMail(to, sub, body); return(id); } else { return(null); } }
/* * Logs the user into the system. * * Takes username and password in * If the username and password is valid, this generates a token for the employee * This token is stored into the database for validation when using in other methods. */ public WCF_Employee Login(string username, string password) { WCF_Employee wcfEmployee = null; // If login succeeds, fetch the token, otherwise, return null // Validate username and password if (Membership.ValidateUser(username, password)) { // Fetch or generate token var context = new LogicUniversityEntities(); var query = from x in context.employees where x.user_id == username select x; var result = query.ToList(); if (query.Any()) { // Generate a token for the resulting employee. String token = GenerateToken(); // Store token in database var first = result.First(); first.token = token; System.Diagnostics.Debug.WriteLine(context.SaveChanges()); // Pass the token to the service consumer wcfEmployee = new WCF_Employee(first.employee_id, first.employee_name, first.email_id, username, first.department_id, first.supervisor_id, token, Roles.GetRolesForUser(username).FirstOrDefault()); } } // Return the token to user return(wcfEmployee); }
// to update the collection location - android public void updatelocation(string token, WCF_collectionpoint cp) { if (AuthenticateToken(token)) { WCF_Employee emp = GetEmployeeByToken(token); string dept = emp.DepartmentId; BusinessLogic.updatecollectionlocation(dept, Convert.ToInt32(cp.id)); } else { } }
// to get the budget of the current month- both allocated and spent for a particular department - Android public WCF_Budget getbudget(string token) { if (AuthenticateToken(token)) { WCF_Employee emp = GetEmployeeByToken(token); string dept = emp.DepartmentId; int b1 = BusinessLogic.getbudgetbydept(dept); int b2 = BusinessLogic.getspentbudgetbydept(dept); WCF_Budget x = new WCF_Budget(b1.ToString(), b2.ToString()); return(x); } else { return(null); } }
// to get the item details of the particular ro- android public List <WCF_itemdetails> getitemdetails(string token, string id) { if (AuthenticateToken(token)) { WCF_Employee emp = GetEmployeeByToken(token); List <getitemdetails_Result> list = BusinessLogic.pendinggetitemdetails(id); List <WCF_itemdetails> list1 = new List <WCF_itemdetails>(); foreach (getitemdetails_Result r in list) { list1.Add(new WCF_itemdetails(r.description.TrimEnd(), r.item_requisition_quantity.ToString())); } return(list1); } else { return(null); } }
// to get the history of collection of the department -android public List <WCF_collectionhistory> gethistory(string token) { if (AuthenticateToken(token)) { WCF_Employee emp = GetEmployeeByToken(token); string dept = emp.DepartmentId; List <getcollectiondetailsbydepartment_Result> list = BusinessLogic.getdepartmentcollection(dept); List <WCF_collectionhistory> list1 = new List <WCF_collectionhistory>(); foreach (getcollectiondetailsbydepartment_Result r in list) { list1.Add(new WCF_collectionhistory(r.collection_place.TrimEnd(), r.collection_date.ToString("dd-MM-yyyy"))); } return(list1); } else { return(null); } }
//Esther end //Sruthi start //to find the pending ros for the android public List <WCF_approvero> Findpendingros(string token) { if (AuthenticateToken(token)) { WCF_Employee emp = GetEmployeeByToken(token); string dept = emp.DepartmentId; List <getpendingrequestsbydepartment_Result> pendingros = BusinessLogic.ViewPendingRequests(dept); List <WCF_approvero> list = new List <WCF_approvero>(); foreach (getpendingrequestsbydepartment_Result ro in pendingros) { double sum = (ro.Sum.HasValue ? ro.Sum.Value : 0); list.Add(new WCF_approvero(ro.id.TrimEnd(), ro.Date.ToString("dd-MM-yyyy"), ro.Name.TrimEnd(), ro.status, sum.ToString())); } return(list); } else { return(null); } }