private void insert_in_user_table_YS()
        {
            _sql = $@"
Update [dbo].[User] set
       [Email_ID] = '{txtE_Email_YS.Text}'
      ,[Mobile_No] = '{txtE_Mobileno_YS.Text}'
      ,[Photo]='{userid}'
      ,[Display_Name] = '{txtE_Firstname_YS.Text} {txtE_Lastname_YS.Text}'
where [User_ID] ='{userid}'
";
            InputFile_YS.SaveAs(Server.MapPath("/Images/" + userid + ".jpg"));
            CommanFile.ExcuteNonQuery_YS(_sql);
        }
示例#2
0
        private void insert_in_user_table_YS()
        {
            _Sql = $@"
INSERT INTO [dbo].[User](
       [User_ID]
      ,[Email_ID]
      ,[Password]
      ,[Mobile_No]
      ,[Photo]
      ,[Display_Name]
      ,[Is_Storekeeper]
)VALUES(
        '{UserGUID}'
        ,'{txtEmail_YS.Text}'
        ,'{encryptpassword}'
        ,{txtMobileno_YS.Text}
        ,'{UserGUID}'
        ,'{txtFirstname_YS.Text} {txtLastname_YS.Text}'
        , {((rdStoreKeeper_YS.Checked) ? 1 : 0)})
";

            InputFile_YS.SaveAs(Server.MapPath("/Images/" + UserGUID + ".jpg"));
            CommanFile.ExcuteNonQuery_YS(_Sql);
        }