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);
}
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);
}