public ActionResult LoadData(Level1Models LSModel) { GenericService act = new GenericService(); SqlParameter[] parameters = { new SqlParameter("@Activity", "GetData") }; DataSet ds = act.Generic("LS_SPLevel1", parameters); var Object = ConvertDataTableToJSON(ds.Tables[0]); return(this.Json(Object, JsonRequestBehavior.AllowGet)); }
public ActionResult GetAllEmp(int PageNumber = 1, int PageSize = 3) { EmployeeCVModel emp = new EmployeeCVModel(); GenericService act = new GenericService(); SqlParameter[] parameters = { new SqlParameter("@EmpID", SqlDbType.NVarChar, 12) { Value = emp.EmpID ?? (object)DBNull.Value }, new SqlParameter("@VLastName", SqlDbType.NVarChar, 100) { Value = emp.VLastName ?? (object)DBNull.Value }, new SqlParameter("@VFirstName", SqlDbType.NVarChar, 100) { Value = emp.VFirstName ?? (object)DBNull.Value }, new SqlParameter("@NickName", SqlDbType.NVarChar, 50) { Value = emp.NickName ?? (object)DBNull.Value }, new SqlParameter("@DOB", SqlDbType.NVarChar, 50) { Value = emp.DOB ?? (object)DBNull.Value }, new SqlParameter("@Gender", SqlDbType.NVarChar, 1) { Value = emp.Gender ?? (object)DBNull.Value }, new SqlParameter("@Email", SqlDbType.NVarChar, 50) { Value = emp.Email ?? (object)DBNull.Value }, new SqlParameter("@ACTION", "SelectAll") //new SqlParameter("@PageNumber",PageNumber), //new SqlParameter("@PageSize",PageSize) }; //DataSet ds = act.crud("sp_InsertUpdateDelete_tblEmpCV", parameters); DataSet ds = act.Generic("sp_InsertUpdateDelete_tblEmpCV", parameters); ViewBag.emp = ds.Tables[0]; return(View(new EmployeeCVModel())); }
public ActionResult DeleteEmp(string id, string email) { EmployeeCVModel emp = new EmployeeCVModel(); GenericService act = new GenericService(); emp.EmpID = id; emp.Email = email; SqlParameter[] parameters = { new SqlParameter("@EmpID", SqlDbType.NVarChar, 12) { Value = emp.EmpID ?? (object)DBNull.Value }, new SqlParameter("@VLastName", SqlDbType.NVarChar, 100) { Value = emp.VLastName ?? (object)DBNull.Value }, new SqlParameter("@VFirstName", SqlDbType.NVarChar, 100) { Value = emp.VFirstName ?? (object)DBNull.Value }, new SqlParameter("@NickName", SqlDbType.NVarChar, 50) { Value = emp.NickName ?? (object)DBNull.Value }, new SqlParameter("@DOB", SqlDbType.NVarChar, 50) { Value = emp.DOB ?? (object)DBNull.Value }, new SqlParameter("@Gender", SqlDbType.NVarChar, 1) { Value = emp.Gender ?? (object)DBNull.Value }, new SqlParameter("@Email", SqlDbType.NVarChar, 50) { Value = emp.Email ?? (object)DBNull.Value }, new SqlParameter("@ACTION", "SelectByID") }; DataSet ds = act.Generic("sp_InsertUpdateDelete_tblEmpCV", parameters); ViewBag.emp = ds.Tables[0]; return(View()); }
public ActionResult CreateEmp(EmployeeCVModel emp) { GenericService act = new GenericService(); emp.EmpID = act.getOutPut("sp_AutoGenID_Emp_Test", "@EmpID"); SqlParameter[] parameters = { new SqlParameter("@EmpID", SqlDbType.NVarChar, 12) { Value = emp.EmpID ?? (object)DBNull.Value }, new SqlParameter("@VLastName", SqlDbType.NVarChar, 100) { Value = emp.VLastName ?? (object)DBNull.Value }, new SqlParameter("@VFirstName", SqlDbType.NVarChar, 100) { Value = emp.VFirstName ?? (object)DBNull.Value }, new SqlParameter("@NickName", SqlDbType.NVarChar, 50) { Value = emp.NickName ?? (object)DBNull.Value }, new SqlParameter("@DOB", SqlDbType.NVarChar, 50) { Value = emp.DOB ?? (object)DBNull.Value }, new SqlParameter("@Gender", SqlDbType.NVarChar, 1) { Value = emp.Gender ?? (object)DBNull.Value }, new SqlParameter("@Email", SqlDbType.NVarChar, 50) { Value = emp.Email ?? (object)DBNull.Value }, new SqlParameter("@ACTION", "Insert") }; DataSet ds = act.Generic("sp_InsertUpdateDelete_tblEmpCV", parameters); return(RedirectToAction("GetAllEmp")); }
public ActionResult DeleteEmp(string id, string email, EmployeeCVModel emp) { GenericService act = new GenericService(); emp.EmpID = id; emp.Email = email; SqlParameter[] parameters = { new SqlParameter("@EmpID", SqlDbType.NVarChar, 12) { Value = emp.EmpID ?? (object)DBNull.Value }, new SqlParameter("@VLastName", SqlDbType.NVarChar, 100) { Value = emp.VLastName ?? (object)DBNull.Value }, new SqlParameter("@VFirstName", SqlDbType.NVarChar, 100) { Value = emp.VFirstName ?? (object)DBNull.Value }, new SqlParameter("@NickName", SqlDbType.NVarChar, 50) { Value = emp.NickName ?? (object)DBNull.Value }, new SqlParameter("@DOB", SqlDbType.NVarChar, 50) { Value = emp.DOB ?? (object)DBNull.Value }, new SqlParameter("@Gender", SqlDbType.NVarChar, 1) { Value = emp.Gender ?? (object)DBNull.Value }, new SqlParameter("@Email", SqlDbType.NVarChar, 50) { Value = emp.Email ?? (object)DBNull.Value }, new SqlParameter("@ACTION", "Delete") }; act.Generic("sp_InsertUpdateDelete_tblEmpCV", parameters); return(RedirectToAction("GetAllEmp")); }
public ActionResult GetAllEmp(EmployeeCVModel emp) { SqlConnection conn = new SqlConnection(ConnectionString); GenericService act = new GenericService(); if (emp.searchtxt != null) { SqlParameter[] parameters = { new SqlParameter("@Searchtext", SqlDbType.NVarChar, 50) { Value = emp.searchtxt ?? (object)DBNull.Value } }; DataSet ds = act.Generic("sp_SearchData_EmpCV", parameters); ViewBag.emp = ds.Tables[0]; return(View(new EmployeeCVModel())); } else { return(View()); } }
// GET: Company public ActionResult GetAllCompany(int PageNumber = 1, int PageSize = 3) { LSCompanyModel com = new LSCompanyModel(); GenericService act = new GenericService(); SqlParameter[] parameters = { new SqlParameter("@LSCompanyID", SqlDbType.NVarChar, 12) { Value = com.LSCompanyID ?? (object)DBNull.Value }, new SqlParameter("@LSCompanyCode", SqlDbType.NVarChar, 100) { Value = com.LSCompanyCode ?? (object)DBNull.Value }, new SqlParameter("@ShortName", SqlDbType.NVarChar, 100) { Value = com.ShortName ?? (object)DBNull.Value }, new SqlParameter("@Name", SqlDbType.NVarChar, 50) { Value = com.Name ?? (object)DBNull.Value }, new SqlParameter("@Address", SqlDbType.NVarChar, 50) { Value = com.Address ?? (object)DBNull.Value }, new SqlParameter("@Phone", SqlDbType.NVarChar, 1) { Value = com.Phone ?? (object)DBNull.Value }, new SqlParameter("@Fax", SqlDbType.NVarChar, 50) { Value = com.Fax ?? (object)DBNull.Value }, new SqlParameter("@Rank", SqlDbType.NVarChar, 50) { Value = com.Rank.ToString() ?? (object)DBNull.Value }, new SqlParameter("@Note", SqlDbType.NVarChar, 50) { Value = com.Note ?? (object)DBNull.Value }, new SqlParameter("@Used", SqlDbType.NVarChar, 50) { Value = com.Used.ToString() ?? (object)DBNull.Value }, new SqlParameter("@WorkingPlace", SqlDbType.NVarChar, 50) { Value = com.WorkingPlace ?? (object)DBNull.Value }, new SqlParameter("@Creater", SqlDbType.NVarChar, 50) { Value = com.Creater ?? (object)DBNull.Value }, new SqlParameter("@CreateTime", SqlDbType.NVarChar, 50) { Value = com.CreateTime ?? (object)DBNull.Value }, new SqlParameter("@Editer", SqlDbType.NVarChar, 50) { Value = com.Editer ?? (object)DBNull.Value }, new SqlParameter("@EditTime", SqlDbType.NVarChar, 50) { Value = com.EditTime ?? (object)DBNull.Value }, new SqlParameter("@ACTION", "SelectAll") //new SqlParameter("@PageNumber",PageNumber), //new SqlParameter("@PageSize",PageSize) }; //DataSet ds = act.crud("sp_InsertUpdateDelete_tblEmpCV", parameters); DataSet ds = act.Generic("sp_InsertUpdateDelete_tblLSCompany", parameters); ViewBag.com = ds.Tables[0]; return(View(new LSCompanyModel())); }