// Members Action begin
bool Members_insert_Click(Object Src, EventArgs E)
{
string sSQL = "";
bool bResult = Members_Validate();
{ int iCount = Utility.DlookupInt("members", "count(*)", "member_login="******"Members_member_login"), FieldTypes.Text));
if (iCount != 0)
{
Members_ValidationSummary.Visible = true;
Members_ValidationSummary.Text += "The value in field Login* is already in database." + "<br>";
bResult = false;
}
}
// Members Check Event begin
// Members Check Event end
string p2_member_login = CCUtility.ToSQL(Utility.GetParam("Members_member_login"), FieldTypes.Text);
string p2_member_password = CCUtility.ToSQL(Utility.GetParam("Members_member_password"), FieldTypes.Text);
string p2_member_level = CCUtility.ToSQL(Utility.GetParam("Members_member_level"), FieldTypes.Number);
string p2_name = CCUtility.ToSQL(Utility.GetParam("Members_name"), FieldTypes.Text);
string p2_last_name = CCUtility.ToSQL(Utility.GetParam("Members_last_name"), FieldTypes.Text);
string p2_email = CCUtility.ToSQL(Utility.GetParam("Members_email"), FieldTypes.Text);
string p2_phone = CCUtility.ToSQL(Utility.GetParam("Members_phone"), FieldTypes.Text);
string p2_address = CCUtility.ToSQL(Utility.GetParam("Members_address"), FieldTypes.Text);
string p2_notes = CCUtility.ToSQL(Utility.GetParam("Members_notes"), FieldTypes.Text);
string p2_card_type_id = CCUtility.ToSQL(Utility.GetParam("Members_card_type_id"), FieldTypes.Number);
string p2_card_number = CCUtility.ToSQL(Utility.GetParam("Members_card_number"), FieldTypes.Text);
// Members Insert Event begin
// Members Insert Event end
if (bResult)
{
if (sSQL.Length == 0)
{
sSQL = "insert into members (" +
"member_login," +
"member_password," +
"member_level," +
"first_name," +
"last_name," +
"email," +
"phone," +
"address," +
"notes," +
"card_type_id," +
"card_number)" +
" values (" +
p2_member_login + "," +
p2_member_password + "," +
p2_member_level + "," +
p2_name + "," +
p2_last_name + "," +
p2_email + "," +
p2_phone + "," +
p2_address + "," +
p2_notes + "," +
p2_card_type_id + "," +
p2_card_number + ")";
}
Members_BeforeSQLExecute(sSQL, "Insert");
OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection);
try {
cmd.ExecuteNonQuery();
} catch (Exception e) {
Members_ValidationSummary.Text += e.Message;
Members_ValidationSummary.Visible = true;
return(false);
}
// Members AfterInsert Event begin
// Members AfterInsert Event end
}
return(bResult);
}