public SqlDataAdapter ReqCity() { AddEmployeeDAL ed = new AddEmployeeDAL(); SqlDataAdapter rd = ed.GetCity(); return(rd); }
public SqlDataAdapter EmployeeCredentials(Employee e) { SqlParameter[] sp = new SqlParameter[1]; sp[0] = new SqlParameter("@emailid", e.employeeEmail); AddEmployeeDAL ed = new AddEmployeeDAL(); SqlDataAdapter rd = ed.GetEmployeeCredential(sp); return(rd); }
public void EmployeeInsertBusiness(Employee e) { SqlParameter[] sp = new SqlParameter[10]; sp[0] = new SqlParameter("@upassword", e.employeePass); sp[1] = new SqlParameter("@uname", e.employeeName); sp[2] = new SqlParameter("@emailid", e.employeeEmail); sp[3] = new SqlParameter("@mobile", e.employeeMobile); sp[4] = new SqlParameter("@annual_income", e.EIncome); sp[5] = new SqlParameter("@pincode", e.employeePincode); sp[6] = new SqlParameter("@address", e.employeeAddress); sp[7] = new SqlParameter("@dob", e.employeeDob); sp[8] = new SqlParameter("@created_at", e.createdAt); sp[9] = new SqlParameter("@city_name", e.employeeCity); try { AddEmployeeDAL ed = new AddEmployeeDAL(); ed.insert_Employee(sp); } catch (Exception ex) { Console.Write(ex); } }