public JsonResult employee_list_view(employee_list_view_lib obj) { obj.company_id = Convert.ToInt32(Crypto.url_decrypt(Request.Cookies["CompanyId"])); var result = JsonConvert.SerializeObject(_master.employee_list_viewAsync(obj).Result.ToList()); JsonResult json = Json(result); return(json); }
public List <employee_list_view_lib> employee_list_view(employee_list_view_lib obj) { SqlConnection sqlConn = new SqlConnection(_master); SqlCommand sqlcomm = new SqlCommand(); sqlcomm.Connection = sqlConn; DataTable dt = new DataTable(); List <employee_list_view_lib> ret = new List <employee_list_view_lib>(); try { SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = sqlcomm; sqlcomm.CommandText = "employee_list_view"; da.SelectCommand.CommandType = CommandType.StoredProcedure; sqlcomm.Parameters.Clear(); sqlcomm.Parameters.AddWithValue("@employee_id", obj.employee_id); sqlcomm.Parameters.AddWithValue("@is_active", obj.active); sqlcomm.Parameters.AddWithValue("@is_bp", obj.approved); sqlcomm.Parameters.AddWithValue("@company_id", obj.company_id); da.Fill(dt); ret = (from DataRow dr in dt.Rows select new employee_list_view_lib() { employee_id = Convert.ToInt32(dr["employee_id"].ToString()), employee_code = dr["employee_code"].ToString(), username = dr["username"].ToString(), userhash = dr["userhash"].ToString(), first_name = dr["first_name"].ToString(), middle_name = dr["middle_name"].ToString(), last_name = dr["last_name"].ToString(), full_name = dr["full_name"].ToString(), display_name = dr["display_name"].ToString(), nick_name = dr["nick_name"].ToString(), email_address = dr["email_address"].ToString(), birthday = dr["birthday"].ToString(), birth_place = dr["birth_place"].ToString(), height = dr["height"].ToString(), weight = dr["weight"].ToString(), phone_home = dr["phone_home"].ToString(), phone_work = dr["phone_work"].ToString(), phone_mobile = dr["phone_mobile"].ToString(), phone_fax = dr["phone_fax"].ToString(), phone_other = dr["phone_other"].ToString(), address_street = dr["address_street"].ToString(), address_city = dr["address_city"].ToString(), address_state = dr["address_state"].ToString(), address_country = dr["address_country"].ToString(), address_zipcode = dr["address_zipcode"].ToString(), perm_street = dr["perm_street"].ToString(), perm_city = dr["perm_city"].ToString(), perm_state = dr["perm_state"].ToString(), perm_country = dr["perm_country"].ToString(), perm_zipcode = dr["perm_zipcode"].ToString(), image_path = dr["image_path"].ToString(), question1 = Convert.ToInt32(dr["question1"].ToString()), answer1 = dr["answer1"].ToString(), question2 = Convert.ToInt32(dr["question2"].ToString()), answer2 = dr["answer2"].ToString(), website = dr["website"].ToString(), facebook = dr["facebook"].ToString(), twitter = dr["twitter"].ToString(), instagram = dr["instagram"].ToString(), linkedin = dr["linkedin"].ToString(), skype = dr["skype"].ToString(), tumblr = dr["tumblr"].ToString(), salutation_id = Convert.ToInt32(dr["salutation_id"].ToString()), gender_id = Convert.ToInt32(dr["gender_id"].ToString()), civil_status_id = Convert.ToInt32(dr["civil_status_id"].ToString()), nationality_id = Convert.ToInt32(dr["nationality_id"].ToString()), religion_id = Convert.ToInt32(dr["religion_id"].ToString()), user_group_id = Convert.ToInt32(dr["user_group_id"].ToString()), warehouse_id = Convert.ToInt32(dr["warehouse_id"].ToString()), company_id = Convert.ToInt32(dr["company_id"].ToString()), active = Convert.ToBoolean(dr["active"].ToString()), created_by = Convert.ToInt32(dr["created_by"].ToString()), date_created = dr["date_created"].ToString(), approved = Convert.ToBoolean(dr["approved"].ToString()), bp_status = dr["bp_status"].ToString(), enc_key = dr["enc_key"].ToString(), fix = Convert.ToBoolean(dr["fix"].ToString()), access_level_id = Convert.ToInt32(dr["access_level_id"].ToString()) }).ToList(); } catch (Exception e) { Console.WriteLine("Error: " + e.Message); error_log_in("0", "SP = employee_list_view | " + e.Message, 0, 0); } finally { sqlConn.Close(); } return(ret); }