Beispiel #1
0
        private void btnnewsave_Click(object sender, EventArgs e)
        {
            int seq_val = 0;

            using (proadmin_v1Entities db = new proadmin_v1Entities())
            {
                var seq = db.GetNextSequenceValue();
                int?nextSequenceValue = seq.Single();
                seq_val = nextSequenceValue.Value;
            }

            if (txtnewfullname.Text == "" || txtnewlastname.Text == "" || txtnewnic.Text == "" || dtpnewdob.Text == "" || txtnewhomwaddress.Text == "" ||
                txtnewhometell.Text == "" || txtnewfathername.Text == "" || txtnewparentsname.Text == "" || cmbnewolschool.Text == "" || cmbnewalschool.Text == "" ||
                cmbnewbatch.Text == "" || cmbnewscol.Text == "" || cmbnewgender.Text == "" || txtnewstaytell.Text == "" || txtnewstayaddress.Text == "")
            {
                message_popup_ok("Empty fields found.");
            }
            else
            {
                string regid = cmbnewbatch.Text + "01" + seq_val;
                model_students.regid           = regid;
                model_students.Firstname       = txtnewfullname.Text;
                model_students.Lastname        = txtnewlastname.Text;
                model_students.Nic             = txtnewnic.Text;
                model_students.Dob             = dtpnewdob.Text;
                model_students.home_address    = txtnewhomwaddress.Text;
                model_students.Home_tell       = txtnewhometell.Text;
                model_students.Staying_address = txtnewstayaddress.Text;
                model_students.Stay_home_tell  = txtnewstaytell.Text;
                model_students.Father_name     = txtnewfathername.Text;
                model_students.Parents_contact = txtnewparentsname.Text;
                model_students.Ol_School       = cmbnewolschool.Text;
                model_students.Al_school       = cmbnewalschool.Text;
                model_students.Ol_result       = txtnewolresult.Text;
                model_students.JoinDate        = txtnewjoiningdate.Text;
                model_students.Batch           = cmbnewbatch.Text;
                model_students.Gender          = cmbnewgender.Text;
                model_students.Scholarship     = cmbnewscol.SelectedItem.ToString();


                using (proadmin_v1Entities db = new proadmin_v1Entities())
                {
                    if (model_students.Id == 0)//Insert
                    {
                        db.basicdata_student.Add(model_students);
                    }
                    else //Update
                    {
                        db.Entry(model_students).State = EntityState.Modified;
                    }

                    db.SaveChangesAsync();
                    clear_fields();
                    message_popup_ok("Data Record Saved!");
                    populate_student_data_grid_view();

                    //Reset normal after changes done
                    model_students.Id     = 0;
                    btnSave.Text          = "Save";
                    txtmessage.Text       = "New Student Reg ID : '" + regid + "'";
                    txtmessagbarcode.Text = regid;
                }
            }
        }