public static object UpdateNews(tbl_News model, string NgayDeliverConvert)
{
var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true);
var obj = new GCRequest
{
_a = "Updatetbl_News", //Action prefix f,p for get data; tbl_PT_MailBox is table name
_d = new Dictionary <string, object>
{
{ "NewsTypeId", model.NewsTypeId },
{ "KieuString1", model.KieuString1 },
{ "NgayDeliver", WebsiteExtension.ConvertDate(NgayDeliverConvert) },
{ "Name", model.Name },
{ "ShortContentNews", model.ShortContentNews },
{ "hinhanhImageSample", model.hinhanhImageSample },
{ "TagName", model.TagName },
{ "UpdateDate", DateTime.Now },
{ "UpdateStaffId", HttpContext.Current.Session["UserID"] },
{ "ContentNews", model.ContentNews }
},
_c = new Dictionary <string, object>
{
{ "Id", model.Id },
{ "Status", 1 }
}
};
var robj = service.P(obj); // {Result: 0 is failed, 1 is success, Records: List object array, TotalRecordCount: number of records, Message: error content }
return(robj.Result);
}
public JsonResult ReSendActiveEmail(tbl_UserAuth md)
{
string sGuid = Guid.NewGuid().ToString();
var obj = new GCRequest
{
_a = "Updatetbl_UserAuth", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "Id", md.Id },
{ "UserName", md.UserName },
{ "Active", 0 },
},
_d = new Dictionary <string, object>
{
{ "TimeZone", sGuid },
{ "CreatedDate", DateTime.Now },
}
};
var robj = service.P(obj);
if (int.Parse(robj.Records[0][0].ToString()) == 1)
{
string confirmCode = Convert.ToBase64String(Encoding.Unicode.GetBytes(String.Format("user={0}&id={1}&code={2}&date={3}", md.UserName, md.Id, sGuid, DateTime.Now)));
var urlConfirmLink = "http://cotoiday.vn/RegisterAccount/ConfirmPage?token=" + confirmCode;
var resendResult = SendConfirmMail.SendEmail(urlConfirmLink, md.Email);
if (resendResult)
{
return(Json(1));
}
}
return(Json(0));
}
public static object PostNews(tbl_News model)
{
if (model.ContentNews != null)
{
model.ContentNews.Replace('\'', '\"');
}
var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true);
var obj = new GCRequest
{
_a = "Inserttbl_News", //Action prefix f,p for get data; tbl_PT_MailBox is table name
_d = new Dictionary <string, object>
{
{ "NewsTypeId", model.NewsTypeId },
{ "KieuString1", model.KieuString1 },
{ "NgayDeliver", DateTime.Now },
{ "Name", model.Name },
{ "ShortContentNews", model.ShortContentNews },
{ "hinhanhImageSample", model.hinhanhImageSample },
{ "TagName", model.TagName },
{ "ContentNews", model.ContentNews },
{ "CreateDate", DateTime.Now },
{ "CreateStaffId", HttpContext.Current.Session["UserID"] }
}
};
var robj = service.P(obj); // {Result: 0 is failed, 1 is success, Records: List object array, TotalRecordCount: number of records, Message: error content }
return(robj.Result);
}
public JsonResult UpdateInforUser(tbl_UserAuth md)
{
var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
var obj = new GCRequest
{
_a = "Updatetbl_UserAuth", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "Id", md.Id }
},
_d = new Dictionary <string, object>
{
{ "DisplayName", md.DisplayName },
{ "BirthDate", md.BirthDate },
{ "Nationality", md.Nationality },
{ "Gender", md.Gender },
{ "CityId", md.CityId },
{ "Cmnd", md.Cmnd },
{ "MaritalStatus", md.MaritalStatus },
{ "Height", md.Height },
{ "Weight", md.Weight },
{ "Address", md.Address },
{ "Email", md.Email },
{ "PhoneNumber", md.PhoneNumber },
{ "Criminal", md.Criminal },
{ "CriminalReason", md.CriminalReason },
{ "ModifiedDate", DateTime.Now }
}
};
var robj = service.P(obj);
return(Json(robj.Result));
}
protected override bool AuthorizeCore(HttpContextBase httpContext)
{
List <string> privilegeLevels = new List <string>();
var groupId = HttpContext.Current.Session["GroupId"].ToString();
var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
var obj = new GCRequest
{
_a = "fGettbl_Admin_Group_Permission_View00", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "GroupId", groupId },
{ "Status", 1 }
},
_f = String.Join(",", typeof(tbl_Admin_Group_Permission_View00).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
var robj = service.P(obj);
if (robj.Result.Equals(1) && robj.Records.Any())
{
var result = robj.Records.ConvertToList <tbl_Admin_Group_Permission_View00>();
privilegeLevels = result.Select(c => c.PermissionIdCode.ToString()).ToList();
}
if (privilegeLevels.Contains(this.Role))
{
return(true);
}
else
{
return(false);
}
}
public JsonResult UpdateProject(tbl_User_Project md)
{
var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
var obj = new GCRequest
{
_a = "Updatetbl_User_Project", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "Id", md.Id }
},
_d = new Dictionary <string, object>
{
{ "JobId", md.JobId },
{ "Name", md.Name },
{ "Position", md.Position },
{ "Partner", md.Partner },
{ "FromDate", md.FromDate },
{ "ToDate", md.ToDate },
{ "Note", md.Note },
{ "Image", md.Image },
{ "UpdateDate", DateTime.Now }
}
};
var robj = service.P(obj);
return(Json(robj.Result));
}
public ActionResult _ProjectTabPartial(int id)
{
var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
// Get vi tri
var obj = new GCRequest
{
_a = "fGettbl_Recruitment_Post", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "UserId", id },
{ "Status", 1 }
},
_f = String.Join(",", typeof(tbl_Recruitment_Post).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
var robj = service.P(obj); // {Result: 0 is failed, 1 is success, Records: List object array, TotalRecordCount: number of records, Message: error content }
if (robj.Result.Equals(1) && robj.Records.Any())
{
var result = robj.Records.ConvertToList <tbl_Recruitment_Post>();
result = result.OrderByDescending(x => x.CreateDate).ToList();
ViewBag.Post = result;
}
return(PartialView());
}
public ActionResult AccountNotActive(string searchfield)
{
//var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
var obj = new GCRequest();
var groupId = int.Parse(Session["GroupId"].ToString());
if (groupId == 3)
{
obj = new GCRequest
{
_a = "fGettbl_UserAuth", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "UserName", string.Format("(PATINDEX(N'%{0}%', $x) > 0 OR PATINDEX(N'%{0}%', Email) > 0 OR PATINDEX(N'%{0}%', PhoneNumber) > 0)", searchfield) },
{ "TypeId", 2 },
{ "Active", 0 },
{ "StaffId", string.Format("$x > 0") }
},
_f = String.Join(",", typeof(tbl_UserAuth).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
}
else
{
obj = new GCRequest
{
_a = "fGettbl_UserAuth", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "UserName", string.Format("(PATINDEX(N'%{0}%', $x) > 0 OR PATINDEX(N'%{0}%', Email) > 0 OR PATINDEX(N'%{0}%', PhoneNumber) > 0)", searchfield) },
{ "Active", 0 },
{ "StaffId", string.Format("$x > 0") }
},
_f = String.Join(",", typeof(tbl_UserAuth).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
}
var robj = service.P(obj);
if (robj.Result.Equals(1) && robj.Records.Any())
{
var result = robj.Records.ConvertToList <tbl_UserAuth>();
result = result.OrderByDescending(x => x.CreatedDate).ToList();
ViewBag.RecordNum = robj.TotalRecordCount;
ViewBag.CurrentPage = 1;
ViewBag.TotalPage = 0;
return(View(result));
}
ViewBag.RecordNum = 0;
return(View());
}
public ActionResult Job_Sub()
{
var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
//Get Job
var obj = new GCRequest
{
_a = "fGettbl_Job", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "Status", 1 },
{ "NganhId", string.Format("$x is Null") }
},
_f = String.Join(",", typeof(tbl_Job).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
var robj = service.P(obj); // {Result: 0 is failed, 1 is success, Records: List object array, TotalRecordCount: number of records, Message: error content }
if (robj.Result.Equals(1) && robj.Records.Any())
{
var result = robj.Records.ConvertToList <tbl_Job>();
result = result.OrderBy(x => x.Name).ToList();
ViewBag.Job = result;
}
//----------------
//Get Job-sub
var objViec = new GCRequest
{
_a = "fGettbl_Job_View01", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "Status", 1 },
{ "NganhIdStatus", 1 },
{ "NganhId", string.Format("$x is NOT Null") }
},
_f = String.Join(",", typeof(tbl_Job_View01).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
var robjViec = service.P(objViec); // {Result: 0 is failed, 1 is success, Records: List object array, TotalRecordCount: number of records, Message: error content }
if (robjViec.Result.Equals(1) && robjViec.Records.Any())
{
var result = robjViec.Records.ConvertToList <tbl_Job_View01>();
result = result.OrderBy(x => x.Name).ToList();
return(View(result));
}
//--------------
return(View());
}
public JsonResult AddNganh(tbl_Job md)
{
var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
var obj = new GCRequest
{
_a = "Inserttbl_Job", //Action prefix f,p for get data; gc_App is table name
_d = new Dictionary <string, object>
{
{ "Name", md.Name },
{ "Code", md.Code }
}
};
var robj = service.P(obj); // {Result: 0 is failed, 1 is success, Records: List object array, TotalRecordCount: number of records, Message: error content }
return(Json(robj.Result));
}
public ActionResult Login(tbl_Admin_UserAuth md)
{
var error = String.Empty;
if (md.UserName != null || md.UserName != "")
{
var convertPass = WebsiteExtension.EncryptPassword(md.PasswordHash);
try
{
var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
var objCheckExist = new GCRequest
{
_a = "fGettbl_Admin_UserAuth", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "UserName", md.UserName },
{ "PasswordHash", convertPass },
{ "Status", 1 }
},
_f = "Id,TypeId,UserName,GroupTypeId"
};
var robjCheckExist = service.P(objCheckExist);
if (robjCheckExist.TotalRecordCount > 0)
{
Session["UserID"] = robjCheckExist.Records[0][0].ToString();
Session["RoleId"] = robjCheckExist.Records[0][1].ToString();
Session["UserName"] = robjCheckExist.Records[0][2].ToString();
Session["GroupId"] = robjCheckExist.Records[0][3].ToString();
Session.Timeout = 120;
return(Redirect("/"));
}
else
{
return(Redirect("/Login/Login"));
}
}
catch (Exception ex)
{
return(Redirect("/Login/Login"));
}
}
else
{
return(Redirect("/Login/Login"));
}
}
public ActionResult _ProjectTabPartial(int id)
{
var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
//Get Project
var obj = new GCRequest
{
_a = "fGettbl_User_Project_View00", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "UserId", id },
{ "Status", 1 }
},
_f = String.Join(",", typeof(tbl_User_Project_View).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
var robj = service.P(obj);
if (robj.Result.Equals(1) && robj.Records.Any())
{
var result = robj.Records.ConvertToList <tbl_User_Project_View>();
ViewBag.Project = result;
}
//---------------------------------------------
//Get Experience List
var objKinhNghiem = new GCRequest
{
_a = "fGettbl_User_Experience_View01", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "UserId", id },
{ "Status", 1 }
},
_f = String.Join(",", typeof(tbl_User_Experience_View).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
var robjKinhNghiem = service.P(objKinhNghiem);
if (robjKinhNghiem.Result.Equals(1) && robjKinhNghiem.Records.Any())
{
var result = robjKinhNghiem.Records.ConvertToList <tbl_User_Experience_View>();
return(PartialView(result));
}
//------------------------------------------------
return(PartialView());
}
public JsonResult DeleteProject(int id)
{
var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
var obj = new GCRequest
{
_a = "Updatetbl_User_Project", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "Id", id }
},
_d = new Dictionary <string, object>
{
{ "Status", 0 }
}
};
var robj = service.P(obj);
return(Json(robj.Result));
}
public JsonResult DeleteAccount(tbl_UserAuth md)
{
//var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
var obj = new GCRequest
{
_a = "Updatetbl_UserAuth", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "Id", md.Id }
},
_d = new Dictionary <string, object>
{
{ "Status", 0 }
}
};
var robj = service.P(obj); // {Result: 0 is failed, 1 is success, Records: List object array, TotalRecordCount: number of records, Message: error content }
return(Json(robj.Result));
}
public JsonResult CheckUser(tbl_UserAuth md)
{
//var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
var obj = new GCRequest
{
_a = "fGettbl_UserAuth", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "UserName", md.UserName }
},
_f = "Id"
};
var robj = service.P(obj);
if (robj.TotalRecordCount > 0)
{
return(Json(1));
}
return(Json(0));
}
public ActionResult ChangePass(tbl_Admin_UserAuth md, string OldPassWord)
{
var convertPass = WebsiteExtension.EncryptPassword(md.PasswordHash);
var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
var objCheckPass = new GCRequest
{
_a = "fGettbl_Admin_UserAuth", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "UserName", md.UserName },
{ "PasswordHash", WebsiteExtension.EncryptPassword(OldPassWord) },
{ "Status", 1 }
},
_f = "Id"
};
var robjCheckPass = service.P(objCheckPass);
if (robjCheckPass.TotalRecordCount > 0)
{
var obj = new GCRequest
{
_a = "Updatetbl_Admin_UserAuth", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "Id", md.Id }
},
_d = new Dictionary <string, object>
{
{ "PasswordHash", convertPass },
{ "ModifiedDate", DateTime.Now }
}
};
var robj = service.P(obj);
if (robj.Result == 1)
{
return(Redirect("/Login/Login"));
}
}
return(View());
}
public JsonResult DeleteRecruitPost(tbl_Recruitment_Post md)
{
var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
var obj = new GCRequest
{
_a = "Updatetbl_Recruitment_Post", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "Id", md.Id }
},
_d = new Dictionary <string, object>
{
{ "Status", 0 },
{ "StaffIdUpdate", md.StaffIdUpdate },
{ "UpdateDate", DateTime.Now }
}
};
var robj = service.P(obj);
return(Json(robj.Result));
}
public static object DeleteNews(int id)
{
var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true);
var obj = new GCRequest
{
_a = "Updatetbl_News", //Action prefix f,p for get data; tbl_PT_MailBox is table name
_d = new Dictionary <string, object>
{
{ "Status", 0 },
{ "UpdateStaffId", HttpContext.Current.Session["UserID"] },
{ "UpdateDate", DateTime.Now }
},
_c = new Dictionary <string, object>
{
{ "Id", id }
}
};
var robj = service.P(obj); // {Result: 0 is failed, 1 is success, Records: List object array, TotalRecordCount: number of records, Message: error content }
return(robj.Result);
}
public static List <tbl_News> GetNews()
{
var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true);
var obj = new GCRequest
{
_a = "fGettbl_News", //Action prefix f,p for get data; tbl_PT_MailBox is table name
_c = new Dictionary <string, object>
{
{ "Status", 1 }
},
_f = String.Join(",", typeof(tbl_News).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
var robj = service.P(obj); // {Result: 0 is failed, 1 is success, Records: List object array, TotalRecordCount: number of records, Message: error content }
if (robj.Result.Equals(1) && robj.Records.Any())
{
var result = robj.Records.ConvertToList <tbl_News>();
return(result);
}
return(null);
}
public ActionResult Employer_Info(int id)
{
//Get ky nang
var objSkill = new GCRequest
{
_a = "fGettbl_Recruitment_Post", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "UserId", id },
{ "Status", 1 }
},
_f = String.Join(",", typeof(tbl_Recruitment_Post).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
var robjSkill = service.P(objSkill);
if (robjSkill.Result.Equals(1) && robjSkill.Records.Any())
{
var result = robjSkill.Records.ConvertToList <tbl_Recruitment_Post>();
ViewBag.RecruitmentPost = result;
}
// Get thong tin
var obj = new GCRequest
{
_a = "fGettbl_UserAuth_View00", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "Id", id }
},
_f = String.Join(",", typeof(tbl_UserAuth_View00).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
var robj = service.P(obj);
if (robj.Result.Equals(1) && robj.Records.Any())
{
var result = robj.Records.ConvertToList <tbl_UserAuth_View00>();
return(View(result));
}
return(View());
}
public ActionResult JobPost_Edit(tbl_Recruitment_Post md)
{
var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
var obj = new GCRequest
{
_a = "Updatetbl_Recruitment_Post", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "Id", md.Id }
},
_d = new Dictionary <string, object>
{
{ "TypeId", md.TypeId },
{ "TypeIdName", md.TypeIdName },
{ "Title", md.Title },
{ "PositionId", md.PositionId },
{ "Job", md.Job },
{ "JobName", md.JobName },
{ "Location", md.Location },
{ "LocationName", md.LocationName },
{ "Wage", md.Wage },
{ "TrialTime", md.TrialTime },
{ "Num", md.Num },
{ "Experience", md.Experience },
{ "Diploma", md.Diploma },
{ "Gender", md.Gender },
{ "Age", md.Age },
{ "Describe", md.Describe },
{ "Interest", md.Interest },
{ "Other", md.Other },
{ "Folder", md.Folder },
{ "EndDate", md.EndDate },
{ "StaffIdUpdate", md.StaffIdUpdate },
{ "UpdateDate", DateTime.Now }
}
};
var robj = service.P(obj);
return(View(robj.Result));
}
public JsonResult GetCongViecByNganhId(int nganhId)
{
//var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
var obj = new GCRequest
{
_a = "fGettbl_Job", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "NganhId", nganhId },
{ "Status", 1 }
},
_f = String.Join(",", typeof(tbl_Job).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
var robj = service.P(obj);
if (robj.Result.Equals(1) && robj.Records.Any())
{
var result = robj.Records.ConvertToList <tbl_Job>();
return(Json(result));
}
return(Json(0));
}
public ActionResult CreateAccount(tbl_UserAuth md)
{
var convertPass = WebsiteExtension.EncryptPassword(md.PasswordHash);
//var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
var obj = new GCRequest
{
_a = "Inserttbl_UserAuth", //Action prefix f,p for get data; gc_App is table name
_d = new Dictionary <string, object>
{
{ "TypeId", md.TypeId },
{ "UserName", md.UserName.ToLower() },
{ "PasswordHash", convertPass },
{ "StaffId", md.StaffId },
{ "Status", 1 },
{ "CreatedDate", DateTime.Now }
}
};
var robj = service.P(obj); // {Result: 0 is failed, 1 is success, Records: List object array, TotalRecordCount: number of records, Message: error content }
ViewBag.result = robj.Result;
ViewBag.type = md.TypeId;
return(View(robj.Records[0][0]));
}
public ActionResult Account(int page = 1)
{
ViewBag.RecordNum = null;
//var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
var obj = new GCRequest();
var staffId = int.Parse(Session["UserId"].ToString());
if (staffId == 3 || staffId == 4)
{
obj = new GCRequest
{
_a = "pGettbl_UserAuth", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "TypeId", 2 },
{ "Status", 1 },
{ "StaffId", string.Format("$x > 0") }
},
_od = new Dictionary <string, string>()
{
{ "CreatedDate", "DESC" }
},
_os = (page - 1) * 10,
_lm = 10,
_f = String.Join(",", typeof(tbl_UserAuth).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
}
else
{
obj = new GCRequest
{
_a = "pGettbl_UserAuth", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "Status", 1 },
{ "StaffId", string.Format("$x > 0") }
},
_od = new Dictionary <string, string>()
{
{ "CreatedDate", "DESC" }
},
_os = (page - 1) * 10,
_lm = 10,
_f = String.Join(",", typeof(tbl_UserAuth).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
}
var robj = service.P(obj);
if (robj.Result.Equals(1) && robj.Records.Any())
{
var result = robj.Records.ConvertToList <tbl_UserAuth>();
result = result.OrderByDescending(x => x.CreatedDate).ToList();
var totalPage = Convert.ToInt32(Math.Ceiling((double)robj.TotalRecordCount / 10));
ViewBag.CurrentPage = page;
ViewBag.TotalPage = totalPage;
return(View(result));
}
return(View());
}
public ActionResult Seeker_Info(int id)
{
var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
//Get ky nang
var objSkill = new GCRequest
{
_a = "fGettbl_User_Experience_View01", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "UserId", id },
{ "Status", 1 }
},
_f = String.Join(",", typeof(tbl_User_Experience_View).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
var robjSkill = service.P(objSkill);
if (robjSkill.Result.Equals(1) && robjSkill.Records.Any())
{
var result = robjSkill.Records.ConvertToList <tbl_User_Experience_View>();
ViewBag.Skill = result;
}
// Get kinh nghiem
var objExp = new GCRequest
{
_a = "fGettbl_User_Project_View00", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "UserId", id },
{ "Status", 1 }
},
_f = String.Join(",", typeof(tbl_User_Project_View).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
var robjExp = service.P(objExp);
if (robjExp.Result.Equals(1) && robjExp.Records.Any())
{
var result = robjExp.Records.ConvertToList <tbl_User_Project_View>();
ViewBag.Exp = result;
}
// Get thong tin
var obj = new GCRequest
{
_a = "fGettbl_UserAuth_View00", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "Id", id }
},
_f = String.Join(",", typeof(tbl_UserAuth_View00).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
var robj = service.P(obj);
if (robj.Result.Equals(1) && robj.Records.Any())
{
var result = robj.Records.ConvertToList <tbl_UserAuth_View00>();
return(View(result));
}
return(View());
}
public ActionResult CreateNewJob(int?id)
{
if (!id.HasValue)
{
return(Redirect("/"));
}
var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
// Get vi tri
var objPosition = new GCRequest
{
_a = "fGettbl_Position", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "Status", 1 }
},
_f = String.Join(",", typeof(tbl_Position).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
var robjPosition = service.P(objPosition); // {Result: 0 is failed, 1 is success, Records: List object array, TotalRecordCount: number of records, Message: error content }
if (robjPosition.Result.Equals(1) && robjPosition.Records.Any())
{
var result = robjPosition.Records.ConvertToList <tbl_Position>();
result = result.OrderBy(x => x.Name).ToList();
ViewBag.Position = result;
}
//Get Job
var objJob = new GCRequest
{
_a = "fGettbl_Job", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "Status", 1 },
{ "NganhId", string.Format("$x is Null") }
},
_f = String.Join(",", typeof(tbl_Job).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
var robjJob = service.P(objJob); // {Result: 0 is failed, 1 is success, Records: List object array, TotalRecordCount: number of records, Message: error content }
if (robjJob.Result.Equals(1) && robjJob.Records.Any())
{
var result = robjJob.Records.ConvertToList <tbl_Job>();
result = result.OrderBy(x => x.Name).ToList();
ViewBag.Job = result;
}
//Get Province List
var objProvince = new GCRequest
{
_a = "fGettbl_Provinces", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "InUse", 1 }
},
_f = String.Join(",", typeof(tbl_Provinces).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
var robjProvince = service.P(objProvince);
if (robjProvince.Result.Equals(1) && robjProvince.Records.Any())
{
var result = robjProvince.Records.ConvertToList <tbl_Provinces>();
ViewBag.Province = result;
}
return(View(2));
}
public ActionResult Index()
{
var fromDate = DateTime.Today.AddDays(-5);
var toDate = DateTime.Today;
DateTime dateNow = DateTime.Now;
var obj = new GCRequest
{
_a = "fGettbl_UserAuth", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "Status", 1 }
},
_f = String.Join(",", typeof(tbl_UserAuth).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
var robj = service.P(obj);
var objSoluongNhaplieu = new GCRequest
{
_a = "fGettbl_UserAuth_SummaryByDay_View", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "CreatedDate", string.Format("$x >= '{0:yyyy-MM-dd}'", dateNow.AddDays(-5)) }
},
_f = String.Join(",", typeof(tbl_UserAuth_SummaryByDay_View).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
var robjSoluongNhaplieu = service.P(objSoluongNhaplieu);
if (robjSoluongNhaplieu.Result.Equals(1) && robjSoluongNhaplieu.Records.Any())
{
var result = robjSoluongNhaplieu.Records.ConvertToList <tbl_UserAuth_SummaryByDay_View>();
ViewBag.DayList = result.Select(x => x.CreatedDate.ToString("dd/MM/yyyy")).Distinct().ToArray();
//Get data by dict
//var dict = new Dictionary<int, List<int>>();
var dict = new Dictionary <int, Dictionary <DateTime, int> >();
foreach (var item in result)
{
var staffID = item.StaffId;
if (!dict.ContainsKey(staffID))
{
var d = new Dictionary <DateTime, int>();
for (var i = 0; i < (toDate - fromDate).TotalDays; i++)
{
d.Add(fromDate.AddDays(i), 0);
}
dict.Add(staffID, d);
}
dict[staffID][item.CreatedDate] = item.Total;
}
ViewBag.array = dict;
//Get data by Json
//var users = result.Select(c => c.CreatedDate).Distinct().ToList();
//var data = new CreatingUserChartDto();
//foreach(var item in result.GroupBy(c => c.StaffId).OrderBy(c => c.Key)){
// var serier = new List<int>();
// foreach (var user in users)
// {
// data.Labels.Add(user.ToString("dd/MM/yyyy"));
// var totalOfUser = item.FirstOrDefault(c => c.CreatedDate == user);
// if(totalOfUser != null)
// {
// serier.Add(totalOfUser.Total);
// }
// else
// {
// serier.Add(0);
// }
// }
// data.Seriers.Add(serier);
//}
//ViewBag.Chart = JsonConvert.SerializeObject(data);
//var t = result.
//var t = result.OrderBy(c => c.TypeId).ThenBy(c => c.CreatedDate)
// .GroupBy(c => c.TypeId).Select(g => new Dictionary<int, List<int>>()
// {
// g.Key,
// g.GroupBy(h => h.CreatedDate).Count()
// })
// .Select(c => c.Select(d => d)).ToList();
//List<List<int>> array = new List<List<int>>();
//foreach (var item in result)
//{
//}
}
return(View(robj.TotalRecordCount));
}
public JsonResult AddKinhNghiem(tbl_User_Experience md)
{
var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
// Check kinh nghiem
var objCheck = new GCRequest
{
_a = "fGettbl_User_Experience", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "UserId", md.UserId },
{ "NganhId", md.NganhId },
{ "KieuString1", md.KieuString1 }
//{ "LoaiViecId",md.LoaiViecId}
},
_f = String.Join(",", typeof(tbl_User_Experience).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
var robjCheck = service.P(objCheck);
//-----------------------------------------------------
// If exist : Update
if (robjCheck.TotalRecordCount > 0)
{
var obj = new GCRequest
{
_a = "Updatetbl_User_Experience", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "UserId", md.UserId },
{ "NganhId", md.NganhId },
{ "KieuString1", md.KieuString1 }
//{ "LoaiViecId",md.LoaiViecId}
},
_d = new Dictionary <string, object>
{
{ "NumOfYear", md.NumOfYear },
{ "Status", 1 },
{ "UpdateDate", DateTime.Now }
}
};
var robj = service.P(obj);
return(Json(robj.Result));
}
// If null : Insert
else
{
var obj = new GCRequest
{
_a = "Inserttbl_User_Experience", //Action prefix f,p for get data; gc_App is table name
_d = new Dictionary <string, object>
{
{ "UserId", md.UserId },
{ "NganhId", md.NganhId },
{ "KieuString1", md.KieuString1 },
//{ "LoaiViecId",md.LoaiViecId},
{ "NumOfYear", md.NumOfYear },
{ "CreateDate", DateTime.Now }
}
};
var robj = service.P(obj);
return(Json(robj.Result));
}
//----------------------------------------------
}
public JsonResult GetNumAccCreatedIn5Days()
{
DateTime dateNow = DateTime.Now;
var fromDate = DateTime.Today.AddDays(-10);
var toDate = DateTime.Today;
var objSoluongNhaplieu = new GCRequest
{
_a = "fGettbl_UserAuth_SummaryByDay_View", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "TypeId", 2 },
{ "CreatedDate", string.Format("$x >= '{0:yyyy-MM-dd}'", dateNow.AddDays(-10)) }
},
_f = String.Join(",", typeof(tbl_UserAuth_SummaryByDay_View).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
var robjSoluongNhaplieu = service.P(objSoluongNhaplieu);
if (robjSoluongNhaplieu.Result.Equals(1) && robjSoluongNhaplieu.Records.Any())
{
var result = robjSoluongNhaplieu.Records.ConvertToList <tbl_UserAuth_SummaryByDay_View>();
ViewBag.DayList = result.Select(x => x.CreatedDate.ToString("dd/MM/yyyy")).Distinct().ToArray();
//Get data by dict
var dict = new Dictionary <int, Dictionary <DateTime, int> >();
foreach (var item in result)
{
var staffID = item.StaffId;
if (!dict.ContainsKey(staffID))
{
var d = new Dictionary <DateTime, int>();
for (var i = 0; i < (toDate - fromDate).TotalDays; i++)
{
d.Add(fromDate.AddDays(i), 0);
}
dict.Add(staffID, d);
}
dict[staffID][item.CreatedDate] = item.Total;
}
var content = JsonConvert.SerializeObject(dict.Select(c => c.Value.Select(e => e.Value).ToList()).ToList());
List <string> dateList = new List <string>();
List <List <int> > seriers = new List <List <int> >();
foreach (var item in dict)
{
var serier = new List <int>();
foreach (var d in item.Value)
{
serier.Add(d.Value);
}
seriers.Add(serier);
}
foreach (var item in dict.Take(1))
{
foreach (var d in item.Value)
{
dateList.Add(d.Key.Date.ToString("dd/MM/yyyy"));
}
}
return(Json(new { datelist = dateList, seriers = seriers, content = content }));
//Get data by Json
//var users = result.Select(c => c.CreatedDate).Distinct().ToList();
//var data = new CreatingUserChartDto();
//foreach (var item in result.GroupBy(c => c.StaffId).OrderBy(c => c.Key))
//{
// var serier = new List<int>();
// foreach (var user in users)
// {
// data.Labels.Add(user.ToString("dd/MM/yyyy"));
// var totalOfUser = item.FirstOrDefault(c => c.CreatedDate == user);
// if (totalOfUser != null)
// {
// serier.Add(totalOfUser.Total);
// }
// else
// {
// serier.Add(0);
// }
// }
// data.Seriers.Add(serier);
//}
//return Json(JsonConvert.SerializeObject(data));
}
return(null);
}
public ActionResult Account_Detail(int?id)
{
var staffId = int.Parse(Session["UserId"].ToString());
if (!id.HasValue)
{
return(Redirect("/"));
}
//var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
//Get account
var objType = new GCRequest
{
_a = "fGettbl_UserAuth", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "Id", id },
{ "Status", 1 }
},
_f = "TypeId"
};
var robjType = service.P(objType);
if (int.Parse(robjType.Records[0][0].ToString()) == 1)
{
return(Redirect("/"));
}
//Get Experience List
var objKinhNghiem = new GCRequest
{
_a = "fGettbl_User_Experience_View01", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "UserId", id },
{ "Status", 1 }
},
_f = String.Join(",", typeof(tbl_User_Experience_View).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
var robjKinhNghiem = service.P(objKinhNghiem);
if (robjKinhNghiem.Result.Equals(1) && robjKinhNghiem.Records.Any())
{
var result = robjKinhNghiem.Records.ConvertToList <tbl_User_Experience_View>();
ViewBag.KinhNghiemList = result;
}
//------------------------------------------------
//Get Job List
var obj = new GCRequest
{
_a = "fGettbl_Job", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "NganhId", string.Format("$x is Null") },
{ "Status", 1 }
},
_f = String.Join(",", typeof(tbl_Job).GetProperties(BindingFlags.Instance | BindingFlags.Public).Select(c => c.Name))
};
var robj = service.P(obj);
if (robj.Result.Equals(1) && robj.Records.Any())
{
var result = robj.Records.ConvertToList <tbl_Job>();
return(View(result));
}
//-----------------------------------
return(View());
}
