protected void btn_updateprofile_Click(object sender, EventArgs e)
{
DataTable table = (DataTable)Session["ThanhVien"];
ND_THONG_TIN_ND nd = new ND_THONG_TIN_ND(table, 0);
try
{
DateTime bithday = Convert.ToDateTime(String.Format("{0}/{1}/{2}", dropd_month.Text, dropd_day.Text, dropd_year.Text));
bool ok = nd.Save_Object(txt_full_name.Text, nd.MEM_GROUP_ID, txt_address.Text, functions.GetStringDate(bithday),
rd_sex.SelectedItem.Value, txt_phonenumber.Text, txt_faxnumber.Text, txt_email.Text, txt_website.Text,
txt_yahoo.Text, txt_skype.Text, nd.TAX_CODE, nd.NOTE, nd.AVATAR_PATH, nd.VISIBLE_BIT,functions.CheckDate(nd.CREATED_DATE), nd.EDITED_BY,
functions.GetStringDatetime(), nd.ID,nd.HEART);
if (ok)
lbl_error.Text = "Cập nhật thông tin cá nhân thành công";
else lbl_error.Text = "Cập nhật thông tin cá nhân không thành công, vui lòng kiểm tra lại thông tin!";
}
catch (Exception ex)
{
lbl_error.Text = "Cập nhật thông tin cá không thành công" ;
}
}
private void display_info()
{
try
{
DataTable table = (DataTable)Session["ThanhVien"];
if (table != null)
{
ND_THONG_TIN_ND nd = new ND_THONG_TIN_ND(table, 0);
String avatar_name = nd.AVATAR_PATH == "" ? "default_img.gif" : nd.AVATAR_PATH;
txt_username.Text = (String)table.Rows[0][ND_THONG_TIN_DN.cl_USERNAME];
//if (table.Rows[0][ND_THONG_TIN_DN.cl_LASTED_ACCESS].ToString() != null)
//{
// DateTime lasted_access = (DateTime)table.Rows[0][ND_THONG_TIN_DN.cl_LASTED_ACCESS];
// lbl_lasted_access.Text = lasted_access.ToString("dd/MM/yyyy hh:mm:ss tt");
//}
//else
//{
// lbl_lasted_access.Text = DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss tt");
//}
lbl_lasted_access.Text = functions.getLastedAccess(table.Rows[0]["id"].ToString());
img_user.ImageUrl = "Images/avatars/" + avatar_name;
//Fill data on form
txt_address.Text = nd.ADDRESS;
txt_full_name.Text = nd.NAME;
txt_faxnumber.Text = nd.FAX;
txt_phonenumber.Text = nd.PHONE;
txt_email.Text = nd.EMAIL;
txt_website.Text = nd.WEBSITE;
txt_skype.Text = nd.SKYPE;
txt_yahoo.Text = nd.YAHOO;
DateTime birthday = DateTime.Parse(nd.BIRTH_DAY);
functions.selectedDropdown(dropd_day, birthday.Day.ToString());
functions.selectedDropdown(dropd_month, birthday.Month.ToString());
functions.selectedDropdown(dropd_year, birthday.Year.ToString());
rd_sex.Items[int.Parse(nd.SEX)].Selected = true;
lbl_group_name.Text = (String)table.Rows[0][ND_TEN_NHOM_ND.cl_GROUPNAME];
txt_note.Text = nd.NOTE;
//sum_point.Text = functions.returnPoint(table.Rows[0]["id"].ToString());
}
}
catch (Exception ex) {
lbl_group_name.Text = ex.ToString();
//Response.Redirect("error_page.aspx");
}
}
//───────────────────────────────────────────────────────────────────────────────────────
public static ND_THONG_TIN_ND Insert_Object(
string sNAME
,string sMEM_GROUP_ID
,string sADDRESS
,string sBIRTH_DAY
,string sSEX
,string sPHONE
,string sFAX
,string sEMAIL
,string sWEBSITE
,string sYAHOO
,string sSKYPE
,string sTAX_CODE
,string sNOTE
,string sAVATAR_PATH
,string sVISIBLE_BIT
,string sCREATED_DATE
,string sCREATED_BY
,string sEDITED_DATE
,string sEDITED_BY
,string sHEART
)
{
string tem_sNAME=DK2C.DataAccess.Web.SQLToolWeb.GetSaveValue(sNAME,"nvarchar");
string tem_sMEM_GROUP_ID=DK2C.DataAccess.Web.SQLToolWeb.GetSaveValue(sMEM_GROUP_ID,"bigint");
string tem_sADDRESS=DK2C.DataAccess.Web.SQLToolWeb.GetSaveValue(sADDRESS,"nvarchar");
string tem_sBIRTH_DAY=DK2C.DataAccess.Web.SQLToolWeb.GetSaveValue(sBIRTH_DAY,"datetime");
string tem_sSEX=DK2C.DataAccess.Web.SQLToolWeb.GetSaveValue(sSEX,"int");
string tem_sPHONE=DK2C.DataAccess.Web.SQLToolWeb.GetSaveValue(sPHONE,"nvarchar");
string tem_sFAX=DK2C.DataAccess.Web.SQLToolWeb.GetSaveValue(sFAX,"nvarchar");
string tem_sEMAIL=DK2C.DataAccess.Web.SQLToolWeb.GetSaveValue(sEMAIL,"nvarchar");
string tem_sWEBSITE=DK2C.DataAccess.Web.SQLToolWeb.GetSaveValue(sWEBSITE,"nvarchar");
string tem_sYAHOO=DK2C.DataAccess.Web.SQLToolWeb.GetSaveValue(sYAHOO,"nvarchar");
string tem_sSKYPE=DK2C.DataAccess.Web.SQLToolWeb.GetSaveValue(sSKYPE,"nvarchar");
string tem_sTAX_CODE=DK2C.DataAccess.Web.SQLToolWeb.GetSaveValue(sTAX_CODE,"nvarchar");
string tem_sNOTE=DK2C.DataAccess.Web.SQLToolWeb.GetSaveValue(sNOTE,"nvarchar");
string tem_sAVATAR_PATH=DK2C.DataAccess.Web.SQLToolWeb.GetSaveValue(sAVATAR_PATH,"nvarchar");
string tem_sVISIBLE_BIT=DK2C.DataAccess.Web.SQLToolWeb.GetSaveValue(sVISIBLE_BIT,"char");
string tem_sCREATED_DATE=DK2C.DataAccess.Web.SQLToolWeb.GetSaveValue(sCREATED_DATE,"datetime");
string tem_sCREATED_BY=DK2C.DataAccess.Web.SQLToolWeb.GetSaveValue(sCREATED_BY,"bigint");
string tem_sEDITED_DATE=DK2C.DataAccess.Web.SQLToolWeb.GetSaveValue(sEDITED_DATE,"datetime");
string tem_sEDITED_BY=DK2C.DataAccess.Web.SQLToolWeb.GetSaveValue(sEDITED_BY,"bigint");
string tem_sHEART=DK2C.DataAccess.Web.SQLToolWeb.GetSaveValue(sHEART,"bigint");
string sqlSave=" INSERT INTO ND_THONG_TIN_ND("+
"NAME,"
+ "MEM_GROUP_ID,"
+ "ADDRESS,"
+ "BIRTH_DAY,"
+ "SEX,"
+ "PHONE,"
+ "FAX,"
+ "EMAIL,"
+ "WEBSITE,"
+ "YAHOO,"
+ "SKYPE,"
+ "TAX_CODE,"
+ "NOTE,"
+ "AVATAR_PATH,"
+ "VISIBLE_BIT,"
+ "CREATED_DATE,"
+ "CREATED_BY,"
+ "EDITED_DATE,"
+ "EDITED_BY,"
+ "HEART) VALUES("
+tem_sNAME+","
+tem_sMEM_GROUP_ID+","
+tem_sADDRESS+","
+tem_sBIRTH_DAY+","
+tem_sSEX+","
+tem_sPHONE+","
+tem_sFAX+","
+tem_sEMAIL+","
+tem_sWEBSITE+","
+tem_sYAHOO+","
+tem_sSKYPE+","
+tem_sTAX_CODE+","
+tem_sNOTE+","
+tem_sAVATAR_PATH+","
+tem_sVISIBLE_BIT+","
+tem_sCREATED_DATE+","
+tem_sCREATED_BY+","
+tem_sEDITED_DATE+","
+tem_sEDITED_BY+","
+tem_sHEART +")";
bool OK = Exec(sqlSave)>=1?true:false;
if (OK)
{
ND_THONG_TIN_ND newND_THONG_TIN_ND= new ND_THONG_TIN_ND();
newND_THONG_TIN_ND.ID=GetTable( " SELECT TOP 1 ID FROM ND_THONG_TIN_ND ORDER BY ID DESC ").Rows[0][0].ToString();
newND_THONG_TIN_ND.NAME=sNAME;
newND_THONG_TIN_ND.MEM_GROUP_ID=sMEM_GROUP_ID;
newND_THONG_TIN_ND.ADDRESS=sADDRESS;
newND_THONG_TIN_ND.BIRTH_DAY=sBIRTH_DAY;
newND_THONG_TIN_ND.SEX=sSEX;
newND_THONG_TIN_ND.PHONE=sPHONE;
newND_THONG_TIN_ND.FAX=sFAX;
newND_THONG_TIN_ND.EMAIL=sEMAIL;
newND_THONG_TIN_ND.WEBSITE=sWEBSITE;
newND_THONG_TIN_ND.YAHOO=sYAHOO;
newND_THONG_TIN_ND.SKYPE=sSKYPE;
newND_THONG_TIN_ND.TAX_CODE=sTAX_CODE;
newND_THONG_TIN_ND.NOTE=sNOTE;
newND_THONG_TIN_ND.AVATAR_PATH=sAVATAR_PATH;
newND_THONG_TIN_ND.VISIBLE_BIT=sVISIBLE_BIT;
newND_THONG_TIN_ND.CREATED_DATE=sCREATED_DATE;
newND_THONG_TIN_ND.CREATED_BY=sCREATED_BY;
newND_THONG_TIN_ND.EDITED_DATE=sEDITED_DATE;
newND_THONG_TIN_ND.EDITED_BY=sEDITED_BY;
newND_THONG_TIN_ND.HEART=sHEART;
return newND_THONG_TIN_ND;
}
else return null ;
}