/// <summary>
/// 用户的登录处理
/// </summary>
/// <param name="user"></param>
/// <param name="expriseTime"></param>
public void loginUser(users user, DateTime expriseTime)
{
HttpCookie cookie = new HttpCookie("curuser", user.id.ToString());
cookie.Expires = expriseTime;
HttpContext.Current.Request.Cookies.Add(cookie);
}
// PUT api/Users/5
public HttpResponseMessage Putusers(int id, users users)
{
if (!ModelState.IsValid)
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
if (id != users.id)
{
return Request.CreateResponse(HttpStatusCode.BadRequest);
}
db.Entry(users).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
return Request.CreateErrorResponse(HttpStatusCode.NotFound, ex);
}
return Request.CreateResponse(HttpStatusCode.OK);
}
public static bool check(string login, string key, permissao p)
{
users _u = new users();
_u.user = login.ToLower().Trim();
_u.key = key;
if (!_usersDB.Any<users>(item => item.user == _u.user && item.key == _u.key))
{
Remove(_u.user);
Load(_u);
}
return Verify(_u.user, p);
}
private async void Button_Click(object sender, RoutedEventArgs e)
{
pr.IsActive = true;
if (displayname.Text == "" || userid.Text == "" || password.Password == "")
{
msg.Visibility = Visibility.Visible;
pr.IsActive = false;
}
else
{
users newuser = new users { id = Guid.NewGuid().ToString(), userid = userid.Text, password = password.Password, displayname = displayname.Text };
await App.MobileService.GetTable<users>().InsertAsync(newuser);
pr.IsActive = false;
Frame.Navigate(typeof(Feed), newuser.userid);
}
}
// POST api/Users
public HttpResponseMessage Postusers(users users)
{
if (ModelState.IsValid)
{
db.users.Add(users);
db.SaveChanges();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, users);
response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = users.id }));
return response;
}
else
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
}
//ADD
public static bool AddUser(users user)
{
Context.users.Add(user);
try
{
Context.SaveChanges();
}
catch (DbUpdateException dbEx)
{
return false;
}
catch (DbEntityValidationException ex)
{
foreach (DbEntityValidationResult item in ex.EntityValidationErrors)
{
// Get entry
DbEntityEntry entry = item.Entry;
string entityTypeName = entry.Entity.GetType().Name;
// Display or log error messages
foreach (DbValidationError subItem in item.ValidationErrors)
{
string message = string.Format("Error '{0}' occurred in {1} at {2}",
subItem.ErrorMessage, entityTypeName, subItem.PropertyName);
Console.WriteLine(message);
}
// Rollback changes
switch (entry.State)
{
case EntityState.Added:
entry.State = EntityState.Detached;
break;
case EntityState.Modified:
entry.CurrentValues.SetValues(entry.OriginalValues);
entry.State = EntityState.Unchanged;
break;
case EntityState.Deleted:
entry.State = EntityState.Unchanged;
break;
}
}
return false;
}
Context.Entry(user).Reload();
return true;
}
public HandlerResponse Regit(string userName, string pwd, string repwd)
{
if (repwd != pwd)
return CreateHandler(0, "两次密码输入不一致");
users model = new users();
model.createtime = DateTime.Now;
model.password = pwd;
model.username = userName;
users model1 = UsersRepository.Instance.getModel(userName, "");
if (UsersRepository.Instance.Add(model) > 0)
{
AppConent.Current.loginUser(model, DateTime.Now.AddMonths(1));
return CreateHandler(1, "注册成功");
}
else
return CreateHandler(0, "注册失败");
}
/// <summary>
/// Añado un usuario en la base de datos
/// </summary>
/// <param name="name"></param>
/// <param name="password"></param>
/// <returns>True = Se ha insertado el usuario, de lo contrario False</returns>
public bool AddUser(string name, string password)
{
bool status = false;
using (EntityFrameworkEntities context = new EntityFrameworkEntities())
{
users user = new users
{
user = name,
password = password
};
context.users.Add(user);
status = SaveChanges(context);
}
return status;
}
//public ActionResult register(int id)
//{
// users u = Session["userClass"] as users;//从登录进来的session里面获取uname
// Session["uname"]=u.u_name;
// //string u_name = u.u_name;
// List<major_change> list = major.SelectWhere(e => e.mch_id == id);//根据id查询
// major_change maj = new major_change()
// {
// mch_id = list[0].mch_id,
// human_name = list[0].human_name, //姓名
// first_kind_id = list[0].first_kind_id,//一级编号
// first_kind_name = list[0].first_kind_name,//一级结构名称
// second_kind_id = list[0].second_kind_id,//二级编号
// second_kind_name = list[0].second_kind_name,//二级名字
// third_kind_id = list[0].third_kind_id,//三级编号
// third_kind_name = list[0].third_kind_name,//三级机构名称
// major_kind_id = list[0].major_kind_id,//职位分类编号
// major_kind_name = list[0].major_kind_name,//职位分类名称
// major_id = list[0].major_id,//职位编号
// major_name = list[0].major_name,//职位名称
// new_first_kind_id = list[0].new_first_kind_id,//新一级机构编号
// new_first_kind_name = list[0].new_first_kind_name,//新一级机构名称
// new_second_kind_id = list[0].new_second_kind_id,//新二级机构编号
// new_second_kind_name = list[0].new_second_kind_name,//新二级机构名称
// new_third_kind_id = list[0].new_third_kind_id,//新三级机构编号
// new_third_kind_name = list[0].new_third_kind_name,//新三级机构名称
// new_major_kind_id = list[0].new_major_kind_id,//新职位分类编号
// new_major_kind_name = list[0].new_major_kind_name,//新职位分类名称
// new_major_id = list[0].new_major_id,//新职位编号
// new_major_name = list[0].new_major_name,//新职位名称
// human_id = list[0].human_id,//人力资源档案编号
// salary_standard_id = list[0].salary_standard_id,//薪酬标准编号
// salary_standard_name = list[0].salary_standard_name,//薪酬标准名称
// salary_sum = list[0].salary_sum,//薪酬总额
// new_salary_standard_id = list[0].new_salary_standard_id,//新薪酬标准编号
// new_salary_standard_name = list[0].new_salary_standard_name,//新薪酬标准名称
// new_salary_sum = list[0].new_salary_sum,//新薪酬总额
// change_reason = list[0].change_reason,//调动原因
// check_reason = list[0].check_reason,//审核通过意见
// check_status = list[0].check_status,//复核通过状态
// register = list[0].register,//登记人
// checker = list[0].checker,//复核人
// regist_time = list[0].regist_time,//登记时间
// check_time = list[0].check_time,//复核时间
// };
// return View(maj);
//}
#endregion
public ActionResult register(int id)
{
users u = Session["userClass"] as users;//从登录进来的session里面获取uname
Session["uname"] = u.u_name;
List <human_file> list = hum.SelectWhere(e => e.huf_id == id);//根据id查询
human_file h = new human_file()
{
huf_id = list[0].huf_id,
human_id = list[0].human_id,
first_kind_id = list[0].first_kind_id,
first_kind_name = list[0].first_kind_name,
second_kind_id = list[0].second_kind_id,
second_kind_name = list[0].second_kind_name,
third_kind_id = list[0].third_kind_id,
third_kind_name = list[0].third_kind_name,
human_name = list[0].human_name,
human_address = list[0].human_address,
human_postcode = list[0].human_postcode,
human_pro_designation = list[0].human_pro_designation,
human_major_kind_id = list[0].human_major_kind_id,
human_major_kind_name = list[0].human_major_kind_name,
human_major_id = list[0].human_major_id,
hunma_major_name = list[0].hunma_major_name,
human_telephone = list[0].human_telephone,
human_mobilephone = list[0].human_mobilephone,
human_bank = list[0].human_bank,
human_account = list[0].human_account,
human_qq = list[0].human_qq,
human_email = list[0].human_email,
human_hobby = list[0].human_hobby,
human_speciality = list[0].human_speciality,
human_sex = list[0].human_sex,
human_religion = list[0].human_religion,
human_party = list[0].human_party,
human_nationality = list[0].human_nationality,
human_race = list[0].human_race,
human_birthday = list[0].human_birthday,
human_birthplace = list[0].human_birthplace,
human_age = list[0].human_age,
human_educated_degree = list[0].human_educated_degree,
human_educated_years = list[0].human_educated_years,
human_educated_major = list[0].human_educated_major,
human_society_security_id = list[0].human_society_security_id,
human_id_card = list[0].human_id_card,
remark = list[0].remark,
salary_standard_id = list[0].salary_standard_id,
salary_standard_name = list[0].salary_standard_name,
salary_sum = list[0].salary_sum,
demand_salaray_sum = list[0].demand_salaray_sum,
paid_salary_sum = list[0].paid_salary_sum,
major_change_amount = list[0].major_change_amount,
bonus_amount = list[0].bonus_amount,
training_amount = list[0].training_amount,
file_chang_amount = list[0].file_chang_amount,
human_histroy_records = list[0].human_histroy_records,
human_family_membership = list[0].human_family_membership,
human_picture = list[0].human_picture,
attachment_name = list[0].attachment_name,
check_status = list[0].check_status,
register = list[0].register,
checker = list[0].checker,
changer = list[0].changer,
regist_time = list[0].regist_time,
check_time = list[0].check_time,
change_time = list[0].change_time,
lastly_change_time = list[0].lastly_change_time,
delete_time = list[0].delete_time,
recovery_time = list[0].recovery_time,
human_file_status = list[0].human_file_status
};
return(View(h));
}
public static List<community_permissions> GetAllCommunityPermissionsByUserAndRole(users user, string role)
{
return GetAllNotDeletedCommunityPermissions().Where(p => p.users_Id.Equals(user.Id) && p.Role.Equals(role)).ToList();
}
protected void Page_Load(object sender, EventArgs e)
{
//if (!Page.IsPostBack)
//{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
if (ck != null)
{
String strPJid = ck.pj_id;
StringBuilder strSQL = new StringBuilder();
strSQL.Append("select d.d_code, d.d_name, m.mi_code, m.mi_name, p.pj_code, p.d_id, p.pj_name, y.yut_name, p.pj_year, p.pj_budget, pj_integrateProject, pj_relateDept, pj_background, pj_urgency, pj_risk_info, pj_risk_reduction1, pj_risk_reduction2, pj_risk_eval1, pj_risk_eval2, pj_risk_eval3");
strSQL.Append(" from projects p, department d, ministry m, yutasad y");
strSQL.Append(" where p.d_id = d.d_id and p.mi_id = m.mi_id and p.pj_yut_id = y.yut_id and p.pj_id = '" + strPJid + "'");
SqlDataSource4.SelectCommand = strSQL.ToString();
SqlDataSource4.DataBind();
DataView dv1 = (DataView)SqlDataSource4.Select(DataSourceSelectArguments.Empty);
foreach (DataRow dRow in dv1.Table.Rows)
{
lblDeptCode.Text = dRow["mi_code"].ToString();
lblDeptName.Text = dRow["mi_name"].ToString();
lblDivisionCode.Text = dRow["d_code"].ToString();
lblDivisionName.Text = dRow["d_name"].ToString();
lblProjectName.Text = dRow["pj_name"].ToString();
lblProjectCode.Text = dRow["pj_code"].ToString();
lblYutasard.Text = dRow["yut_name"].ToString();
//lblIntegrateProject.Text = dRow["pj_integrateProject"].ToString();
//lblRelateDept.Text = dRow["pj_relateDept"].ToString();
lblBudget.Text = dRow["pj_budget"].ToString();
lblYear.Text = dRow["pj_year"].ToString();
if (dRow["pj_background"].ToString() != string.Empty ||
dRow["pj_urgency"].ToString() != string.Empty)
{
txtBackground.Text = dRow["pj_background"].ToString();
txtUrgency.Text = dRow["pj_urgency"].ToString();
//txtRiskInfo.Text = dRow["pj_risk_info"].ToString();
//txtRiskReduction1.Text = dRow["pj_risk_reduction1"].ToString();
//txtRiskReduction2.Text = dRow["pj_risk_reduction2"].ToString();
//txtRiskEval1.Text = dRow["pj_risk_eval1"].ToString();
//txtRiskEval2.Text = dRow["pj_risk_eval2"].ToString();
//txtRiskEval3.Text = dRow["pj_risk_eval3"].ToString();
txtBackground.Enabled = false;
txtUrgency.Enabled = false;
//txtRiskInfo.Enabled = false;
//txtRiskReduction1.Enabled = false;
//txtRiskReduction2.Enabled = false;
//txtRiskEval1.Enabled = false;
//txtRiskEval2.Enabled = false;
//txtRiskEval3.Enabled = false;
}
else
{
txtBackground.Enabled = true;
txtUrgency.Enabled = true;
//txtRiskInfo.Enabled = true;
//txtRiskReduction1.Enabled = true;
//txtRiskReduction2.Enabled = true;
//txtRiskEval1.Enabled = true;
//txtRiskEval2.Enabled = true;
//txtRiskEval3.Enabled = true;
}
}
}
else
{
//redirect to login page
}
//}
}
protected void Page_Load(object sender, EventArgs e)
{
#region loadData
qset.qset_id = "2";
qset.loadQuestionSet();
qset.loadQuestionL1();
lbl_qset_text.Text = qset.qset_text;
for (int q1_i = 0; q1_i < qset.qL1_list.Count; q1_i++)
{
question q1 = qset.qL1_list[q1_i];
q1.loadQuestionL2();
for (int q2_i = 0; q2_i < q1.qL2_list.Count; q2_i++)
{
questionL2 q2 = q1.qL2_list[q2_i];
q2.loadQuestionL3();
}
}
#endregion
#region MapQuestion to Interface
//--------------ประเด็น3---------------------------
lblQuestion_1.Text = qset.qL1_list[0].q1_text;
lblAssumption_1.Text = qset.qL1_list[0].q1_assumption;
lblQuestion_id_1.Text = qset.qL1_list[0].q1_id;
lblQuestion_id_praden_1.Text = lblQuestion_id_1.Text;
//---------------คำถาม----------------------------
lblQuestion2_1.Text = Q2Seq + qset.qL1_list[0].qL2_list[0].q2_order + " " + qset.qL1_list[0].qL2_list[0].q2_text;
//--------------คำถามย่อย--------------------------------
lblQuestion3_1_1.Text = qset.qL1_list[0].qL2_list[0].qL3_list[0].q3_order + " " + qset.qL1_list[0].qL2_list[0].qL3_list[0].q3_text;
lblQuestion3_1_2.Text = qset.qL1_list[0].qL2_list[0].qL3_list[1].q3_order + " " + qset.qL1_list[0].qL2_list[0].qL3_list[1].q3_text;
lblQuestion3_1_3.Text = qset.qL1_list[0].qL2_list[0].qL3_list[2].q3_order + " " + qset.qL1_list[0].qL2_list[0].qL3_list[2].q3_text;
//---------------คำถาม----------------------------
lblQuestion2_2.Text = Q2Seq + qset.qL1_list[0].qL2_list[1].q2_order + " " + qset.qL1_list[0].qL2_list[1].q2_text;
//--------------คำถามย่อย--------------------------------
lblQuestion3_2_1.Text = qset.qL1_list[0].qL2_list[1].qL3_list[0].q3_order + " " + qset.qL1_list[0].qL2_list[1].qL3_list[0].q3_text;
//---------------คำถาม----------------------------
lblQuestion2_3.Text = Q2Seq + qset.qL1_list[0].qL2_list[2].q2_order + " " + qset.qL1_list[0].qL2_list[2].q2_text;
//--------------คำถามย่อย--------------------------------
lblQuestion3_3_1.Text = qset.qL1_list[0].qL2_list[2].qL3_list[0].q3_order + " " + qset.qL1_list[0].qL2_list[2].qL3_list[0].q3_text;
//---------------คำถาม----------------------------
lblQuestion2_4.Text = Q2Seq + qset.qL1_list[0].qL2_list[3].q2_order + " " + qset.qL1_list[0].qL2_list[3].q2_text;
//--------------คำถามย่อย--------------------------------
lblQuestion3_4_1.Text = qset.qL1_list[0].qL2_list[3].qL3_list[0].q3_order + " " + qset.qL1_list[0].qL2_list[3].qL3_list[0].q3_text;
lblQuestion3_4_2.Text = qset.qL1_list[0].qL2_list[3].qL3_list[1].q3_order + " " + qset.qL1_list[0].qL2_list[3].qL3_list[1].q3_text;
lblQuestion3_4_3.Text = qset.qL1_list[0].qL2_list[3].qL3_list[2].q3_order + " " + qset.qL1_list[0].qL2_list[3].qL3_list[2].q3_text;
lblQuestion3_4_4.Text = qset.qL1_list[0].qL2_list[3].qL3_list[3].q3_order + " " + qset.qL1_list[0].qL2_list[3].qL3_list[3].q3_text;
//-----------จบ ประเด็น3--------------------------------
//--------------ประเด็น4---------------------------
lblQuestion_2.Text = qset.qL1_list[1].q1_text;
lblAssumption_2.Text = qset.qL1_list[1].q1_assumption;
lblQuestion_id_2.Text = qset.qL1_list[1].q1_id;
lblQuestion_id_praden_2.Text = lblQuestion_id_2.Text;
lblQuestion2_5_1.Text = Q2Seq + qset.qL1_list[1].qL2_list[0].q2_order + " " + qset.qL1_list[1].qL2_list[0].q2_text;
lblQuestion3_4_1_1.Text = qset.qL1_list[1].qL2_list[0].qL3_list[0].q3_order + " " + qset.qL1_list[1].qL2_list[0].qL3_list[0].q3_text;
//-----------จบ ประเด็น4--------------------------------
//--------------ประเด็น5---------------------------
lblQuestion_3.Text = qset.qL1_list[2].q1_text;
lblAssumption_3.Text = qset.qL1_list[2].q1_assumption;
lblQuestion_id_3.Text = qset.qL1_list[2].q1_id;
lblQuestion_id_praden_3.Text = lblQuestion_id_3.Text;
lblQuestion2_6_1.Text = Q2Seq + qset.qL1_list[2].qL2_list[0].q2_order + " " + qset.qL1_list[2].qL2_list[0].q2_text;
lblQuestion3_5_1_1.Text = qset.qL1_list[2].qL2_list[0].qL3_list[0].q3_order + " " + qset.qL1_list[2].qL2_list[0].qL3_list[0].q3_text;
lblQuestion3_5_1_2.Text = qset.qL1_list[2].qL2_list[0].qL3_list[1].q3_order + " " + qset.qL1_list[2].qL2_list[0].qL3_list[1].q3_text;
//-----------จบ ประเด็น5--------------------------------
#endregion
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
string max = "";
if (ck != null)
{
mgCookie.UpdateCookies("qset_id", qset.qset_id); //คำถามชุด ข.
answer ans = new answer();
max = ans.getLatestAnswerQ2(ck.pj_id, ans.getLatestAnswerQSetID(ck.pj_id));
//if (pnlQL1_3.Visible == true)
//{
// //ประเด็น 3
// mgCookie.UpdateCookies("q1_id", qset.qL1_list[0].q1_id);
// mgCookie.UpdateCookies("q2_id", qset.qL1_list[0].qL2_list[0].q2_id);
//}
//else if (pnlQL1_4.Visible == true)
//{
// //ประเด็นที่ 4
// mgCookie.UpdateCookies("q1_id", qset.qL1_list[1].q1_id);
// mgCookie.UpdateCookies("q2_id", qset.qL1_list[1].qL2_list[0].q2_id);
//}
//else if (pnlQL1_5.Visible == true)
//{
// //ประเด็นที่ 5
// mgCookie.UpdateCookies("q1_id", qset.qL1_list[2].q1_id);
// mgCookie.UpdateCookies("q2_id", qset.qL1_list[2].qL2_list[0].q2_id);
//}
}
else
{
Response.Redirect(ton.config.Global_config.RootURL);
}
//ไม่ใช่
if ((!Page.IsPostBack) && (ck != null))
{
//-------get latest------
string strQ2ID = max;
//ton.JavaScript.MessageBox(strQ2ID);
if (strQ2ID != null)
{
if (strQ2ID == "2")
{
// Origin Q2_1
pnlQL1_3.Visible = true;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = true;
pnlQL2_2.Visible = false;
pnlQL2_3.Visible = false;
pnlQL2_4.Visible = false;
//-----End Nested Panel -----
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
else if (strQ2ID == "3")
{
// Next is Q2_2
pnlQL1_3.Visible = true;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = true;
pnlQL2_3.Visible = false;
pnlQL2_4.Visible = false;
//-----End Nested Panel -----
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
else if (strQ2ID == "4")
{
// Next is Q2_3
pnlQL1_3.Visible = true;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = false;
pnlQL2_3.Visible = true;
pnlQL2_4.Visible = false;
//-----End Nested Panel -----
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
else if (strQ2ID == "5")
{
// Next is Q2_4
pnlQL1_3.Visible = true;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = false;
pnlQL2_3.Visible = false;
pnlQL2_4.Visible = true;
//-----End Nested Panel -----
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
else if (strQ2ID == "6")
{
// Next is Q2_5
pnlQL1_3.Visible = false;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = false;
pnlQL2_3.Visible = false;
pnlQL2_4.Visible = false;
//-----End Nested Panel -----
pnlQL1_4.Visible = true;
pnlQL1_5.Visible = false;
}
else if (strQ2ID == "7")
{
// Next is Q2_6
pnlQL1_3.Visible = false;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = false;
pnlQL2_3.Visible = false;
pnlQL2_4.Visible = false;
//-----End Nested Panel -----
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = true;
}
else if (strQ2ID == "8")
{
// Next is QSet C ค.
litfinish.Text = "เสร็จสิ้นการแก้ไขประเมิน" + qset.qset_text;
litfinish.Visible = true;
btnToQB.Visible = true;
pnlQL1_3.Visible = false;
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
else
{
// Origin Q2_1
pnlQL1_3.Visible = false;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = false;
pnlQL2_3.Visible = false;
pnlQL2_4.Visible = false;
//-----End Nested Panel -----
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
}
//------------------
/*
#region LoadData_from_DB
* // Load and Map DB Data For Edit Mode only
* string strSQL1 = "";
* SqlCommand cmd = new SqlCommand();
* DataView dv1 = new DataView();
* // Load and Map Data from DB to interface
* //คำตอบ
* // ประเด็นที่ 3
#region คำตอบ คำถามที่ 1
* strSQL1 = "select * from dbo.answer_q2 q2, answer_q3 q3 "
+ " where q2.qset_id = @qset_id and "
+ "q2.pj_id = @pj_id and "
+ "q2.q2_id = @q2_id and "
+ "q2.answer_q2_id = q3.answer_q2_id";
+
+ cmd = new SqlCommand(strSQL1);
+ cmd.Parameters.AddWithValue("@qset_id", qset.qset_id);
+ cmd.Parameters.AddWithValue("@pj_id", ck.pj_id);
+ cmd.Parameters.AddWithValue("@q2_id", qset.qL1_list[0].qL2_list[0].q2_id);
+
+
+ dv1 = ton.Data.DBHelper.getDataSet(cmd).Tables[0].DefaultView;
+
+
+ radanswer2_1.SelectedValue = dv1.Table.Rows[0]["answer_q2_text"].ToString();
+ txtAnswerQuestion3_1_1.Text = dv1.Table.Rows[0]["answer_q3_text"].ToString();
+ txtAnswerQuestion3_1_2.Text = dv1.Table.Rows[1]["answer_q3_text"].ToString();
+ txtAnswerQuestion3_1_3.Text = dv1.Table.Rows[2]["answer_q3_text"].ToString();
#endregion
+
#region คำตอบ คำถามที่ 2
+ strSQL1 = "select * from dbo.answer_q2 q2, answer_q3 q3 "
+ " where q2.qset_id = @qset_id and "
+ "q2.pj_id = @pj_id and "
+ "q2.q2_id = @q2_id and "
+ "q2.answer_q2_id = q3.answer_q2_id";
+
+ cmd = new SqlCommand(strSQL1);
+ cmd.Parameters.AddWithValue("@qset_id", qset.qset_id);
+ cmd.Parameters.AddWithValue("@pj_id", ck.pj_id);
+ cmd.Parameters.AddWithValue("@q2_id", qset.qL1_list[0].qL2_list[1].q2_id);
+
+
+ dv1 = ton.Data.DBHelper.getDataSet(cmd).Tables[0].DefaultView;
+
+ radanswer2_2.SelectedValue = dv1.Table.Rows[0]["answer_q2_text"].ToString();
+ txtAnswerQuestion3_2_1.Text = dv1.Table.Rows[0]["answer_q3_text"].ToString();
#endregion
+
#region คำตอบ คำถามที่ 3
+ strSQL1 = "select * from dbo.answer_q2 q2, answer_q3 q3 "
+ " where q2.qset_id = @qset_id and "
+ "q2.pj_id = @pj_id and "
+ "q2.q2_id = @q2_id and "
+ "q2.answer_q2_id = q3.answer_q2_id";
+
+ cmd = new SqlCommand(strSQL1);
+ cmd.Parameters.AddWithValue("@qset_id", qset.qset_id);
+ cmd.Parameters.AddWithValue("@pj_id", ck.pj_id);
+ cmd.Parameters.AddWithValue("@q2_id", qset.qL1_list[0].qL2_list[2].q2_id);
+
+
+ dv1 = ton.Data.DBHelper.getDataSet(cmd).Tables[0].DefaultView;
+
+ radanswer2_3.SelectedValue = dv1.Table.Rows[0]["answer_q2_text"].ToString();
+ txtAnswerQuestion3_3_1.Text = dv1.Table.Rows[0]["answer_q3_text"].ToString();
#endregion
+
#region คำตอบ คำถามที่ 4
+ strSQL1 = "select * from dbo.answer_q2 q2, answer_q3 q3 "
+ " where q2.qset_id = @qset_id and "
+ "q2.pj_id = @pj_id and "
+ "q2.q2_id = @q2_id and "
+ "q2.answer_q2_id = q3.answer_q2_id";
+
+ cmd = new SqlCommand(strSQL1);
+ cmd.Parameters.AddWithValue("@qset_id", qset.qset_id);
+ cmd.Parameters.AddWithValue("@pj_id", ck.pj_id);
+ cmd.Parameters.AddWithValue("@q2_id", qset.qL1_list[0].qL2_list[3].q2_id);
+
+
+ dv1 = ton.Data.DBHelper.getDataSet(cmd).Tables[0].DefaultView;
+
+ radanswer2_4.SelectedValue = dv1.Table.Rows[0]["answer_q2_text"].ToString();
+ txtAnswerQuestion3_4_1.Text = dv1.Table.Rows[0]["answer_q3_text"].ToString();
+ txtAnswerQuestion3_4_2.Text = dv1.Table.Rows[1]["answer_q3_text"].ToString();
+ txtAnswerQuestion3_4_3.Text = dv1.Table.Rows[2]["answer_q3_text"].ToString();
+ txtAnswerQuestion3_4_4.Text = dv1.Table.Rows[3]["answer_q3_text"].ToString();
#endregion
+
+ //ประเด็นที่ 4
#region คำตอบ คำถามที่ 5
+ strSQL1 = "select * from dbo.answer_q2 q2, answer_q3 q3 "
+ " where q2.qset_id = @qset_id and "
+ "q2.pj_id = @pj_id and "
+ "q2.q2_id = @q2_id and "
+ "q2.answer_q2_id = q3.answer_q2_id";
+
+ cmd = new SqlCommand(strSQL1);
+ cmd.Parameters.AddWithValue("@qset_id", qset.qset_id);
+ cmd.Parameters.AddWithValue("@pj_id", ck.pj_id);
+ cmd.Parameters.AddWithValue("@q2_id", qset.qL1_list[1].qL2_list[0].q2_id);
+
+
+ dv1 = ton.Data.DBHelper.getDataSet(cmd).Tables[0].DefaultView;
+
+ radanswer2_5_1.SelectedValue = dv1.Table.Rows[0]["answer_q2_text"].ToString();
+ txtAnswerQuestion3_4_1_1.Text = dv1.Table.Rows[0]["answer_q3_text"].ToString();
#endregion
+
+ //ประเด็นที่ 5
#region คำตอบ คำถามที่ 6
+ strSQL1 = "select * from dbo.answer_q2 q2, answer_q3 q3 "
+ " where q2.qset_id = @qset_id and "
+ "q2.pj_id = @pj_id and "
+ "q2.q2_id = @q2_id and "
+ "q2.answer_q2_id = q3.answer_q2_id";
+
+ cmd = new SqlCommand(strSQL1);
+ cmd.Parameters.AddWithValue("@qset_id", qset.qset_id);
+ cmd.Parameters.AddWithValue("@pj_id", ck.pj_id);
+ cmd.Parameters.AddWithValue("@q2_id", qset.qL1_list[2].qL2_list[0].q2_id);
+
+
+ dv1 = ton.Data.DBHelper.getDataSet(cmd).Tables[0].DefaultView;
+
+ radanswer2_6_1.SelectedValue = dv1.Table.Rows[0]["answer_q2_text"].ToString();
+ txtAnswerQuestion3_5_1_1.Text = dv1.Table.Rows[0]["answer_q3_text"].ToString();
+ txtAnswerQuestion3_5_1_2.Text = dv1.Table.Rows[1]["answer_q3_text"].ToString();
+
#endregion
#endregion
*/
}
// set cookies to keep the lastest question Set , Q2
#region set cookies follow to visible panel
#region ไม่ใช้
//if (pnlQL1_3.Visible == true)
//{
// mgCookie.UpdateCookies("q1_id", "3"); //ประเด็นที่สาม
// if (pnlQL2_1.Visible == true)
// {
// mgCookie.UpdateCookies("q2_id", "3"); //คำถามที่1 , IDคำถามเริ่มที่3
// }
// else if (pnlQL2_2.Visible == true)
// {
// mgCookie.UpdateCookies("q2_id", "4"); //คำถามที่2
// }
// else if (pnlQL2_3.Visible == true)
// {
// mgCookie.UpdateCookies("q2_id", "5"); //คำถามที่3
// }
// else if (pnlQL2_4.Visible == true)
// {
// mgCookie.UpdateCookies("q2_id", "6"); //คำถามที่3
// }
//}
//else if (pnlQL1_4.Visible == true)
//{
// mgCookie.UpdateCookies("q1_id", "4"); //ประเด็นที่สี่
// mgCookie.UpdateCookies("q2_id", "7"); //คำถามที่ห้า
//}
//else if (pnlQL1_5.Visible == true)
//{
// mgCookie.UpdateCookies("q1_id", "5"); //ประเด็นที่ห้า
// mgCookie.UpdateCookies("q2_id", "8"); //คำถามที่หก
//}
#endregion
#endregion
//----------------------------------------
//คำถามที่ 1
if (radanswer2_1.SelectedValue == "มี") // ตอบว่า มี
{
txtAnswerQuestion3_1_1.Enabled = txtAnswerQuestion3_1_2.Enabled = txtAnswerQuestion3_1_3.Enabled = true;
reqvld_3_1_1.Enabled = reqvld_3_1_2.Enabled = reqvld_3_1_3.Enabled = true;
}
else
{
txtAnswerQuestion3_1_1.Enabled = txtAnswerQuestion3_1_2.Enabled = txtAnswerQuestion3_1_3.Enabled = false;
reqvld_3_1_1.Enabled = reqvld_3_1_2.Enabled = reqvld_3_1_3.Enabled = false;
}
//คำถามที่ 2
if (radanswer2_2.SelectedValue == "มี") // ตอบว่า มี
{
txtAnswerQuestion3_2_1.Enabled = true;
reqvld_3_2_1.Enabled = true;
}
else
{
txtAnswerQuestion3_2_1.Enabled = false;
reqvld_3_2_1.Enabled = false;
}
//คำถามที่ 3
if (radanswer2_3.SelectedValue == "มี") // ตอบว่า มี
{
txtAnswerQuestion3_3_1.Enabled = true;
reqvld_3_3_1.Enabled = true;
}
else
{
txtAnswerQuestion3_3_1.Enabled = false;
reqvld_3_3_1.Enabled = false;
}
//คำถามที่ 4
if (radanswer2_4.SelectedValue == "มี") // ตอบว่า มี
{
txtAnswerQuestion3_4_1.Enabled = txtAnswerQuestion3_4_2.Enabled = txtAnswerQuestion3_4_3.Enabled = txtAnswerQuestion3_4_4.Enabled = true;
reqvld_3_4_1.Enabled = reqvld_3_4_2.Enabled = reqvld_3_4_3.Enabled = reqvld_3_4_4.Enabled = true;
}
else
{
txtAnswerQuestion3_4_1.Enabled = txtAnswerQuestion3_4_2.Enabled = txtAnswerQuestion3_4_3.Enabled = txtAnswerQuestion3_4_4.Enabled = false;
reqvld_3_4_1.Enabled = reqvld_3_4_2.Enabled = reqvld_3_4_3.Enabled = reqvld_3_4_4.Enabled = false;
}
//คำถามที่ 5
if ((radanswer2_5_1.SelectedValue == "มี") || (radanswer2_5_1.SelectedValue == "มีบางส่วน")) // ตอบว่า มี หรือ มีบางส่วน
{
txtAnswerQuestion3_4_1_1.Enabled = true;
reqvld3_4_1_1.Enabled = true;
}
else
{
txtAnswerQuestion3_4_1_1.Enabled = false;
reqvld3_4_1_1.Enabled = false;
}
//คำถามที่ 6
if (radanswer2_6_1.SelectedValue == "มี") // ตอบว่า มี หรือ มีบางส่วน
{
txtAnswerQuestion3_5_1_1.Enabled = txtAnswerQuestion3_5_1_2.Enabled = true;
reqvld_3_5_1_1.Enabled = reqvld_3_5_1_2.Enabled = true;
}
else
{
txtAnswerQuestion3_5_1_1.Enabled = txtAnswerQuestion3_5_1_2.Enabled = false;
reqvld_3_5_1_1.Enabled = reqvld_3_5_1_2.Enabled = false;
}
}
public static List<association_permissions> GetAllAssociationPermissionsByUser(users user)
{
return GetAllNotDeletedAssociationPermissions().Where(p => p.users_Id.Equals(user.Id)).ToList();
}
public JsonResult CheckLogInInformation(string username1)
{
usersDal db = new usersDal();
userMomentDal umd = new userMomentDal();
//Momentmaxnumber
string getmax = Session["getthemaxnumber"].ToString();
int value = Convert.ToInt32(getmax);
int getmidnumber = Convert.ToInt32(Session["getmidd"]);
System.Threading.Thread.Sleep(2000);
var GetIfUserExist = db.userLst.Where(x => x.username == username1).SingleOrDefault();
List <userMoments> usersingroup = (from tmp in umd.userMomentLST where tmp.mid.Equals(getmidnumber) select tmp).ToList <userMoments>();
if (usersingroup.Count() <= value)
{
if (GetIfUserExist != null)
{
users oh = new users();
oh = GetUser();
if (username1 != oh.username)
{
Notifications n = new Notifications();
notificationsDal nDal = new notificationsDal();
int id = (from x in nDal.nLst
select x).ToList <Notifications>().Count() + 1;
n.dateSent = DateTime.Now.Date;
n.id = id;
n.status = "Not Accepted";
n.type = "invite " + Session["mid"];
n.username = username1;
n.uFrom = oh.username;
nDal.nLst.Add(n);
nDal.SaveChanges();
/*
* userMoments usermoment = new userMoments();
* usermoment.id = 1;
* usermoment.mid = Convert.ToInt32(Session["mid"]);
* usermoment.GroupName = Session["MomentName1"].ToString();
* usermoment.username = username1;
* usermoment.uType = "User";
* umd.userMomentLST.Add(usermoment);
* umd.SaveChanges();
*/
return(Json(1));
}
else
{
return(Json(2));
}
}
else
{
return(Json(0));
}
}
else
{
return(Json(3));
}
}
public async Task <ActionResult <int> > EditUser([FromBody] users u)
{
db.Entry(u).State = EntityState.Modified;
return(await db.SaveChangesAsync());
}
public int usersAdd(users users)
{
usersImpl ousersImpl = new usersImpl();
return ousersImpl.usersAdd( users);
}
protected void Page_Load(object sender, EventArgs e)
{
ton.tonUtilities.pageaAuthorize(ton.config.Global_config.authtext_budgetor, ton.config.Global_config.warning_text);
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
if (ck != null)
{
// option 1 Call from Cookies
sds_project_summary.SelectParameters["pj_id"].DefaultValue = ck.pj_id;
//// option 2 Call from Query String
//// Option has problem with 128bit Encryption which contain '+' but URL.decode will replace '+' as ' '(space).
//// The decoding process error will occur
//// Solution: replace with 64 bit Enryption
//string pj_id = Encryption.Decrypt(Request.QueryString["id"], ton.Encryption.keyword);
//pj_id = tonUtilities.cleanQueryString(pj_id);
//sds_project_summary.SelectParameters["pj_id"].DefaultValue = pj_id;
//// End Option2
// Copy from ProjectSummary.aspx which created by Narut
DataView dv1 = (DataView)sds_project_summary.Select(DataSourceSelectArguments.Empty);
foreach (DataRow dRow in dv1.Table.Rows)
{
lblDeptCode.Text = dRow["mi_code"].ToString();
lblDeptName.Text = dRow["mi_name"].ToString();
lblDivisionCode.Text = dRow["d_code"].ToString();
lblDivisionName.Text = dRow["d_name"].ToString();
lblProjectName.Text = dRow["pj_name"].ToString();
lblProjectCode.Text = dRow["pj_code"].ToString();
lblYutasard.Text = dRow["yut_name"].ToString();
lblIntegrateProject.Text = dRow["pj_integrateProject"].ToString();
lblRelateDept.Text = dRow["pj_relateDept"].ToString();
lblBudget.Text = dRow["pj_budget"].ToString();
lblYear.Text = dRow["pj_year"].ToString();
lit_approval.Text = dRow["pj_approval_status"].ToString();
lbl_pj_doc_no.Text = dRow["pj_doc_number"].ToString();
lbl_pj_date_doc_submitted.Text = dRow["pj_date_doc_submitted"].ToString().Substring(0, dRow["pj_date_doc_submitted"].ToString().IndexOf(" "));
}
// Show result in case its has value
if (String.IsNullOrEmpty(lit_approval.Text))
{
tbl_appr.Visible = false;
}
else
{
tbl_appr.Visible = true;
}
gUtilities gt = new gUtilities();
litRisk1.Text = gt.getReportTammaTotal(ck.pj_id);
litRisk2.Text = gt.getReportFactorRiskTotal(ck.pj_id);
litRisk12.Text = gt.getReportTammaMainTotal(ck.pj_id);
litRisk13.Text = gt.getReportTammaSubTotal(ck.pj_id);
}
}
public async Task <ActionResult <int> > Adduser([FromBody] users users)
{
db.users.Add(users);
return(await db.SaveChangesAsync());
}
protected void Page_Load(object sender, EventArgs e)
{
enableValidation();
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
string max = "";
if (ck != null)
{
string strSQL1 = "select * from question1 q1, question2 q2, question3 q3 where q1.qset_id = 4 and q1.q1_id = q2.q1_id and q2.q2_id = q3.q2_id and q1.q1_id = 7";
SqlDataSource1.SelectCommand = strSQL1;
SqlDataSource1.DataBind();
DataView dv1 = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
//ประเด็นที่ 7
lblQuestion7.Text = "ประเด็นที่ " + dv1.Table.Rows[0]["q1_order"].ToString() + " " + dv1.Table.Rows[0]["q1_text"].ToString();
lblAssumption7.Text = "สมมุติฐาน " + dv1.Table.Rows[0]["q1_order"].ToString() + " " + dv1.Table.Rows[0]["q1_assumption"].ToString();
lblQuestion7_1.Text = "คำถามที่ " + dv1.Table.Rows[0]["q2_order"].ToString() + " " + dv1.Table.Rows[0]["q2_text"].ToString();
lblQuestion7_2.Text = "คำถามที่ " + dv1.Table.Rows[1]["q2_order"].ToString() + " " + dv1.Table.Rows[1]["q2_text"].ToString();
lblQuestion7_3.Text = "คำถามที่ " + dv1.Table.Rows[2]["q2_order"].ToString() + " " + dv1.Table.Rows[2]["q2_text"].ToString();
lblQuestion7_1_1.Text = dv1.Table.Rows[0]["q3_order"].ToString() + " " + dv1.Table.Rows[0]["q3_text"].ToString();
lblQuestion7_2_1.Text = dv1.Table.Rows[1]["q3_order"].ToString() + " " + dv1.Table.Rows[1]["q3_text"].ToString();
lblQuestion7_3_1.Text = dv1.Table.Rows[2]["q3_order"].ToString() + " " + dv1.Table.Rows[2]["q3_text"].ToString();
//ประเด็นที่ 8
string strSQL2 = "select * from question1 q1, question2 q2, question3 q3 where q1.qset_id = 4 and q1.q1_id = q2.q1_id and q2.q2_id = q3.q2_id and q1.q1_id = 8";
SqlDataSource2.SelectCommand = strSQL2;
SqlDataSource2.DataBind();
dv1 = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty);
lblQuestion8.Text = "ประเด็นที่ " + dv1.Table.Rows[0]["q1_order"].ToString() + " " + dv1.Table.Rows[0]["q1_text"].ToString();
lblAssumption8.Text = "สมมุติฐาน " + dv1.Table.Rows[0]["q1_order"].ToString() + " " + dv1.Table.Rows[0]["q1_assumption"].ToString();
lblQuestion8_4.Text = "คำถามที่ " + dv1.Table.Rows[0]["q2_order"].ToString() + " " + dv1.Table.Rows[0]["q2_text"].ToString();
lblQuestion8_5.Text = "คำถามที่ " + dv1.Table.Rows[1]["q2_order"].ToString() + " " + dv1.Table.Rows[1]["q2_text"].ToString();
lblQuestion8_4_1.Text = dv1.Table.Rows[0]["q3_order"].ToString() + " " + dv1.Table.Rows[0]["q3_text"].ToString();
lblQuestion8_5_1.Text = dv1.Table.Rows[1]["q3_order"].ToString() + " " + dv1.Table.Rows[1]["q3_text"].ToString();
//ประเด็นที่ 9
string strSQL3 = "select * from question1 q1, question2 q2, question3 q3 where q1.qset_id = 4 and q1.q1_id = q2.q1_id and q2.q2_id = q3.q2_id and q1.q1_id = 9";
SqlDataSource2.SelectCommand = strSQL3;
SqlDataSource2.DataBind();
dv1 = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty);
lblQuestion9.Text = "ประเด็นที่ " + dv1.Table.Rows[0]["q1_order"].ToString() + " " + dv1.Table.Rows[0]["q1_text"].ToString();
lblAssumption9.Text = "สมมุติฐาน " + dv1.Table.Rows[0]["q1_order"].ToString() + " " + dv1.Table.Rows[0]["q1_assumption"].ToString();
lblQuestion9_6.Text = "คำถามที่ " + dv1.Table.Rows[0]["q2_order"].ToString() + " " + dv1.Table.Rows[0]["q2_text"].ToString();
//lblQuestion9_7.Text = "คำถามที่ " + dv1.Table.Rows[1]["q2_order"].ToString() + " " + dv1.Table.Rows[1]["q2_text"].ToString();
lblQuestion9_6_1.Text = dv1.Table.Rows[0]["q3_order"].ToString() + " " + dv1.Table.Rows[0]["q3_text"].ToString();
lblQuestion9_6_2.Text = dv1.Table.Rows[1]["q3_order"].ToString() + " " + dv1.Table.Rows[1]["q3_text"].ToString();
if (!Page.IsPostBack)
{
#region ต้น
answer ans = new answer();
max = ans.getLatestAnswerQ2(ck.pj_id, ans.getLatestAnswerQSetID(ck.pj_id));
#endregion
string strPendingQ1 = string.Empty;
string strPendingQ2 = string.Empty;
//// เริ่มที่ ต้น comment
//if (Request["q1"] != null && Request["q2"] != null)
//{
// strPendingQ1 = Request["q1"].ToString();
// strPendingQ2 = Request["q2"].ToString();
// switch (strPendingQ1)
// {
// case "1":
// panel1.Visible = true;
// panel2.Visible = false;
// panel3.Visible = false;
// break;
// case "2":
// panel1.Visible = false;
// panel2.Visible = true;
// panel3.Visible = false;
// break;
// case "3":
// panel1.Visible = false;
// panel2.Visible = false;
// panel3.Visible = true;
// break;
// default:
// panel1.Visible = true;
// panel2.Visible = false;
// panel3.Visible = false;
// break;
// }
// switch (strPendingQ2)
// {
// case "1":
// pnl7_1.Visible = true;
// pnl7_2.Visible = false;
// pnl7_3.Visible = false;
// pnl8_4.Visible = false;
// pnl8_5.Visible = false;
// pnl9_6.Visible = false;
// break;
// case "2":
// pnl7_1.Visible = false;
// pnl7_2.Visible = true;
// pnl7_3.Visible = false;
// pnl8_4.Visible = false;
// pnl8_5.Visible = false;
// pnl9_6.Visible = false;
// break;
// case "3":
// pnl7_1.Visible = false;
// pnl7_2.Visible = false;
// pnl7_3.Visible = true;
// pnl8_4.Visible = false;
// pnl8_5.Visible = false;
// pnl9_6.Visible = false;
// break;
// case "4":
// pnl7_1.Visible = false;
// pnl7_2.Visible = false;
// pnl7_3.Visible = false;
// pnl8_4.Visible = true;
// pnl8_5.Visible = false;
// pnl9_6.Visible = false;
// break;
// case "5":
// pnl7_1.Visible = false;
// pnl7_2.Visible = false;
// pnl7_3.Visible = false;
// pnl8_4.Visible = false;
// pnl8_5.Visible = true;
// pnl9_6.Visible = false;
// break;
// case "6":
// pnl7_1.Visible = false;
// pnl7_2.Visible = false;
// pnl7_3.Visible = false;
// pnl8_4.Visible = false;
// pnl8_5.Visible = false;
// pnl9_6.Visible = true;
// break;
// default:
// pnl7_1.Visible = true;
// pnl7_2.Visible = false;
// pnl7_3.Visible = false;
// pnl8_4.Visible = false;
// pnl8_5.Visible = false;
// pnl9_6.Visible = false;
// break;
// }
//}
//else
//// หมด ที่ต้น comment
{
//answer ans = new answer();
//string strQ2ID = ans.getLatestAnswerQ2(ck.pj_id, "4");
//string strQ2ID = ck.q2_id;
#region ต้น
string strQ2ID = max;
//ton.JavaScript.MessageBox(strQ2ID);
#endregion
if (strQ2ID != "0")
{
switch (strQ2ID)
{
//case "10":
case "9":
panel1.Visible = true;
panel2.Visible = false;
panel3.Visible = false;
pnl7_1.Visible = true;
pnl7_2.Visible = false;
pnl7_3.Visible = false;
pnl8_4.Visible = false;
pnl8_5.Visible = false;
pnl9_6.Visible = false;
break;
//case "11":
case "10":
panel1.Visible = true;
panel2.Visible = false;
panel3.Visible = false;
pnl7_1.Visible = false;
pnl7_2.Visible = true;
pnl7_3.Visible = false;
pnl8_4.Visible = false;
pnl8_5.Visible = false;
pnl9_6.Visible = false;
break;
//case "12":
case "11":
panel1.Visible = true;
panel2.Visible = false;
panel3.Visible = false;
pnl7_1.Visible = false;
pnl7_2.Visible = false;
pnl7_3.Visible = true;
pnl8_4.Visible = false;
pnl8_5.Visible = false;
pnl9_6.Visible = false;
break;
//case "13":
case "12":
panel1.Visible = false;
panel2.Visible = true;
panel3.Visible = false;
pnl7_1.Visible = false;
pnl7_2.Visible = false;
pnl7_3.Visible = false;
pnl8_4.Visible = true;
pnl8_5.Visible = false;
pnl9_6.Visible = false;
break;
//case "14":
case "13":
panel1.Visible = false;
panel2.Visible = true;
panel3.Visible = false;
pnl7_1.Visible = false;
pnl7_2.Visible = false;
pnl7_3.Visible = false;
pnl8_4.Visible = false;
pnl8_5.Visible = true;
pnl9_6.Visible = false;
break;
//case "15":
case "14":
panel1.Visible = false;
panel2.Visible = false;
panel3.Visible = true;
pnl7_1.Visible = false;
pnl7_2.Visible = false;
pnl7_3.Visible = false;
pnl8_4.Visible = false;
pnl8_5.Visible = false;
pnl9_6.Visible = true;
break;
case "15":
// Go To Quest E จ
panel1.Visible = false;
panel2.Visible = false;
panel3.Visible = false;
pnl7_1.Visible = false;
pnl7_2.Visible = false;
pnl7_3.Visible = false;
pnl8_4.Visible = false;
pnl8_5.Visible = false;
pnl9_6.Visible = false;
pnl_fin.Visible = true;
litfinish.Text = "เสร็จสิ้นการประเมินชุด ง: ขั้นตอนการริเริ่มแผนงาน/โครงการและวิเคราะห์เบื้องต้น โปรดดำเนินการต่อ";
litfinish.Visible = true;
btnToQB.Visible = true;
break;
default:
// 1 เคยเป็น true
panel1.Visible = false;
panel2.Visible = false;
panel3.Visible = false;
// 7.1 เคยเป็น true
pnl7_1.Visible = false;
pnl7_2.Visible = false;
pnl7_3.Visible = false;
pnl8_4.Visible = false;
pnl8_5.Visible = false;
pnl9_6.Visible = false;
break;
}
}
}
}
}
}
public void getUser(users user)
{
_user = user;
userDayoffs();
}
public ActionResult Logout(users usr)
{
Session.RemoveAll();
return(RedirectToAction("Index"));
}
public static bool HasUserPermissionForCommunityWithRole(users u, communities c, string r)
{
return GetAllCommunityPermissionsByCommunity(c).Any(cP => cP.users.Id == u.Id && cP.Role.Equals(r));
}
protected void Page_Load(object sender, EventArgs e)
{
ton.tonUtilities.pageaAuthorize(Global_config.authtext_23, ton.config.Global_config.warning_text);
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
if (!Page.IsPostBack)
{
intial_ApproveList();
if (ck != null)
{
// Copy from ProjectSummary.aspx which created by Narut
sds_project_summary.SelectParameters["pj_id"].DefaultValue = ck.pj_id;
DataView dv1 = (DataView)sds_project_summary.Select(DataSourceSelectArguments.Empty);
foreach (DataRow dRow in dv1.Table.Rows)
{
lblDeptCode.Text = dRow["mi_code"].ToString();
lblDeptName.Text = dRow["mi_name"].ToString();
lblDivisionCode.Text = dRow["d_code"].ToString();
lblDivisionName.Text = dRow["d_name"].ToString();
lblProjectName.Text = dRow["pj_name"].ToString();
lblProjectCode.Text = dRow["pj_code"].ToString();
lblYutasard.Text = dRow["yut_name"].ToString();
lblIntegrateProject.Text = dRow["pj_integrateProject"].ToString();
lblRelateDept.Text = dRow["pj_relateDept"].ToString();
lblBudget.Text = dRow["pj_budget"].ToString();
lblYear.Text = dRow["pj_year"].ToString();
lbl_pj_doc_no.Text = dRow["pj_doc_number"].ToString();
lbl_pj_date_doc_submitted.Text = dRow["pj_date_doc_submitted"].ToString().Substring(0, dRow["pj_date_doc_submitted"].ToString().IndexOf(" "));
lit_approval.Text = dRow["pj_approval_status"].ToString();
}
gUtilities gt = new gUtilities();
litRisk1.Text = gt.getReportTammaTotal(ck.pj_id);
litRisk2.Text = gt.getReportFactorRiskTotal(ck.pj_id);
litRisk12.Text = gt.getReportTammaMainTotal(ck.pj_id);
litRisk13.Text = gt.getReportTammaSubTotal(ck.pj_id);
}
// Below is an OLD code------------------------------------------------------------------
// This page only allow เจ้าหน้าที่สำนักงบประมาณ role=2
//if ((ck == null) || string.IsNullOrEmpty(ck.pj_id) || (ck.p_role_id != "2"))
if ((ck == null) || string.IsNullOrEmpty(ck.pj_id))
{
//ton.JavaScript.MessageBox(" โปรเจค ว่างเปล่า กรุณาเข้าสู่ระบบ ");
Response.Redirect(ton.config.Global_config.RootURL);
}
sds_project_approve_final.SelectParameters["pj_id"].DefaultValue = ck.pj_id;
DataView dv2 = (DataView)sds_project_approve_final.Select(DataSourceSelectArguments.Empty);
// Double check for prevention of re-approval
string appr_text = dv2[0]["pj_approval_status"].ToString();
// Pre DisAble การอนุมัติจากสภา
pnl_parliament.Enabled = false;
pnl_parliament.Visible = false;
report_palia_link.Visible = false;
// Allow ONLY สำนักงบประมาณ ( role id = 2 ) และ ต้องผ่านการให้ความเห็นมาแล้ว
if ((appr_text == Global_config.pj_approval_status_value[1]) && (ck.p_role_id == ton.config.Global_config.authtext_budgetor))
{
rng_app_budget.MaximumValue = lblBudget.Text;
//txt_approval_budget.Text = lblBudget.Text;
pnl_parliament.Enabled = true;
pnl_parliament.Visible = true;
}
}
}
public int?AgregarInvestigador(InvestigatorViewModel pInvestigatorViewModel)
{
users ousers = new users
{
id = 0,
user_name = pInvestigatorViewModel.user_name,
user_email = pInvestigatorViewModel.user_email,
user_pass = pInvestigatorViewModel.user_pass,
contact_name = pInvestigatorViewModel.contact_name,
user_role_id = 11,
user_status_id = 2,
document_type_id = pInvestigatorViewModel.document_type_id,
doc_nro = pInvestigatorViewModel.doc_nro,
nationality_id = pInvestigatorViewModel.nationality_id,
// contract_name = pInvestigatorViewModel.contract_name,
phone = pInvestigatorViewModel.phone,
address = pInvestigatorViewModel.address,
address_municipality_id = pInvestigatorViewModel.address_municipality_id,
address_country_id = pInvestigatorViewModel.address_country_id,
date_created = DateTime.Now,
user_id_created = pInvestigatorViewModel.user_id_created,
user_code_activate = pInvestigatorViewModel.user_code_activate,
user_code_recover = pInvestigatorViewModel.user_code_recover,
};
ousers = oRepositorio.Add(ousers);
investigators oinvestigators = new investigators
{
investigator_id = 0,
user_id = ousers.id,
first_name = pInvestigatorViewModel.first_name,
second_name = pInvestigatorViewModel.second_name,
last_name = pInvestigatorViewModel.last_name,
second_last_name = pInvestigatorViewModel.second_last_name,
gender_id = pInvestigatorViewModel.gender_id,
mobile_phone = pInvestigatorViewModel.mobile_phone,
birthdate = pInvestigatorViewModel.birthdate,
institution_id = pInvestigatorViewModel.institution_id,
investigation_group_id = pInvestigatorViewModel.investigation_group_id,
program_id = pInvestigatorViewModel.program_id,
educational_institution_id = pInvestigatorViewModel.educational_institution_id,
education_level_id = pInvestigatorViewModel.education_level_id,
CVLAC = pInvestigatorViewModel.CVLAC,
};
foreach (int interest_area_id in pInvestigatorViewModel.interest_areas)
{
oRepositorioInvestigatorInterestArea.Add(new investigators_interest_areas
{
interest_area_id = interest_area_id,
investigator_id = oinvestigators.investigator_id,
date_created = DateTime.Now,
user_id_created = pInvestigatorViewModel.user_id_created,
date_modified = DateTime.Now,
user_id_modified = pInvestigatorViewModel.user_id_created,
});
}
foreach (int commission_id in pInvestigatorViewModel.commissions)
{
oRepositorioInvestigatorCommission.Add(new investigators_commissions
{
commission_id = commission_id,
investigator_id = oinvestigators.investigator_id,
date_created = DateTime.Now,
user_id_created = pInvestigatorViewModel.user_id_created,
date_modified = DateTime.Now,
user_id_modified = pInvestigatorViewModel.user_id_created,
});
}
oinvestigators = oRepositorioInvestigator.Add(oinvestigators);
oUnitOfWork.SaveChanges();
return(oinvestigators.user_id);
}
public static void writelog(string txt, users user, int obj_id)
{
writelog(txt, user, "", "", obj_id);
}
public void AddUser(users user)
{
_entities.Context.users.Add(user);
SaveChanges();
}
public static void writelog(string txt, users user)
{
writelog(txt, user, "", "", 0);
}
public static bool HasUserPermissionForAssociation(users u, associations a)
{
return GetAllAssociationPermissionsByAssociation(a).Any(associationPermission => associationPermission.users.Id == u.Id);
}
public String UpdateGroupIdInUsers(string token)
{
//int groupId, string newList, int userId
token = TokenManager.readToken(HttpContext.Current.Request);
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
string message = "";
int groupId = 0;
int userId = 0;
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
string newList = "";
List <int> newListObj = new List <int>();
foreach (Claim c in claims)
{
if (c.Type == "newList")
{
newList = c.Value.Replace("\\", string.Empty);
newList = newList.Trim('"');
newListObj = JsonConvert.DeserializeObject <List <int> >(newList, new IsoDateTimeConverter {
DateTimeFormat = "dd/MM/yyyy"
});
}
else if (c.Type == "groupId")
{
groupId = int.Parse(c.Value);
}
else if (c.Type == "userId")
{
userId = int.Parse(c.Value);
}
}
// DateTime cmpdate = DateTime.Now.AddDays(newdays);
try
{
using (incposdbEntities entity = new incposdbEntities())
{
// reset old list
List <users> oldList = entity.users.Where(x => x.groupId == groupId).ToList();
if (oldList.Count > 0)
{
for (int i = 0; i < oldList.Count; i++)
{
oldList[i].groupId = null;
oldList[i].updateUserId = userId;
oldList[i].updateDate = DateTime.Now;
}
entity.SaveChanges();
}
//save new list
if (newListObj.Count > 0)
{
foreach (int rowId in newListObj)
{
users userRow = entity.users.Find(rowId);
userRow.updateUserId = userId;
userRow.updateDate = DateTime.Now;
userRow.groupId = groupId;
message = entity.SaveChanges().ToString();
}
}
else
{
//message = "-1";
message = "0";
}
}
// return message; ;
return(TokenManager.GenerateToken(message));
}
catch
{
return(TokenManager.GenerateToken("0"));
}
}
//var re = Request;
//var headers = re.Headers;
//string token = "";
//string message = "";
//if (headers.Contains("APIKey"))
//{
// token = headers.GetValues("APIKey").First();
//}
//Validation validation = new Validation();
//bool valid = validation.CheckApiKey(token);
//if (valid)
//{
// newList = newList.Replace("\\", string.Empty);
// newList = newList.Trim('"');
// List<int> newListObj = JsonConvert.DeserializeObject<List<int>>(newList, new JsonSerializerSettings { DateParseHandling = DateParseHandling.None });
// try
// {
// using (incposdbEntities entity = new incposdbEntities())
// {
// // reset old list
// List<users> oldList = entity.users.Where(x => x.groupId == groupId).ToList();
// if (oldList.Count > 0)
// {
// for (int i = 0; i < oldList.Count; i++)
// {
// oldList[i].groupId = null;
// oldList[i].updateUserId = userId;
// oldList[i].updateDate = DateTime.Now;
// }
// entity.SaveChanges();
// }
// //save new list
// if (newListObj.Count > 0)
// {
// foreach (int rowId in newListObj)
// {
// users userRow = entity.users.Find(rowId);
// userRow.updateUserId = userId;
// userRow.updateDate = DateTime.Now;
// userRow.groupId = groupId;
// entity.SaveChanges();
// }
// }
// else
// {
// message = "-1";
// }
// }
// return message; ;
// }
// catch
// {
// return "-1";
// }
//}
//else
// return "-1";
}
protected void btnNext_Click(object sender, EventArgs e)
{
if (!Page.IsValid)
{
return;
}
else
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
SqlParameter pj_background = new SqlParameter("@pj_background", SqlDbType.NVarChar);
pj_background.Direction = ParameterDirection.Input;
pj_background.Value = txtBackground.Text;
SqlParameter pj_urgency = new SqlParameter("@pj_urgency", SqlDbType.NVarChar);
pj_urgency.Direction = ParameterDirection.Input;
pj_urgency.Value = txtUrgency.Text;
//SqlParameter pj_risk_info = new SqlParameter("@pj_risk_info", SqlDbType.NVarChar);
//pj_risk_info.Direction = ParameterDirection.Input;
//pj_risk_info.Value = txtRiskInfo.Text;
//SqlParameter pj_risk_reduction1 = new SqlParameter("@pj_risk_reduction1", SqlDbType.NVarChar);
//pj_risk_reduction1.Direction = ParameterDirection.Input;
//pj_risk_reduction1.Value = txtRiskReduction1.Text;
//SqlParameter pj_risk_reduction2 = new SqlParameter("@pj_risk_reduction2", SqlDbType.NVarChar);
//pj_risk_reduction2.Direction = ParameterDirection.Input;
//pj_risk_reduction2.Value = txtRiskReduction2.Text;
//SqlParameter pj_eval1 = new SqlParameter("@pj_risk_eval1", SqlDbType.NVarChar);
//pj_eval1.Direction = ParameterDirection.Input;
//pj_eval1.Value = txtRiskEval1.Text;
//SqlParameter pj_eval2 = new SqlParameter("@pj_risk_eval2", SqlDbType.NVarChar);
//pj_eval2.Direction = ParameterDirection.Input;
//pj_eval2.Value = txtRiskEval2.Text;
//SqlParameter pj_eval3 = new SqlParameter("@pj_risk_eval3", SqlDbType.NVarChar);
//pj_eval3.Direction = ParameterDirection.Input;
//pj_eval3.Value = txtRiskEval3.Text;
SqlParameter pj_id = new SqlParameter("@pj_id", SqlDbType.Int);
pj_id.Direction = ParameterDirection.Input;
pj_id.Value = ck.pj_id;
insertParameters.Add(pj_background);
insertParameters.Add(pj_urgency);
//insertParameters.Add(pj_risk_info);
//insertParameters.Add(pj_risk_reduction1);
//insertParameters.Add(pj_risk_reduction2);
//insertParameters.Add(pj_eval1);
//insertParameters.Add(pj_eval2);
//insertParameters.Add(pj_eval3);
insertParameters.Add(pj_id);
try
{
SqlDataSource1.Update();
}
catch
{
//ELMA Log
}
Response.Redirect("project_category.aspx");
}
}
public int usersAdd(users users)
{
usersImpl ousersImpl = new usersImpl();
return(ousersImpl.usersAdd(users));
}
public bool Update(string nametb, string lastnametb, decimal deptID, int rate, bool statu, users userOld)
{
userOld.name = nametb;
userOld.lastname = lastnametb;
userOld.departmantId = deptID;
userOld.rate = rate;
userOld.statu = statu;
userOld.username = (userOld.name + "_" + userOld.lastname).ToLower();
missionEntities.Entry(userOld).State = System.Data.Entity.EntityState.Modified;
missionEntities.SaveChanges();
return(true);
}
public bool usersUpdate(users users)
{
usersImpl ousersImpl = new usersImpl();
return(ousersImpl.usersUpdate(users));
}
protected void btnSaveQL1(object sender, EventArgs e)
{
if (!Page.IsValid)
{
return;
}
Button btn_temp = sender as Button;
string arg = btn_temp.CommandArgument;
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
answer ans = new answer();
int ret = -1;
int ret2 = 0;
if (ck == null)
{
ton.JavaScript.MessageBox(" ข้อมูลโปรเจค ว่างเปล่า \r\n กรุณาเข้าสู่ระบบ ");
return;
}
if (arg == "3.2.1")
{
//ประเด็น3
#region 3.2.1
ret = ans.insertOrUpdateAnswerQ2(radanswer2_1.SelectedValue, ck.pj_id, qset.qL1_list[0].qL2_list[0].q2_id, ck.qset_id);
mgCookie.UpdateCookies("answer_q2_id", ret.ToString());
// มี หรือ ไม่มี
if (radanswer2_1.SelectedValue == "มี") // ตอบว่า มี
{
// คำถามย่อยข้อ 1.1
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_1_1.Text, ck.pj_id, qset.qL1_list[0].qL2_list[0].qL3_list[0].q3_id, ret.ToString());
// คำถามย่อยข้อ 1.2
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_1_2.Text, ck.pj_id, qset.qL1_list[0].qL2_list[0].qL3_list[1].q3_id, ret.ToString());
// คำถามย่อยข้อ 1.3
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_1_3.Text, ck.pj_id, qset.qL1_list[0].qL2_list[0].qL3_list[2].q3_id, ret.ToString());
}
else
{
// คำถามย่อยข้อ 1.1
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[0].qL3_list[0].q3_id, ret.ToString());
// คำถามย่อยข้อ 1.2
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[0].qL3_list[1].q3_id, ret.ToString());
// คำถามย่อยข้อ 1.3
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[0].qL3_list[2].q3_id, ret.ToString());
}
#endregion
if (ret2 > 0)
{
//บันทึกสำเร็จ
pnlQL1_3.Visible = true;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = true;
pnlQL2_3.Visible = false;
pnlQL2_4.Visible = false;
//-----End Nested Panel -----
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
else
{
//บันทึกไม่สำเร็จ
ton.JavaScript.MessageBox("บันทึก ประเด็น3 ไม่สำเร็จ");
}
}
else if (arg == "3.2.2")
{
//ประเด็น3
#region 3.2.2
ret = ans.insertOrUpdateAnswerQ2(radanswer2_2.SelectedValue, ck.pj_id, qset.qL1_list[0].qL2_list[1].q2_id, ck.qset_id);
mgCookie.UpdateCookies("answer_q2_id", ret.ToString());
if (radanswer2_2.SelectedValue == "มี") // ตอบว่า มี
{
// คำถามย่อยข้อ 2.1
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_2_1.Text, ck.pj_id, qset.qL1_list[0].qL2_list[1].qL3_list[0].q3_id, ret.ToString());
}
else
{
// คำถามย่อยข้อ 2.1
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[1].qL3_list[0].q3_id, ret.ToString());
}
#endregion
if (ret2 > 0)
{
//บันทึกสำเร็จ
pnlQL1_3.Visible = true;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = false;
pnlQL2_3.Visible = true;
pnlQL2_4.Visible = false;
//-----End Nested Panel -----
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
else
{
//บันทึกไม่สำเร็จ
ton.JavaScript.MessageBox("บันทึก ประเด็น3 ไม่สำเร็จ");
}
}
else if (arg == "3.2.3")
{
//ประเด็น3
#region 3.2.3
ret = ans.insertOrUpdateAnswerQ2(radanswer2_3.SelectedValue, ck.pj_id, qset.qL1_list[0].qL2_list[2].q2_id, ck.qset_id);
mgCookie.UpdateCookies("answer_q2_id", ret.ToString());
if (radanswer2_3.SelectedValue == "มี") // ตอบว่า มี
{
// คำถามย่อยข้อ 3.1
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_3_1.Text, ck.pj_id, qset.qL1_list[0].qL2_list[2].qL3_list[0].q3_id, ret.ToString());
}
else
{
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[2].qL3_list[0].q3_id, ret.ToString());
}
#endregion
if (ret2 > 0)
{
//บันทึกสำเร็จ
pnlQL1_3.Visible = true;
// nested panel inside pnlql1_3
//--only 1st question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = false;
pnlQL2_3.Visible = false;
pnlQL2_4.Visible = true;
//-----end nested panel -----
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
else
{
//บันทึกไม่สำเร็จ
ton.JavaScript.MessageBox("บันทึก ประเด็น3 ไม่สำเร็จ");
}
}
else if (arg == "3.2.4")
{
//ประเด็น3
#region 3.2.4
ret = ans.insertOrUpdateAnswerQ2(radanswer2_4.SelectedValue, ck.pj_id, qset.qL1_list[0].qL2_list[3].q2_id, ck.qset_id);
mgCookie.UpdateCookies("answer_q2_id", ret.ToString());
if (radanswer2_4.SelectedValue == "มี")
{
// คำถามย่อยข้อ 4.1
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_4_1.Text, ck.pj_id, qset.qL1_list[0].qL2_list[3].qL3_list[0].q3_id, ret.ToString());
// คำถามย่อยข้อ 4.2
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_4_2.Text, ck.pj_id, qset.qL1_list[0].qL2_list[3].qL3_list[1].q3_id, ret.ToString());
// คำถามย่อยข้อ 4.3
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_4_3.Text, ck.pj_id, qset.qL1_list[0].qL2_list[3].qL3_list[2].q3_id, ret.ToString());
// คำถามย่อยข้อ 4.4
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_4_4.Text, ck.pj_id, qset.qL1_list[0].qL2_list[3].qL3_list[3].q3_id, ret.ToString());
}
else
{
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[3].qL3_list[0].q3_id, ret.ToString());
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[3].qL3_list[1].q3_id, ret.ToString());
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[3].qL3_list[2].q3_id, ret.ToString());
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[3].qL3_list[3].q3_id, ret.ToString());
}
#endregion
if (ret2 > 0)
{
//บันทึกสำเร็จ
pnlQL1_3.Visible = false;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = false;
pnlQL2_3.Visible = false;
pnlQL2_4.Visible = false;
//-----End Nested Panel -----
pnlQL1_4.Visible = true;
pnlQL1_5.Visible = false;
}
else
{
//บันทึกไม่สำเร็จ
ton.JavaScript.MessageBox("บันทึก ประเด็น3 ไม่สำเร็จ");
}
}
else if (arg == "4")
{
//ประเด็น4
ret = ans.insertOrUpdateAnswerQ2(radanswer2_5_1.SelectedValue, ck.pj_id, qset.qL1_list[1].qL2_list[0].q2_id, ck.qset_id);
mgCookie.UpdateCookies("answer_q2_id", ret.ToString());
// มี หรือ ไม่มี
if ((radanswer2_5_1.SelectedValue == "มี") || (radanswer2_5_1.SelectedValue == "มีบางส่วน")) // ตอบว่า มี
{
// คำถามย่อยข้อ 5.1
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_4_1_1.Text, ck.pj_id, qset.qL1_list[1].qL2_list[0].qL3_list[0].q3_id, ret.ToString());
}
else
{
// คำถามย่อยข้อ 5.1
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[1].qL2_list[0].qL3_list[0].q3_id, ret.ToString());
}
if (ret2 > 0)
{
//บันทึกสำเร็จ
pnlQL1_3.Visible = false;
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = true;
}
else
{
//บันทึกไม่สำเร็จ
ton.JavaScript.MessageBox("บันทึก ประเด็น4 ไม่สำเร็จ");
}
}
else if (arg == "5")
{
//ประเด็น5
ret = ans.insertOrUpdateAnswerQ2(radanswer2_6_1.SelectedValue, ck.pj_id, qset.qL1_list[2].qL2_list[0].q2_id, ck.qset_id);
mgCookie.UpdateCookies("answer_q2_id", ret.ToString());
// มี หรือ ไม่มี
if (radanswer2_6_1.SelectedValue == "มี") // ตอบว่า มี
{
// คำถามย่อยข้อ 6.1
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_5_1_1.Text, ck.pj_id, qset.qL1_list[2].qL2_list[0].qL3_list[0].q3_id, ret.ToString());
// คำถามย่อยข้อ 6.2
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_5_1_2.Text, ck.pj_id, qset.qL1_list[2].qL2_list[0].qL3_list[1].q3_id, ret.ToString());
}
else
{
// คำถามย่อยข้อ 6.1
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[2].qL2_list[0].qL3_list[0].q3_id, ret.ToString());
// คำถามย่อยข้อ 6.2
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[2].qL2_list[0].qL3_list[1].q3_id, ret.ToString());
}
if (ret2 > 0)
{
//บันทึกสำเร็จ
litfinish.Text = "เสร็จสิ้นการแก้ไขประเมิน" + qset.qset_text;
litfinish.Visible = true;
btnToQB.Visible = true;
pnlQL1_3.Visible = false;
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
else
{
//บันทึกไม่สำเร็จ
ton.JavaScript.MessageBox("บันทึก ประเด็น5 ไม่สำเร็จ");
}
}
}
public ActionResult Login(UserLoginVM model, string returnUrl)
{
try {
if (!ModelState.IsValid)
{
return(View(model));
}
if (_repo.UserValidate(model.user_name) != "")
{
users user = _repo.UserGet(model.user_name, model.password);
if (user != null)
{
if (user.active == true)
{
switch (user.state_id)
{
case 0:
// Usuario OK
FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(
1,
user.name,
DateTime.Now,
DateTime.Now.AddMinutes(720), // Expira en 60 minutos.
model.rememberme,
user.rol.description);
string hashCookies = FormsAuthentication.Encrypt(ticket);
HttpCookie cookie = new HttpCookie(FormsAuthentication.FormsCookieName, hashCookies);
Response.Cookies.Add(cookie);
Session["UserID"] = user.id;
//cargamos menu desde db
IEnumerable <ListMenu> menu = _repo.GetMenu(user.rol_id);
Session["Menu"] = menu;
return(RedirectToLocal(returnUrl));
case 1:
// Usuario Bloquedo.
return(View("Bloqueado"));
case 2:
// Usuario que debe cambiar la contraseña.
Session["UserID"] = user.id;
return(RedirectToAction("ChangePassword"));
default:
// Si no encuentra un estado.
return(View("Error"));
}
}
else
{
ViewBag.ValidationUser = "******";
}
}
else
{
ViewBag.ValidationUser = "******";
}
}
else
{
ViewBag.ValidationUser = "******";
}
}catch (Exception ex)
{
return(View(model));
}
return(View(model));
}
public static List<community_permissions> GetAllCommunityPermissionsByUser(users user)
{
return GetAllNotDeletedCommunityPermissions().Where(p => p.users_Id.Equals(user.Id)).ToList();
}
public ManageUserViewModel(users user)
{
this.guid = user.user_id;
this.userName = user.user_name;
}
public static bool HasUserPermissionForCommunity(users u, communities c)
{
return GetAllCommunityPermissionsByCommunity(c).Any(cP => cP.users.Id == u.Id);
}
// UPDATE
public static int UpdateUser(users user)
{
users userToUpdate = GetUserById(user.Id);
userToUpdate.Username = user.Username;
int affectedRows;
try
{
affectedRows = Context.SaveChanges();
}
catch (DbEntityValidationException ex)
{
foreach (DbEntityValidationResult item in ex.EntityValidationErrors)
{
// Get entry
DbEntityEntry entry = item.Entry;
string entityTypeName = entry.Entity.GetType().Name;
// Display or log error messages
foreach (DbValidationError subItem in item.ValidationErrors)
{
string message = string.Format("Error '{0}' occurred in {1} at {2}",
subItem.ErrorMessage, entityTypeName, subItem.PropertyName);
Console.WriteLine(message);
}
// Rollback changes
switch (entry.State)
{
case EntityState.Added:
entry.State = EntityState.Detached;
break;
case EntityState.Modified:
entry.CurrentValues.SetValues(entry.OriginalValues);
entry.State = EntityState.Unchanged;
break;
case EntityState.Deleted:
entry.State = EntityState.Unchanged;
break;
}
}
return affectedRows = 0;
}
Context.Entry(userToUpdate).Reload();
return affectedRows;
}
public static bool HasUserPermissionWithRole(users u, string r)
{
return GetAllCommunityPermissionsByUser(u).Any(cP => cP.Role.Equals(r));
}
public static bool HasUserPermissionWithRole(users u, string r)
{
return GetAllAssociationPermissionsByUser(u).Any(aP => aP.Role.Equals(r));
}
public void UpdateUser(users user)
{
_entities.Context.Entry(user).State = EntityState.Modified;
SaveChanges();
}
public void ModificarInvestigator(InvestigatorViewModel pInvestigatorViewModel)
{
using (var scope = new TransactionScope())
{
investigators oinvestigators = oRepositorioInvestigator.FindById(pInvestigatorViewModel.investigator_id);
users ousers = oRepositorio.FindById(oinvestigators.user_id);
ousers.user_name = pInvestigatorViewModel.user_name;
// ousers.user_email = pInvestigatorViewModel.user_email;
// ousers.user_pass = pInvestigatorViewModel.user_pass;
ousers.contact_name = pInvestigatorViewModel.contact_name;
ousers.document_type_id = pInvestigatorViewModel.document_type_id;
ousers.doc_nro = pInvestigatorViewModel.doc_nro;
ousers.nationality_id = pInvestigatorViewModel.nationality_id;
// contract_name = pInvestigatorViewModel.contract_name,
ousers.phone = pInvestigatorViewModel.phone;
ousers.address = pInvestigatorViewModel.address;
ousers.address_municipality_id = pInvestigatorViewModel.address_municipality_id;
ousers.address_country_id = pInvestigatorViewModel.address_country_id;
ousers.user_id_modified = pInvestigatorViewModel.user_id_modified;
ousers.date_modified = DateTime.Now;
if (pInvestigatorViewModel.avatar != null)
{
ousers.avatar = pInvestigatorViewModel.avatar;
}
oRepositorio.Update(ousers);
//investigators oinvestigators = oRepositorioInvestigator.FindById(pInvestigatorViewModel.investigator_id);
oinvestigators.user_id = ousers.id;
oinvestigators.first_name = pInvestigatorViewModel.first_name;
oinvestigators.second_name = pInvestigatorViewModel.second_name;
oinvestigators.last_name = pInvestigatorViewModel.last_name;
oinvestigators.second_last_name = pInvestigatorViewModel.second_last_name;
oinvestigators.gender_id = pInvestigatorViewModel.gender_id;
oinvestigators.mobile_phone = pInvestigatorViewModel.mobile_phone;
oinvestigators.birthdate = pInvestigatorViewModel.birthdate;
oinvestigators.institution_id = pInvestigatorViewModel.institution_id;
oinvestigators.investigation_group_id = pInvestigatorViewModel.investigation_group_id;
oinvestigators.program_id = pInvestigatorViewModel.program_id;
oinvestigators.educational_institution_id = pInvestigatorViewModel.educational_institution_id;
oinvestigators.education_level_id = pInvestigatorViewModel.education_level_id;
oinvestigators.CVLAC = pInvestigatorViewModel.CVLAC;
oRepositorioInvestigatorCommission.DeleteMultiple(pInvestigatorViewModel.investigator_id);
oRepositorioInvestigatorInterestArea.DeleteMultiple(pInvestigatorViewModel.investigator_id);
foreach (int interest_area_id in pInvestigatorViewModel.interest_areas)
{
oRepositorioInvestigatorInterestArea.Add(new investigators_interest_areas
{
interest_area_id = interest_area_id,
investigator_id = pInvestigatorViewModel.investigator_id,
date_created = DateTime.Now,
user_id_created = pInvestigatorViewModel.user_id_created,
date_modified = DateTime.Now,
user_id_modified = pInvestigatorViewModel.user_id_created,
});
}
foreach (int commission_id in pInvestigatorViewModel.commissions)
{
oRepositorioInvestigatorCommission.Add(new investigators_commissions
{
commission_id = commission_id,
investigator_id = pInvestigatorViewModel.investigator_id,
date_created = DateTime.Now,
user_id_created = pInvestigatorViewModel.user_id_created,
date_modified = DateTime.Now,
user_id_modified = pInvestigatorViewModel.user_id_created,
});
}
oRepositorioInvestigator.Update(oinvestigators);
oUnitOfWork.SaveChanges();
scope.Complete();
}
}
public bool usersUpdate(users users)
{
usersImpl ousersImpl = new usersImpl();
return ousersImpl.usersUpdate( users);
}
public long Create(users newusers)
{
return(AllocateRepo().Create(newusers));
}
private static void Load(users user)
{
RP.Sistema.Model.Context db = new Sistema.Model.Context();
var p = from perfil in db.Perfis
from perfilUsuario in perfil.Usuarios
from perfilacao in perfil.Acoes
join acao in db.Acoes on perfilacao.idAcao equals acao.idAcao
join controle in db.Controles on acao.idControle equals controle.idControle
join area in db.Areas on controle.idArea equals area.idArea
join modulo in db.Modulos on area.idModulo equals modulo.idModulo
join usuario in db.Usuarios on perfilUsuario.idUsuario equals usuario.idUsuario
where (usuario.dsLogin == user.user && usuario.flAtivo == "Sim")
select (new permissao { modulo = modulo.nmURL, area = area.nmArea, controle = controle.nmControle, acao = acao.nmAcao, flarea = (area.flUsaURL.ToLower() == "sim") });
_rigthsDB.Add(user.user, p.ToList());
_usersDB.Add(user);
}
public int Update(users existingusers)
{
return(AllocateRepo().Update(existingusers));
}
public static List<association_permissions> GetAllAssociationPermissionsByUserAndRole(users user, string role)
{
return GetAllNotDeletedAssociationPermissions().Where(p => p.users_Id.Equals(user.Id) && p.Role.Equals(role)).ToList();
}
public int Delete(users existingusers)
{
return(AllocateRepo().Delete(existingusers));
}
public static bool HasUserPermissionForAssociationWithRole(users u, associations a, string r)
{
return GetAllAssociationPermissionsByAssociation(a).Any(associationPermission => associationPermission.users.Id == u.Id && associationPermission.Role.Equals(r));
}
protected void btnToSetE_Click(object sender, EventArgs e)
{
//บันทักข้อมูล แล้วแสดงข้อคำถามชุดต่อไปกรณีโครงการต่อเนื่อง หรือ เข้าประเมินปัจจัยถายใน ภายนอก กรณีโครงการใหม่
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
answer ans = new answer();
int ret = ans.insertOrUpdateAnswerQ2(radanswer9_6.SelectedValue, ck.pj_id, "15", "4");
mgCookie.UpdateCookies("answer_q2_id", ret.ToString());
int ret2 = 0;
if (radanswer9_6.SelectedIndex == 0) // ตอบว่า ใช่
{
// คำถามย่อยข้อ 9.6
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion9_6_1.Text, ck.pj_id, "29", ret.ToString());
}
else if (radanswer9_6.SelectedIndex == 1)
{
// คำถามย่อยข้อ 9.6
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "29", ret.ToString());
}
ret = ans.insertOrUpdateAnswerQ2(radanswer9_6.SelectedValue, ck.pj_id, "15", "4");
mgCookie.UpdateCookies("answer_q2_id", ret.ToString());
if (radanswer9_6.SelectedIndex == 0) // ตอบว่า ใช่
{
// คำถามย่อยข้อ 6.2
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion9_6_2.Text, ck.pj_id, "30", ret.ToString());
}
else if (radanswer9_6.SelectedIndex == 1)
{
// คำถามย่อยข้อ 6.2
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "30", ret.ToString());
}
if (ret2 > 0)
{
//บันทึกสำเร็จ
//บันทักข้อมูล แล้วแสดงข้อคำถามชุดต่อไปกรณีโครงการต่อเนื่อง หรือ เข้าประเมินปัจจัยถายใน ภายนอก กรณีโครงการใหม่
projects pj = new projects();
string pjType = pj.getProjectInfo(ck.pj_id, "pj_type");
if (pjType == "โครงการใหม่")
{
////Response.Redirect("factor_risk.aspx");
//Response.Redirect("project_pickquestion.aspx");
}
else
{
////Response.Redirect("question_set_E.aspx");
//Response.Redirect("project_pickquestion.aspx");
}
// Go To Quest E จ
panel1.Visible = false;
panel2.Visible = false;
panel3.Visible = false;
pnl7_1.Visible = false;
pnl7_2.Visible = false;
pnl7_3.Visible = false;
pnl8_4.Visible = false;
pnl8_5.Visible = false;
pnl9_6.Visible = false;
litfinish.Text = "เสร็จสิ้นการประเมินชุด ง: ขั้นตอนการริเริ่มแผนงาน/โครงการและวิเคราะห์เบื้องต้น โปรดดำเนินการต่อ";
pnl_fin.Visible = true;
litfinish.Visible = true;
btnToQB.Visible = true;
}
else
{
//บันทึกไม่สำเร็จ
}
}
public void SelectUser(RegisterViewModels useradd)
{
users user = _context.users.Where(u => u.email == useradd.email).Single();
HttpContext.Session.SetInt32(key: "userId", value: user.id);
}
/// <summary>
///
/// </summary>
/// <param name="userName"></param>
/// <param name="password"></param>
/// <param name="email"></param>
/// <returns></returns>
public AccountCreateStatus CreateUser(string userName, string password, string email)
{
if (String.IsNullOrEmpty(userName))
throw new ArgumentException("Value cannot be null or empty.", "userName");
if (String.IsNullOrEmpty(password))
throw new ArgumentException("Value cannot be null or empty.", "password");
if (String.IsNullOrEmpty(email))
throw new ArgumentException("Value cannot be null or empty.", "email");
using (var context = new OpenTrackerDbContext())
{
var checkUsernameAlreadyExist = (from u in context.users
where u.username == userName
select u).Count();
if (checkUsernameAlreadyExist != 0)
return AccountCreateStatus.DuplicateUserName;
var checkEmailAlreadyExist = (from u in context.users
where u.email == email
select u).Count();
if (checkEmailAlreadyExist != 0)
return AccountCreateStatus.DuplicateEmail;
var activateSecret = AccountValidation.MD5(string.Format(password));
var newUser = new users
{
username = userName,
passhash = password,
email = email,
passkey = AccountValidation.MD5(password),
activatesecret = activateSecret
};
context.AddTousers(newUser);
context.SaveChanges();
var client = new SmtpClient("smtp.gmail.com", 587)
{
Credentials = new NetworkCredential("*****@*****.**", "lol123123"),
EnableSsl = true
};
using (var msg = new MailMessage())
{
var BASE_URL = TrackerSettings.BASE_URL
.Replace("http://", string.Empty)
.Replace("https://", string.Empty);
msg.From = new MailAddress("*****@*****.**");
msg.Subject = string.Format("{0} user registration confirmation", BASE_URL);
var bewlder = new StringBuilder();
bewlder.AppendFormat(
@"
You have requested a new user account on {0} and you have
specified this address ({1}) as user contact.
If you did not do this, please ignore this email. The person who entered your
email address had the IP address {2}. Please do not reply.
To confirm your user registration, you have to follow this link:
http://{0}/account/activate/{3}/
After you do this, you will be able to use your new account. If you fail to
do this, you account will be deleted within a few days. We urge you to read
the RULES and FAQ before you start using {0}.
",
BASE_URL,
email,
HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"],
activateSecret
);
msg.Body = bewlder.ToString();
msg.To.Add(new MailAddress(email));
client.Send(msg);
return AccountCreateStatus.Success;
}
}
}
