private void GetCompanyUserDetail()
{
try
{
Mas_BiddingCompany_Manage manage = new Mas_BiddingCompany_Manage();
MAS_BIDDINGCOMPANY ret = new MAS_BIDDINGCOMPANY();
ret = manage.GetBiddingCompany(hdfCompanyNo.Value.ToString());
if (ret != null && ret.CompanyNo > 0)
{
lblCompanyName.Text = ret.CompanyName;
lblTaxID.Text = ret.TaxID;
lblAddress.Text = ret.CompanyAddress;
lblContactName.Text = ret.ContactName;
lblMobieNo.Text = ret.MobilePhoneNo;
lblPhoneNo.Text = ret.TelephoneNo;
lblEmail.Text = ret.Email;
lblEmailCC.Text = ret.EmailCC;
lblWebsite.Text = ret.CompanyWebsite;
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
private void GetCompanyUserDetail()
{
try
{
Mas_BiddingCompany_Manage manage = new Mas_BiddingCompany_Manage();
MAS_BIDDINGCOMPANY ret = new MAS_BIDDINGCOMPANY();
ret = manage.GetBiddingCompany(hdfCompanyNo.Value.ToString());
if (ret != null && ret.CompanyNo > 0)
{
ddlUserType.SelectedValue = ret.CompanyType;
txtCompanyName.Text = ret.CompanyName;
txtTaxID.Text = ret.TaxID;
txtCompanyAdd.Text = ret.CompanyAddress;
txtContactPerson.Text = ret.ContactName;
txtMobilePhone.Text = ret.MobilePhoneNo;
txtPhoneNo.Text = ret.TelephoneNo;
lblEmail.Text = ret.Email;
txtEmailCC.Text = ret.EmailCC;
txtCompanyWebsite.Text = ret.CompanyWebsite;
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
private void GetCompanyDetail(string CompanyNo)
{
try
{
string _companyNo = CompanyNo;
Mas_BiddingCompany_Manage manage = new Mas_BiddingCompany_Manage();
MAS_BIDDINGCOMPANY company = new MAS_BIDDINGCOMPANY();
company = manage.GetBiddingCompany(_companyNo);
lblCompany.Text = company.CompanyName;
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
protected void ibtnSearch_Click(object sender, ImageClickEventArgs e)
{
try
{
if (!string.IsNullOrEmpty(txtTaxID.Text.Trim()))
{
string _taxID = txtTaxID.Text.Trim();
Mas_BiddingCompany_Manage manage = new Mas_BiddingCompany_Manage();
MAS_BIDDINGCOMPANY data = new MAS_BIDDINGCOMPANY();
data = manage.GetCompanyByTaxID(_taxID);
if (data != null && data.CompanyNo > 0)
{
hdfRetCompanyNo.Value = data.CompanyNo.ToString();
txtCompanyName.Text = data.CompanyName;
txtCompanyAdd.Text = data.CompanyAddress;
txtContactPerson.Text = data.ContactName;
txtMobilePhone.Text = data.MobilePhoneNo;
txtPhoneNo.Text = data.TelephoneNo;
txtEmail.Text = data.Email;
txtEmailCC.Text = data.EmailCC;
txtCompanyWebsite.Text = data.CompanyWebsite;
}
else
{
hdfRetCompanyNo.Value = null;
txtCompanyName.Text = string.Empty;
txtCompanyAdd.Text = string.Empty;
txtContactPerson.Text = string.Empty;
txtMobilePhone.Text = string.Empty;
txtPhoneNo.Text = string.Empty;
txtEmail.Text = string.Empty;
txtEmailCC.Text = string.Empty;
txtCompanyWebsite.Text = string.Empty;
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
public bool IsExistCompany(string TaxID, string ProjectNo)
{
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);
MAS_BIDDINGCOMPANY retData = new MAS_BIDDINGCOMPANY();
retData = bl.GetCompanyByTaxIDNProjectNo(TaxID, ProjectNo);
if (retData != null && retData.CompanyNo > 0)
{
ret = true;
}
}
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_BIDDINGCOMPANY GetCompanyByTaxID(string TaxID)
{
IDbConnection conn = null;
MAS_BIDDINGCOMPANY retData = new MAS_BIDDINGCOMPANY();
try
{
//SET CONNECTION
conn = ConnectionFactory.GetConnection();
conn.ConnectionString = ConfigurationManager.GetConfiguration().DbConnectionString;
//OPEN CONNECTION
conn.Open();
Mas_BiddingCompanyBL bl = new Mas_BiddingCompanyBL(conn);
retData = bl.GetCompanyByTaxID(TaxID);
}
catch (Exception ex)
{
retData = null;
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
finally
{
if (conn != null)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
conn.Dispose();
}
}
return(retData);
}
public bool DeleteInfBiddingCompany(MAS_BIDDINGCOMPANY data)
{
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.DeleteData(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 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);
}
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);
}
}
protected void btnRegister_Click(object sender, EventArgs e)
{
try
{
if (IsValid)
{
MAS_BIDDINGCOMPANY data = new MAS_BIDDINGCOMPANY();
/******** Email ********************************/
data.Email = lblEmail.Text.Trim();
/***********************************************/
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.EmailCC = txtEmailCC.Text.Trim();
data.CompanyWebsite = txtCompanyWebsite.Text.Trim();
data.UpdatedDate = DateTime.Now;
data.UpdatedBy = hdfUserName.Value.Trim();
data.CompanyNo = Int64.Parse(hdfCompanyNo.Value.Trim());
data.CompanyType = ddlUserType.SelectedValue.Trim();
/******************** Update Company Attach ****************/
string _companyNo = hdfCompanyNo.Value.ToString().Trim();
List <MAS_COMPANYATTACHMENT> lAttach = new List <MAS_COMPANYATTACHMENT>();
lAttach = SetCompanyFileUpload(_companyNo);
/************************************************************/
Mas_BiddingCompany_Manage manage = new Mas_BiddingCompany_Manage();
bool ret = manage.UpdateInfBiddingCompany(data);
if (ret)
{
if (lAttach != null && lAttach.Count > 0)
{
bool retUpdateAttach = manage.UpdateCompanyAttach(lAttach, _companyNo);
/***********************************************************/
if (retUpdateAttach)
{
Session["UpdResult"] = "y";
lblMsgResult.Text = "แก้ไขข้อมูลสำเร็จ";
}
else
{
logger.Error("Function UpdateCompanyAttach: False");
Session["UpdResult"] = "n";
lblMsgResult.Text = "ไม่สามารถแก้ไขข้อมูลได้! กรุณาติดต่อผู้ดูแลระบบ";
}
}
else
{
Session["UpdResult"] = "y";
lblMsgResult.Text = "แก้ไขข้อมูลสำเร็จ";
}
}
else
{
logger.Error("Function [UpdateInfBiddingCompany]: Return False ");
Session["UpdResult"] = "n";
lblMsgResult.Text = "ไม่สามารถแก้ไขข้อมูลได้! กรุณาติดต่อผู้ดูแลระบบ";
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
Session["UpdResult"] = "n";
lblMsgResult.Text = "ระบบมีปัญหา! กรุณาติดต่อผู้ดูแลระบบ";
}
lbtnPopup_ModalPopupExtender.Show();
}
