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);
}
