protected async void btnRegister_Onclick(object sender, EventArgs e) { try { var senior = new SeniorsModel() { SeniorID = txtseniorID.Text, FirstName = txtfirstname.Text, MiddleName = txtmiddlename.Text, LastName = txtlastname.Text, Gender = rblGender.SelectedItem.Value, DOB = Convert.ToDateTime(txtDob.Text, CultureInfo.InvariantCulture), MaritialStatus = rblMS.SelectedItem.Value, ContactNum = txtcontactnum.Text, Religion = txtreligion.Text, Occupation = txtoccupation.Text, Barangay = txtbarangay.Text, Municipality = txtmunicipality.Text, Province = txtprovince.Text, Photo = fuPhoto.FileBytes }; await SeniorsRepository.InsertSeniorAsync(senior); Response.Write(@"<script>alert('Record Successfully Created!');</script>"); ResetForm(); } catch (Exception exception) { Response.Write($@"<script>alert('${exception.Message}');</script>"); } }
public static async Task <int> InsertSeniorAsync(SeniorsModel model) { using (IDbConnection connection = new MySqlConnection(DBConnectionString.GetConnectionString())) { string query = @"insert into seniors (SeniorId, FirstName, MiddleName, LastName, Gender, DOB, MaritialStatus, ContactNum, Religion, Occupation, Barangay, Municipality, Province, Photo) values (@SeniorID, upper(@FirstName), upper(@MiddleName), upper(@LastName), @Gender, @DOB, @MaritialStatus, @ContactNum, @Religion, @Occupation, upper(@Barangay), upper(@Municipality), upper(@Province), @Photo)"; var parameters = new DynamicParameters(); parameters.Add("SeniorID", model.SeniorID, DbType.Int32); parameters.Add("FirstName", model.FirstName, DbType.String); parameters.Add("MiddleName", model.MiddleName, DbType.String); parameters.Add("LastName", model.LastName, DbType.String); parameters.Add("Gender", model.Gender, DbType.String); parameters.Add("DOB", model.DOB, DbType.Date); parameters.Add("MaritialStatus", model.MaritialStatus, DbType.String); parameters.Add("ContactNum", model.ContactNum, DbType.String); parameters.Add("Religion", model.Religion, DbType.String); parameters.Add("Occupation", model.Occupation, DbType.String); parameters.Add("Barangay", model.Barangay, DbType.String); parameters.Add("Municipality", model.Municipality, DbType.String); parameters.Add("Province", model.Province, DbType.String); parameters.Add("Photo", model.Photo, DbType.Binary); return(await connection.ExecuteAsync(query, parameters)); } }