protected void btnApprove_Click(object sender, EventArgs e)
{
MAS_COMPANYUSER_DTO sessionUserDet = (MAS_COMPANYUSER_DTO)Session["UserLogin"];
Mas_BiddingCompany_Manage manage = new Mas_BiddingCompany_Manage();
MAS_USERS userUpdate = new MAS_USERS();
userUpdate.UsersNo = Int64.Parse(hdfUserNo.Value.Trim());
userUpdate.Status = "Approved";
userUpdate.UpdatedBy = sessionUserDet.UserName;
userUpdate.UpdatedDate = DateTime.Now;
bool bReset = manage.UpdateUserStatus(userUpdate);
if (bReset)
{
lblMsgResult1.Text = "บันทึกสถานะ การอนุมัติข้อมูลสำเร็จ";
lblMsgResult2.Text = string.Empty;
lbtnPopup_ModalPopupExtender.Show();
/************** Send Email Notify***************/
string _userName = lblUserName.Text.Trim();
string _companyName = lblCompanyName.Text.Trim();
string _emailNotify = ConfigurationManager.GetConfiguration().EmailNotify;
string sBody = GenEmailBodyMailNotify(_userName, _companyName);
SendMailNotify(sBody, _emailNotify);
/*************************************************************/
}
else
{
lblMsgResult1.Text = "บันทึกสถานะ การอนุมัติข้อมูลไม่สำเร็จ";
lblMsgResult2.Text = "กรุณาติดต่อผู้ดูแลระบบ";
lbtnPopup_ModalPopupExtender.Show();
}
}
public bool DeleteData(MAS_USERS data)
{
Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
bool bRet = false;
try
{
string strQuery = "DELETE FROM tb_mas_Users WHERE [UserName] = @UserName";
SqlCommand command = new SqlCommand(strQuery, _conn);
command.Parameters.AddWithValue("@UserName", data.UserName);
command.ExecuteNonQuery();
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);
}
protected void ChangePasswordPushButton_Click(object sender, EventArgs e)
{
try
{
if (IsValid)
{
string _confirmPass = txtConfirmNewPassword.Text.Trim();
GlobalFunction func = new GlobalFunction();
string newPass = func.Encrypt(_confirmPass);
string userNo = hdfUsersNo.Value.ToString().Trim();
Mas_BiddingCompany_Manage manage = new Mas_BiddingCompany_Manage();
MAS_USERS userUpdate = new MAS_USERS();
userUpdate.UsersNo = Int64.Parse(userNo);
userUpdate.Password = newPass;
userUpdate.UpdatedBy = hdfUserName.Value.ToString().Trim();
userUpdate.UpdatedDate = DateTime.Now;
bool bReset = manage.ResetPassword(userUpdate);
if (bReset)
{
if (hdfRoleNo.Value.Trim().Equals("1"))
{
//ScriptManager.RegisterStartupScript(this, this.GetType(), "alert",
// "alert('แก้ไขรหัสผ่านสำเร็จ..');window.location ='../Form/CompanyUser.aspx';", true);
lblMsgResult1.Text = "แก้ไขรหัสผ่านสำเร็จ";
lbtnPopup_ModalPopupExtender.Show();
}
else
{
lblMsgResult1.Text = "แก้ไขรหัสผ่านสำเร็จ";
lbtnPopup_ModalPopupExtender.Show();
}
}
else
{
logger.Info("ChangePasswordPushButton_Click(): bReset=false!");
//Can not update
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(),
// "alertMessage", "alert('ไม่สามารถแก้ไขรหัสผ่านได้!')", true);
lblMsgResult1.Text = "ไม่สามารถแก้ไขรหัสผ่านได้!";
lblMsgResult2.Text = "กรุณาติดต่อผู้ดูแลระบบ";
lbtnPopup_ModalPopupExtender.Show();
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(),
"alertMessage", "alert('ไม่สามารถแก้ไขรหัสผ่านได้! กรุณาติดต่อผู้ดูแลระบบ')", true);
}
}
public bool UpdateData(MAS_USERS data)
{
Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
bool bRet = false;
try
{
string strQuery = "UPDATE [dbo].[tb_mas_Users] " +
"SET [Password] = @Password " +
",[RolesNo] = @RolesNo " +
",[CompanyNo] = @CompanyNo " +
",[UpdatedBy] = @UpdatedBy " +
",[UpdatedDate] = @UpdatedDate " +
"WHERE UserName = @UserName";
SqlCommand command = new SqlCommand(strQuery, _conn);
command.Parameters.AddWithValue("@Password", data.Password);
command.Parameters.AddWithValue("@RolesNo", data.RolesNo);
command.Parameters.AddWithValue("@CompanyNo", data.CompanyNo);
command.Parameters.AddWithValue("@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);
}
command.Parameters.AddWithValue("@UserName", data.UserName);
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 <MAS_USERS> ListAllUser()
{
Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
List <MAS_USERS> lRetData = new List <MAS_USERS>();
try
{
string strQuery = "SELECT * FROM tb_mas_Users";
SqlCommand command = new SqlCommand(strQuery, _conn);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
MAS_USERS retData = new MAS_USERS();
if (!DBNull.Value.Equals(reader["UserName"]))
{
retData.UserName = (string)reader["UserName"];
}
if (!DBNull.Value.Equals(reader["Password"]))
{
retData.Password = (string)reader["Password"];
}
if (!DBNull.Value.Equals(reader["RolesNo"]))
{
retData.RolesNo = (Int64)reader["RolesNo"];
}
if (!DBNull.Value.Equals(reader["CompanyNo"]))
{
retData.CompanyNo = (Int64)reader["CompanyNo"];
}
lRetData.Add(retData);
}
}
}
catch (SqlException sqlEx)
{
logger.Error(sqlEx);
throw sqlEx;
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
throw ex;
}
return(lRetData);
}
public MAS_USERS VerifyUserLogin(string UserName, string Password)
{
Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
MAS_USERS retData = new MAS_USERS();
try
{
string strQuery = "SELECT * FROM [dbo].[tb_mas_Users] WHERE UserName = @UserName AND Password = @Password";
SqlCommand command = new SqlCommand(strQuery, _conn);
command.Parameters.AddWithValue("@UserName", UserName);
command.Parameters.AddWithValue("@Password", Password);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
if (!DBNull.Value.Equals(reader["UserName"]))
{
retData.UserName = (string)reader["UserName"];
}
if (!DBNull.Value.Equals(reader["Password"]))
{
retData.Password = (string)reader["Password"];
}
if (!DBNull.Value.Equals(reader["RolesNo"]))
{
retData.RolesNo = (Int64)reader["RolesNo"];
}
if (!DBNull.Value.Equals(reader["CompanyNo"]))
{
retData.CompanyNo = (Int64)reader["CompanyNo"];
}
}
}
}
catch (SqlException sqlEx)
{
logger.Error(sqlEx);
throw sqlEx;
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
throw ex;
}
return(retData);
}
public bool UpdateUserStatus(MAS_USERS userData)
{
IDbConnection conn = null;
bool ret = false;
try
{
//SET CONNECTION
conn = ConnectionFactory.GetConnection();
conn.ConnectionString = ConfigurationManager.GetConfiguration().DbConnectionString;
//OPEN CONNECTION
conn.Open();
Mas_BiddingCompanyBL bl = new Mas_BiddingCompanyBL(conn);
ret = bl.UpdateUserStatus(userData);
}
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);
}
public MAS_USERS VerifyUserLogin(string UserName, string Password)
{
IDbConnection conn = null;
MAS_USERS ret = new MAS_USERS();
try
{
//SET CONNECTION
conn = ConnectionFactory.GetConnection();
conn.ConnectionString = ConfigurationManager.GetConfiguration().DbConnectionString;
//OPEN CONNECTION
conn.Open();
Mas_UsersBL bl = new Mas_UsersBL(conn);
ret = bl.VerifyUserLogin(UserName, Password);
}
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 btnRegister_Click(object sender, EventArgs e)
{
logger.Info("btnRegister_Click (Start)");
string _phoneNo = ConfigurationManager.GetConfiguration().GulfPhoneNo;
try
{
if (IsValid)
{
Int64? _iCompanyNo = null;
string _sCompanyNo = hdfRetCompanyNo.Value.Trim();
if (!string.IsNullOrEmpty(_sCompanyNo))
{
_iCompanyNo = Convert.ToInt64(_sCompanyNo);
}
MAS_BIDDINGCOMPANY data = new MAS_BIDDINGCOMPANY();
data.CompanyName = txtCompanyName.Text.Trim();
data.TaxID = txtTaxID.Text.Trim();
data.CompanyAddress = txtCompanyAdd.Text.Trim();
data.ContactName = txtContactPerson.Text.Trim();
data.MobilePhoneNo = txtMobilePhone.Text.Trim();
data.TelephoneNo = txtPhoneNo.Text.Trim();
data.Email = txtEmail.Text.Trim();
data.EmailCC = txtEmailCC.Text.Trim();
data.CreatedDate = DateTime.Now;
data.CreatedBy = GetIPAddress();
data.UpdatedDate = DateTime.Now;
data.UpdatedBy = GetIPAddress();
data.CompanyWebsite = txtCompanyWebsite.Text.Trim();
data.CompanyType = ddlUserType.SelectedValue.Trim();
data.CompanyNo = _iCompanyNo;
/************************** For Set PAssword ***********************/
MAS_USERS userData = new MAS_USERS();
int _length = int.Parse(ConfigurationManager.GetConfiguration().PasswordLength);
GlobalFunction func = new GlobalFunction();
string _password = func.RandomDefaultPass(_length);
string _encryptPass = func.Encrypt(_password);
userData.Password = _encryptPass;
//userData.UserName = txtEmail.Text.Trim();
userData.RolesNo = 2; //Role for Company or Vendor!!
userData.CreatedDate = DateTime.Now;
userData.CreatedBy = GetIPAddress();
userData.UpdatedDate = DateTime.Now;
userData.UpdatedBy = GetIPAddress();
userData.Status = "Not Verify";
userData.ProjectNo = Convert.ToInt64(ddlBDProject.SelectedValue);
hdfProjectNo.Value = ddlBDProject.SelectedValue;
/*******************************************************************/
Mas_BiddingCompany_Manage manage = new Mas_BiddingCompany_Manage();
string strRetInsUser = manage.RegisterCompany(data, userData);
if (!string.IsNullOrWhiteSpace(strRetInsUser))
{
hdfCompanyNo.Value = strRetInsUser.Split(';')[0].ToString().Trim();
/************ Insert Attach File **************/
string _companyNo = strRetInsUser.Split(';')[0].ToString().Trim();
List <MAS_COMPANYATTACHMENT> lAttach = new List <MAS_COMPANYATTACHMENT>();
lAttach = SetCompanyFileUpload(_companyNo);
bool result = manage.InsertCompanyAttach(lAttach);
/**********************************************/
if (result)
{
/***************************** Old Version *********************************/
/************** Send Email UserName & Password ***************/
string _userName = strRetInsUser.Split(';')[1].ToString().Trim();
string sBody = GenEmailBody(_userName, _password);
//SendMailUserPassword(sBody, data.Email);
INF_EMIALVENDOR mailData = new INF_EMIALVENDOR();
mailData.EmailTo = data.Email;
mailData.EmailBody = sBody;
Session["EmailVendor"] = mailData;
/*************************************************************/
//******************* Case Crate Success ******************//
//lblMsgResult1.Text = "ท่านได้ทำการลงทะเบียนเรียบร้อย ระบบจะจัดส่งข้อมูลผู้ใช้งานให้ทางอีเมล์ที่ได้ลงทะเบียนไว้";
//lblMsgResult2.Text = "หากไม่ได้รับอีเมล์ภายใน 1 วันสามารถติดต่อได้ที่เบอร์โทร " + _phoneNo;
//lbtnPopup_ModalPopupExtender.Show();
string _encryCompanyNo = "";
string _encryProjectNo = "";
_encryCompanyNo = hdfCompanyNo.Value.Trim();
_encryProjectNo = hdfProjectNo.Value.Trim();
//_encryCompanyNo = GlobalFunction.EncryptParam(hdfCompanyNo.Value.Trim());
//_encryProjectNo = GlobalFunction.EncryptParam(hdfProjectNo.Value.Trim());
Session["RegDetail"] = _encryCompanyNo + ":" + _encryProjectNo;
/***************************** Old Version *********************************/
//string _urlDestination = "~/Form/Questionnaire.aspx?Company=" + _encryCompanyNo + "&Project=" + _encryProjectNo;
string _urlDestination = "~/Form/Questionnaire.aspx";
Response.Redirect(_urlDestination);
//*********************************************************//
}
else
{
lblMsgResult1.Text = "ไม่สามารถแก้ไขรหัสผ่านได้! ";
lblMsgResult2.Text = "กรุณาติดต่อผู้ดูแลระบบที่เบอร์โทร " + _phoneNo;
this.lbtnPopup_ModalPopupExtender.Show();
}
}
else
{
lblMsgResult1.Text = "ไม่สามารถบันทึกข้อมูลได้! ";
lblMsgResult2.Text = "กรุณาติดต่อผู้ดูแลระบบที่เบอร์โทร " + _phoneNo;
this.lbtnPopup_ModalPopupExtender.Show();
}
}
logger.Info("btnRegister_Click (End)");
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
lblMsgResult1.Text = "ไม่สามารถแก้ไขรหัสผ่านได้! ";
lblMsgResult2.Text = "กรุณาติดต่อผู้ดูแลระบบที่เบอร์โทร " + _phoneNo;
this.lbtnPopup_ModalPopupExtender.Show();
}
}
//public string InsertBiddingCompany(MAS_BIDDINGCOMPANY data)
//{
// IDbConnection conn = null;
// string ret = string.Empty;
// try
// {
// //SET CONNECTION
// conn = ConnectionFactory.GetConnection();
// conn.ConnectionString = ConfigurationManager.GetConfiguration().DbConnectionString;
// //OPEN CONNECTION
// conn.Open();
// Mas_BiddingCompanyBL bl = new Mas_BiddingCompanyBL(conn);
// ret = bl.InsertData(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;
//}
#endregion
public string RegisterCompany(MAS_BIDDINGCOMPANY companyData, MAS_USERS userData)
{
Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
IDbConnection conn = null;
IDbTransaction tran = null;
string ret = string.Empty;
try
{
//SET CONNECTION
conn = ConnectionFactory.GetConnection();
conn.ConnectionString = ConfigurationManager.GetConfiguration().DbConnectionString;
//OPEN CONNECTION
conn.Open();
tran = conn.BeginTransaction(IsolationLevel.Serializable);
Mas_BiddingCompanyBL bl = new Mas_BiddingCompanyBL(conn, tran);
string _companyNo = string.Empty;
if (companyData.CompanyNo != null)
{
//************* For Update Company Register *************//
_companyNo = companyData.CompanyNo.ToString().Trim();
bool bRet = bl.UpdateData(companyData);
}
else
{
_companyNo = bl.InsertData(companyData);
}
if (!string.IsNullOrWhiteSpace(_companyNo))
{
userData.CompanyNo = Int64.Parse(_companyNo);
/************ Generate UserName *********************/
string _userName = GenUserName(_companyNo);
userData.UserName = _userName;
/****************************************************/
string userNo = bl.InsertUsersData(userData);
if (!string.IsNullOrWhiteSpace(userNo))
{
ret = _companyNo + ";" + _userName;
#region #### Insert Attach (Not Use) ####
/******* Inset table [tb_mas_CompanyAttachment] *******/
//foreach (var item in lCompanyAttach)
//{
// MAS_COMPANYATTACHMENT data = new MAS_COMPANYATTACHMENT();
// data.CompanyNo = Int64.Parse(_companyNo);
// data.AttachFilePath = item.AttachFilePath;
// data.FileName = item.FileName;
// data.Description = item.Description;
// data.CreatedBy = item.CreatedBy;
// data.CreatedDate = item.CreatedDate;
// data.UpdatedBy = item.UpdatedBy;
// data.UpdatedDate = item.UpdatedDate;
// bl.InsertCompanyAttachData(data);
//}
/******************************************************/
#endregion
}
}
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
ret = string.Empty;
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
finally
{
if (tran != null)
{
tran.Dispose();
}
if (conn != null)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
conn.Dispose();
}
}
return(ret);
}
public string InsertData(MAS_USERS data)
{
Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
string retUserNo = string.Empty;
try
{
string strQuery = "INSERT INTO [dbo].[tb_mas_Users] " +
"([UserName] " +
",[Password] " +
",[RolesNo] " +
",[CompanyNo] " +
",[CreatedBy] " +
",[CreatedDate] " +
",[UpdatedBy] " +
",[UpdatedDate]) " +
"VALUES " +
"(@UserName " +
",@Password " +
",@RolesNo " +
",@CompanyNo " +
",@CreatedBy " +
",@CreatedDate " +
",@UpdatedBy " +
",@UpdatedDate); " +
" SELECT SCOPE_IDENTITY();";
SqlCommand command = new SqlCommand(strQuery, _conn);
command.Transaction = _tran;
command.Parameters.AddWithValue("@UserName", data.UserName);
command.Parameters.AddWithValue("@Password", data.Password);
command.Parameters.AddWithValue("@RolesNo", data.RolesNo);
command.Parameters.AddWithValue("@CompanyNo", data.CompanyNo);
command.Parameters.AddWithValue("@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", 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);
}
object _CompanyNo = command.ExecuteScalar();
if (_CompanyNo != null)
{
retUserNo = _CompanyNo.ToString();
}
}
catch (SqlException sqlEx)
{
logger.Error(sqlEx);
throw sqlEx;
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
throw ex;
}
return(retUserNo);
}
