//protected void lbtnAttachFile_Click(object sender, EventArgs e)
//{
// if (ViewState["PathFile"] != null)
// {
// string _pathfile = (string)ViewState["PathFile"];
// DownloadAttachFile(_pathfile);
// }
//}
protected void btnAccept_Click(object sender, EventArgs e)
{
if (Session["UserLogin"] == null)
{
Response.Redirect("~/Account/Login.aspx");
}
else
{
/******************************************/
//// Check Questionnaire ///////////////////
/******************************************/
MAS_COMPANYUSER_DTO retUser = (MAS_COMPANYUSER_DTO)Session["UserLogin"];
if (retUser.RolesNo > 0)
{
hdfCompanyNo.Value = retUser.CompanyNo.ToString().Trim();
hdfUserName.Value = retUser.UserName;
hdfUserNo.Value = retUser.UsersNo.ToString().Trim();
hdfRoleNo.Value = retUser.RolesNo.ToString();
}
Inf_Questionnaire_Manage manage = new Inf_Questionnaire_Manage();
INF_QUESTIONNAIRE retData = new INF_QUESTIONNAIRE();
retData.ProjectNo = hdfProjectNo.Value.Trim();
retData.CompanyNo = hdfCompanyNo.Value.Trim();
retData = manage.GetQuestionaire(retData);
if (retData != null && retData.QuestionNo > 0)
{
Response.Redirect("~/Form/BiddingProcess.aspx?ProjectNo=" + hdfProjectNo.Value);
}
else
{
//Response.Redirect("~/Form/Questionnaire.aspx?ProjectNo=" + hdfProjectNo.Value);
Response.Redirect("~/Form/UserRegister.aspx", true);
}
/*******************************************/
}
}
public INF_QUESTIONNAIRE GetQuestionaire(INF_QUESTIONNAIRE data)
{
IDbConnection conn = null;
INF_QUESTIONNAIRE ret = new INF_QUESTIONNAIRE();
try
{
//SET CONNECTION
conn = ConnectionFactory.GetConnection();
conn.ConnectionString = ConfigurationManager.GetConfiguration().DbConnectionString;
//OPEN CONNECTION
conn.Open();
Inf_QuestionnaireBL bl = new Inf_QuestionnaireBL(conn);
ret = bl.GetByCompanyNo(data);
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
finally
{
if (conn != null)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
conn.Dispose();
}
}
return(ret);
}
protected void btnAccept_Click(object sender, EventArgs e)
{
logger.Info("btnAccept_Click() - Start");
/************************ Insert Data *****************/
bool ret = false;
try
{
string _phoneNo = ConfigurationManager.GetConfiguration().GulfPhoneNo;
if (!string.IsNullOrWhiteSpace(hdfProjectNo.Value) && !string.IsNullOrWhiteSpace(hdfCompanyNo.Value))
{
Inf_Questionnaire_Manage bl = new Inf_Questionnaire_Manage();
INF_QUESTIONNAIRE insData = new INF_QUESTIONNAIRE();
insData.ProjectNo = hdfProjectNo.Value.Trim();
insData.CompanyNo = hdfCompanyNo.Value.Trim();
if (rdoQuestion1.SelectedIndex > -1)
{
insData.AnsQuestion1 = int.Parse(rdoQuestion1.SelectedValue);
}
if (rdoQuestion3.SelectedIndex > -1)
{
insData.AnsQuestion3 = int.Parse(rdoQuestion3.SelectedValue);
}
if (rdoQuestion4.SelectedIndex > -1)
{
insData.AnsQuestion4 = int.Parse(rdoQuestion4.SelectedValue);
}
if (rdoQuestion5.SelectedIndex > -1)
{
insData.AnsQuestion5 = int.Parse(rdoQuestion5.SelectedValue);
}
if (rdoQuestion6.SelectedIndex > -1)
{
insData.AnsQuestion6 = int.Parse(rdoQuestion6.SelectedValue);
}
if (rdoQuestion7.SelectedIndex > -1)
{
insData.AnsQuestion7 = int.Parse(rdoQuestion7.SelectedValue);
}
insData.AnsQuestion2 = "วันที่จดทะเบียน: " + txtRegisterDate.Text.Trim() + " ประสบการณ์: " + lblTotalYear.Text;
insData.AnsQuestion8 = txtQuestion8.Text.Trim();
insData.CreatedBy = GetIPAddress();
insData.CreatedDate = DateTime.Now;
insData.UpdatedBy = GetIPAddress();
insData.UpdatedDate = DateTime.Now;
ret = bl.InsertQuestionnaire(insData);
if (ret)
{
/************** Send Email UserName & Password ***************/
if (Session["EmailVendor"] != null)
{
this.lbtnPopup_ModalPopupExtender.Show();
INF_EMIALVENDOR mailData = new INF_EMIALVENDOR();
mailData = (INF_EMIALVENDOR)Session["EmailVendor"];
this.SendMailUserPassword(mailData.EmailBody, mailData.EmailTo);
}
/*************************************************************/
Session["IsAnswer"] = "true";
Session["RegDetail"] = null;
//lblMsgResult1.Text = "บันทึกข้อมูลสำเร็จ";
lblMsgResult1.Text = "ท่านได้ทำการลงทะเบียนเรียบร้อย ระบบจะจัดส่งข้อมูลผู้ใช้งานให้ทางอีเมล์ที่ได้ลงทะเบียนไว้<br />" +
"หากไม่ได้รับอีเมล์ภายใน 1 วันสามารถติดต่อได้ที่เบอร์โทร " + _phoneNo;
this.lbtnPopup_ModalPopupExtender.Show();
}
else
{
Session["IsAnswer"] = "false";
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('ไม่สามารถบันทึกข้อมูลได้')", true);
//string _phoneNo = ConfigurationManager.GetConfiguration().GulfPhoneNo;
lblMsgResult1.Text = "ไม่สามารถบันทึกข้อมูลได้ <br /> กรุณาติดต่อผู้ดูแลระบบที่เบอร์ " + _phoneNo;
this.lbtnPopup_ModalPopupExtender.Show();
}
}
else
{
logger.Info("Session UserLogin has no data..!");
Response.Redirect("~/Account/Login.aspx", true);
}
logger.Info("btnAccept_Click() - End");
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
private void GetCompQuestionaire(string RoleNo)
{
try
{
MAS_COMPANYUSER_DTO _UserLogin = (MAS_COMPANYUSER_DTO)Session["UserLogin"];
Inf_Questionnaire_Manage manage = new Inf_Questionnaire_Manage();
INF_QUESTIONNAIRE retData = new INF_QUESTIONNAIRE();
retData.ProjectNo = hdfProjectNo.Value.Trim();
retData.CompanyNo = hdfCompanyNo.Value.Trim();
retData = manage.GetQuestionaire(retData);
if (retData.QuestionNo > 0)
{
if ((!retData.CompanyNo.Trim().Equals(_UserLogin.CompanyNo.ToString().Trim()) ||
!retData.ProjectNo.Equals(_UserLogin.ProjectNo.ToString().Trim())) &&
(RoleNo.Trim().Equals("2")))
{
Session.Clear();
Session.Abandon();
ViewState.Clear();
FormsAuthentication.SignOut();
Response.Redirect("~/Account/Login.aspx", true);
}
else
{
Mas_BiddingCompany_Manage cManage = new Mas_BiddingCompany_Manage();
MAS_BIDDINGCOMPANY comData = new MAS_BIDDINGCOMPANY();
comData = cManage.GetBiddingCompany(retData.CompanyNo);
lblCompany.Text = comData.CompanyName;
if (retData.AnsQuestion1 != null)
{
lblQ1.Text = (retData.AnsQuestion1 == 1 ? "ใช่" : "ไม่ใช่");
}
lblQ2.Text = retData.AnsQuestion2;
if (retData.AnsQuestion3 != null)
{
lblQ3.Text = (retData.AnsQuestion3 == 1 ? "ใช่" : "ไม่ใช่");
}
if (retData.AnsQuestion4 != null)
{
lblQ4.Text = (retData.AnsQuestion4 == 1 ? "ใช่" : "ไม่ใช่");
}
if (retData.AnsQuestion5 != null)
{
lblQ5.Text = (retData.AnsQuestion5 == 1 ? "ใช่" : "ไม่ใช่");
}
if (retData.AnsQuestion6 != null)
{
lblQ6.Text = (retData.AnsQuestion6 == 1 ? "ใช่" : "ไม่ใช่");
}
if (retData.AnsQuestion7 != null)
{
lblQ7.Text = (retData.AnsQuestion7 == 1 ? "ใช่" : "ไม่ใช่");
}
if (!string.IsNullOrEmpty(retData.AnsQuestion8))
{
lblQ8.Text = retData.AnsQuestion8;
}
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
public INF_QUESTIONNAIRE GetByCompanyNo(INF_QUESTIONNAIRE data)
{
Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
INF_QUESTIONNAIRE ret = null;
try
{
string strQuery = "SELECT * FROM tb_inf_Questionnaire WHERE ProjectNo=@ProjectNo AND CompanyNo=@CompanyNo ";
SqlCommand command = new SqlCommand(strQuery, _conn);
command.Parameters.AddWithValue("@ProjectNo", data.ProjectNo);
command.Parameters.AddWithValue("@CompanyNo", data.CompanyNo);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ret = new INF_QUESTIONNAIRE();
if (!DBNull.Value.Equals(reader["QuestionNo"]))
{
ret.QuestionNo = (Int64)reader["QuestionNo"];
}
if (!DBNull.Value.Equals(reader["ProjectNo"]))
{
ret.ProjectNo = (string)reader["ProjectNo"];
}
if (!DBNull.Value.Equals(reader["CompanyNo"]))
{
ret.CompanyNo = (string)reader["CompanyNo"];
}
if (!DBNull.Value.Equals(reader["AnsQuestion1"]))
{
ret.AnsQuestion1 = (int)reader["AnsQuestion1"];
}
if (!DBNull.Value.Equals(reader["AnsQuestion2"]))
{
ret.AnsQuestion2 = (string)reader["AnsQuestion2"];
}
if (!DBNull.Value.Equals(reader["AnsQuestion3"]))
{
ret.AnsQuestion3 = (int)reader["AnsQuestion3"];
}
if (!DBNull.Value.Equals(reader["AnsQuestion4"]))
{
ret.AnsQuestion4 = (int)reader["AnsQuestion4"];
}
if (!DBNull.Value.Equals(reader["AnsQuestion5"]))
{
ret.AnsQuestion5 = (int)reader["AnsQuestion5"];
}
if (!DBNull.Value.Equals(reader["AnsQuestion6"]))
{
ret.AnsQuestion6 = (int)reader["AnsQuestion6"];
}
if (!DBNull.Value.Equals(reader["AnsQuestion7"]))
{
ret.AnsQuestion7 = (int)reader["AnsQuestion7"];
}
if (!DBNull.Value.Equals(reader["CreatedDate"]))
{
ret.CreatedDate = (DateTime)reader["CreatedDate"];
}
if (!DBNull.Value.Equals(reader["CreatedBy"]))
{
ret.CreatedBy = (string)reader["CreatedBy"];
}
if (!DBNull.Value.Equals(reader["UpdatedDate"]))
{
ret.UpdatedDate = (DateTime)reader["UpdatedDate"];
}
if (!DBNull.Value.Equals(reader["UpdatedBy"]))
{
ret.UpdatedBy = (string)reader["UpdatedBy"];
}
if (!DBNull.Value.Equals(reader["AnsQuestion8"]))
{
ret.AnsQuestion8 = (string)reader["AnsQuestion8"];
}
}
}
}
catch (SqlException sqlEx)
{
logger.Error(sqlEx);
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
return(ret);
}
public bool InsertData(INF_QUESTIONNAIRE data)
{
Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
bool bRet = false;
try
{
string strQuery = "INSERT INTO [dbo].[tb_inf_Questionnaire] " +
"([ProjectNo] " +
",[CompanyNo] " +
",[AnsQuestion1] " +
",[AnsQuestion2] " +
",[AnsQuestion3] " +
",[AnsQuestion4] " +
",[AnsQuestion5] " +
",[AnsQuestion6] " +
",[AnsQuestion7] " +
",[AnsQuestion8] " +
",[CreatedDate] " +
",[CreatedBy] " +
",[UpdatedDate] " +
",[UpdatedBy]) " +
"VALUES " +
"(@ProjectNo " +
",@CompanyNo " +
",@AnsQuestion1 " +
",@AnsQuestion2 " +
",@AnsQuestion3 " +
",@AnsQuestion4 " +
",@AnsQuestion5 " +
",@AnsQuestion6 " +
",@AnsQuestion7 " +
",@AnsQuestion8 " +
",@CreatedDate " +
",@CreatedBy " +
",@UpdatedDate " +
",@UpdatedBy)";
SqlCommand command = new SqlCommand(strQuery, _conn);
if (!string.IsNullOrWhiteSpace(data.ProjectNo))
{
command.Parameters.AddWithValue("@ProjectNo", data.ProjectNo);
}
else
{
command.Parameters.AddWithValue("@ProjectNo", DBNull.Value);
}
if (!string.IsNullOrWhiteSpace(data.CompanyNo))
{
command.Parameters.AddWithValue("@CompanyNo", data.CompanyNo);
}
else
{
command.Parameters.AddWithValue("@CompanyNo", DBNull.Value);
}
if (data.AnsQuestion1 != null)
{
command.Parameters.AddWithValue("@AnsQuestion1", data.AnsQuestion1);
}
else
{
command.Parameters.AddWithValue("@AnsQuestion1", DBNull.Value);
}
if (!string.IsNullOrWhiteSpace(data.AnsQuestion2))
{
command.Parameters.AddWithValue("@AnsQuestion2", data.AnsQuestion2);
}
else
{
command.Parameters.AddWithValue("@AnsQuestion2", DBNull.Value);
}
if (data.AnsQuestion3 != null)
{
command.Parameters.AddWithValue("@AnsQuestion3", data.AnsQuestion3);
}
else
{
command.Parameters.AddWithValue("@AnsQuestion3", DBNull.Value);
}
if (data.AnsQuestion4 != null)
{
command.Parameters.AddWithValue("@AnsQuestion4", data.AnsQuestion4);
}
else
{
command.Parameters.AddWithValue("@AnsQuestion4", DBNull.Value);
}
if (data.AnsQuestion5 != null)
{
command.Parameters.AddWithValue("@AnsQuestion5", data.AnsQuestion5);
}
else
{
command.Parameters.AddWithValue("@AnsQuestion5", DBNull.Value);
}
if (data.AnsQuestion6 != null)
{
command.Parameters.AddWithValue("@AnsQuestion6", data.AnsQuestion6);
}
else
{
command.Parameters.AddWithValue("@AnsQuestion6", DBNull.Value);
}
if (data.AnsQuestion7 != null)
{
command.Parameters.AddWithValue("@AnsQuestion7", data.AnsQuestion7);
}
else
{
command.Parameters.AddWithValue("@AnsQuestion7", DBNull.Value);
}
if (!string.IsNullOrWhiteSpace(data.AnsQuestion8))
{
command.Parameters.AddWithValue("@AnsQuestion8", data.AnsQuestion8);
}
else
{
command.Parameters.AddWithValue("@AnsQuestion8", DBNull.Value);
}
command.Parameters.AddWithValue("@CreatedBy", string.IsNullOrWhiteSpace(data.CreatedBy) ? "" : data.CreatedBy);
if (!string.IsNullOrEmpty(data.CreatedDate.ToString()))
{
DateTime dtNew = (DateTime)data.CreatedDate;
string dateString = dtNew.ToString("MM/dd/yyyy HH:mm:ss");
command.Parameters.AddWithValue("@CreatedDate", dateString);
}
else
{
command.Parameters.AddWithValue("@CreatedDate", DateTime.Now);
}
command.Parameters.AddWithValue("@UpdatedBy", string.IsNullOrWhiteSpace(data.UpdatedBy) ? "" : data.UpdatedBy);
if (!string.IsNullOrEmpty(data.UpdatedDate.ToString()))
{
DateTime dtNew = (DateTime)data.UpdatedDate;
string dateString = dtNew.ToString("MM/dd/yyyy HH:mm:ss");
command.Parameters.AddWithValue("@UpdatedDate", dateString);
}
else
{
command.Parameters.AddWithValue("@UpdatedDate", DateTime.Now);
}
if (command.ExecuteNonQuery() == 1)
{
bRet = true;
}
}
catch (SqlException sqlEx)
{
logger.Error(sqlEx);
throw sqlEx;
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
throw ex;
}
return(bRet);
}
public List <INF_QUESTIONNAIRE> ListAllData()
{
Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
List <INF_QUESTIONNAIRE> lRet = new List <INF_QUESTIONNAIRE>();
try
{
string strQuery = "SELECT [QuestionNo] " +
",[ProjectNo] " +
",[CompanyNo] " +
",[AnsQuestion1] " +
",[AnsQuestion2] " +
",[AnsQuestion3] " +
",[AnsQuestion4] " +
",[AnsQuestion5] " +
",[AnsQuestion6] " +
",[AnsQuestion7] " +
",[AnsQuestion8] " +
",[CreatedDate] " +
",[CreatedBy] " +
",[UpdatedDate] " +
",[UpdatedBy] " +
"FROM [tb_inf_Questionnaire]";
SqlCommand command = new SqlCommand(strQuery, _conn);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
INF_QUESTIONNAIRE data = new INF_QUESTIONNAIRE();
if (!DBNull.Value.Equals(reader["QuestionNo"]))
{
data.QuestionNo = (Int64)reader["QuestionNo"];
}
if (!DBNull.Value.Equals(reader["ProjectNo"]))
{
data.ProjectNo = (string)reader["ProjectNo"];
}
if (!DBNull.Value.Equals(reader["CompanyNo"]))
{
data.CompanyNo = (string)reader["CompanyNo"];
}
if (!DBNull.Value.Equals(reader["AnsQuestion1"]))
{
data.AnsQuestion1 = (int)reader["AnsQuestion1"];
}
if (!DBNull.Value.Equals(reader["AnsQuestion2"]))
{
data.AnsQuestion2 = (string)reader["AnsQuestion2"];
}
if (!DBNull.Value.Equals(reader["AnsQuestion3"]))
{
data.AnsQuestion3 = (int)reader["AnsQuestion3"];
}
if (!DBNull.Value.Equals(reader["AnsQuestion4"]))
{
data.AnsQuestion4 = (int)reader["AnsQuestion4"];
}
if (!DBNull.Value.Equals(reader["AnsQuestion5"]))
{
data.AnsQuestion5 = (int)reader["AnsQuestion5"];
}
if (!DBNull.Value.Equals(reader["AnsQuestion6"]))
{
data.AnsQuestion6 = (int)reader["AnsQuestion6"];
}
if (!DBNull.Value.Equals(reader["AnsQuestion7"]))
{
data.AnsQuestion7 = (int)reader["AnsQuestion7"];
}
if (!DBNull.Value.Equals(reader["AnsQuestion8"]))
{
data.AnsQuestion8 = (string)reader["AnsQuestion8"];
}
if (!DBNull.Value.Equals(reader["CreatedDate"]))
{
data.CreatedDate = (DateTime)reader["CreatedDate"];
}
if (!DBNull.Value.Equals(reader["CreatedBy"]))
{
data.CreatedBy = (string)reader["CreatedBy"];
}
if (!DBNull.Value.Equals(reader["UpdatedDate"]))
{
data.UpdatedDate = (DateTime)reader["UpdatedDate"];
}
if (!DBNull.Value.Equals(reader["UpdatedBy"]))
{
data.UpdatedBy = (string)reader["UpdatedBy"];
}
lRet.Add(data);
}
}
}
catch (SqlException sqlEx)
{
logger.Error(sqlEx);
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
return(lRet);
}
