public void SetDetail(string id)
{
// Dim lnq As New EbrochureSendMailJobLinqDB
// Dim dt As New DataTable
// dt = lnq.GetDataList("is_send_mail='N'", "", Nothing)
// If dt.Rows.Count > 0 Then
// End If
// lnq = Nothing
// dt.Dispose()
ErmTsPersonalInfoLinq Userinfo = new ErmTsPersonalInfoLinq();
DataTable dt;
dt = Userinfo.GetDataList("id=" + id,"",null);
if (dt.Rows.Count > 0) {
lblLine1.Text = "คุณ"+ dt.Rows[0]["first_name"] + " " + dt.Rows[0]["last_name"];
//lblLine1.Text = GetTitleName(dt.Rows[0]["title_name"] + "") + dt.Rows[0]["first_name"] + " " + dt.Rows[0]["last_name"];
lblLine2.Text ="บริษัท:" + dt.Rows[0]["company_name"] + "";
lblLine3.Text ="E-Mail:" + dt.Rows[0]["email"] + "";
LiveFaceScan.userinfo.id = dt.Rows[0]["id"] + "";
LiveFaceScan.userinfo.fullname = lblLine1.Text;
LiveFaceScan.userinfo.email = dt.Rows[0]["email"] + "";
LiveFaceScan.userinfo.companyname = dt.Rows[0]["company_name"] + "";
}
dt.Dispose();
}
public bool UpdateIsSendMail(long pId, string LoginName, TransactionDB trans) {
bool ret = false;
try {
ErmTsPersonalInfoLinq erm = new ErmTsPersonalInfoLinq();
ret = erm.UpdateBySql("update ERM_TS_PERSONAL_INFO set is_send_mail = 'Y' where id='" + pId + "'", trans.Trans);
erm = null;
}
catch (Exception ex) {
ret = false;
}
return ret;
}
public long SavePersonalInfo(ErmTsPersonalInfoPara p,string LoginName, TransactionDB trans) {
long ret = 0;
try {
ErmTsPersonalInfoLinq lnq = new ErmTsPersonalInfoLinq();
if (p.ID > 0)
lnq.GetDataByPK(p.ID, trans.Trans);
lnq.MEMBER_NO = p.MEMBER_NO;
lnq.MEMBER_TYPE = p.MEMBER_TYPE;
lnq.IDCARD_NO = p.IDCARD_NO;
lnq.TITLE_NAME = p.TITLE_NAME;
lnq.FIRST_NAME = p.FIRST_NAME;
lnq.MIDDLE_NAME = p.MIDDLE_NAME;
lnq.LAST_NAME = p.LAST_NAME;
lnq.POSITION_NAME = p.POSITION_NAME;
lnq.DIVISION = p.DIVISION;
lnq.COMPANY_NAME = p.COMPANY_NAME;
lnq.ADDRESS = p.ADDRESS;
lnq.CITY = p.CITY;
lnq.STATE = p.STATE;
lnq.COUNTRY = p.COUNTRY;
lnq.ZIPCODE = p.ZIPCODE;
lnq.TELNO = p.TELNO;
lnq.MOBILE_NO = p.MOBILE_NO;
lnq.FAXNO = p.FAXNO;
lnq.EMAIL = p.EMAIL;
lnq.WEBSITE = p.WEBSITE;
lnq.REGISTERED_CAPITAL = p.REGISTERED_CAPITAL;
lnq.ANNUAL_SALE_VALUE_YEAR = p.ANNUAL_SALE_VALUE_YEAR;
lnq.ANNUAL_SALE_VALUE_VOLUMNS = p.ANNUAL_SALE_VALUE_VOLUMNS;
lnq.REGISPERIOD = p.REGISPERIOD;
lnq.VALID_DATE = p.VALID_DATE;
lnq.EXPIRE_DATE = p.EXPIRE_DATE;
bool re = false;
if (lnq.ID > 0)
re = lnq.UpdateByPK(LoginName, trans.Trans);
else
re = lnq.InsertData(LoginName, trans.Trans);
if (re == true)
ret = lnq.ID;
}catch(Exception ex){
_err = "Engine.Questionnaire.RegisteENG.SavePersonalInfo Exception :" + ex.Message;
ret=0;
}
return ret;
}
public bool chkPersonalInfoByFirstNameLastName(string firstName, string lastName)
{
bool ret = false;
try {
DataTable dt = new DataTable();
ErmTsPersonalInfoLinq lnq = new ErmTsPersonalInfoLinq();
dt = lnq.GetDataList("first_name='" + firstName + "' and last_name='" + lastName + "' and year(CREATE_ON)=year(getdate())", "", null);
if (dt.Rows.Count > 0) {
ret = true;
}
dt.Dispose();
}
catch (Exception ex) {
ret = false;
}
return ret;
}
public void SetUserInfo()
{
try
{
DataTable dt;
ErmTsPersonalInfoLinq Userinfo = new ErmTsPersonalInfoLinq();
// TransactionDB trans = new TransactionDB();
dt = Userinfo.GetDataList("replace(mobile_no,'-','')='" + txtNumber.Text + "'", "", null);
// trans.CommitTransaction();
if (dt.Rows.Count > 0)
{
LiveFaceScan.userinfo.id = dt.Rows[0]["id"] + "";
if (Convert.IsDBNull(dt.Rows[0]["first_name"]) == false && Convert.IsDBNull(dt.Rows[0]["last_name"]) == false) {
LiveFaceScan.userinfo.fullname = "คุณ" + dt.Rows[0]["first_name"] + " " + dt.Rows[0]["last_name"];
}
if (Convert.IsDBNull(dt.Rows[0]["email"]) == false)
{
LiveFaceScan.userinfo.email = dt.Rows[0]["email"] + "";
}
if (Convert.IsDBNull(dt.Rows[0]["company_name"]) == false)
{
LiveFaceScan.userinfo.companyname = dt.Rows[0]["company_name"] + "";
}
this.Visible = false;
//this.Close();
frmSelectBrochures f = new frmSelectBrochures();
f.ShowDialog();
}
else {
Dialog.frmDialogMsg f = new Dialog.frmDialogMsg();
f.lblText.Text = "ไม่พบข้อมูล";
f.ShowDialog();
}
}
catch (Exception exUserinfo) {
Dialog.frmDialogMsg f = new Dialog.frmDialogMsg();
f.lblText.Text = "ไม่พบข้อมูล";
f.ShowDialog();
}
}
public bool chkPersonalInfoByEmail(string eMail)
{
bool ret = false;
try
{
DataTable dt = new DataTable();
ErmTsPersonalInfoLinq lnq = new ErmTsPersonalInfoLinq();
dt = lnq.GetDataList("Email='" + eMail + "' and year(CREATE_ON)=year(getdate())", "", null);
if (dt.Rows.Count > 0)
{
ret = true;
}
dt.Dispose();
}
catch (Exception ex)
{
ret = false;
}
return ret;
}
public ErmTsPersonalInfoPara GetRegisterInfo(long vID)
{
ErmTsPersonalInfoPara ret = new ErmTsPersonalInfoPara();
try
{
ErmTsPersonalInfoLinq lnq = new ErmTsPersonalInfoLinq();
ret = lnq.GetParameter(vID, null);
lnq = null;
}
catch (Exception ex) { }
return ret;
}
public static ErmTsPersonalInfoPara GetPersonalInfoByMemberNo(string MemberNo)
{
ErmTsPersonalInfoPara ret = new ErmTsPersonalInfoPara();
try
{
DataTable dt = new DataTable();
ErmTsPersonalInfoLinq lnq = new ErmTsPersonalInfoLinq();
dt = lnq.GetDataList("member_no='" + MemberNo + "'", "", null);
if (dt.Rows.Count > 0)
{
ret = lnq.GetParameter(Convert.ToInt64(dt.Rows[0]["id"]),null);
}
dt.Dispose();
}
catch (Exception ex)
{
ret = new ErmTsPersonalInfoPara();
}
return ret;
}
