public static string teacher_edit(string tname, string sex, string room, string tel, string email, string title,
string education, string course, string research, string article, string demand, string institute)
{
teacher tea = new teacher();
tea.tno = tno;
tea.tname = tname;
tea.sex = sex;
tea.room = room;
tea.tel = tel;
tea.email = email;
tea.title = title;
tea.education = education;
tea.course = course;
tea.research = research;
tea.article = article;
tea.demand = demand;
tea.institute = institute;
tea_Manage teaManage = new tea_Manage();
return string.Format(teaManage.tea_Update(tea));
}
partial void Insertteacher(teacher instance);
static void Main(string[] args)
{
// 5.Run the same code in Program.cs from Module 5 to create instances of your classes so that you can setup a single course that is part of a program and a degree path. Be sure to include at least one Teacher and an array of Students.
student student1 = new student();
student1.Firstname = "Tony";
student1.Lastname = "Stark";
student1.Dateofbirth = "1st Jan 1969";
student1.Grades.Push(90);
student1.Grades.Push(100);
student1.Grades.Push(90);
student1.Grades.Push(75);
student1.Grades.Push(60);
student student2 = new student();
student2.Firstname = "Steve";
student2.Lastname = "Rodgers";
student2.Dateofbirth = "1st Feb 1920";
student2.Grades.Push(90);
student2.Grades.Push(100);
student2.Grades.Push(90);
student2.Grades.Push(75);
student2.Grades.Push(60);
student student3 = new student();
student3.Firstname = "Bruce";
student3.Lastname = "Banner";
student3.Dateofbirth = "1st April 1975";
student3.Grades.Push(90);
student3.Grades.Push(100);
student3.Grades.Push(90);
student3.Grades.Push(75);
student3.Grades.Push(60);
//2.Instantiate a Course object called Programming with C#.
course ProgrammingCourses = new course();
ProgrammingCourses.CourseTitle = "Programming with C#";
ProgrammingCourses.CourseLength = 3;
ProgrammingCourses.CourseCredits = 90;
//3.Add your three students to this Course object
ProgrammingCourses.students.Add(student1);
ProgrammingCourses.students.Add(student2);
ProgrammingCourses.students.Add(student3);
//4.Instantiate at least one Teacher object.
teacher teacher1 = new teacher();
teacher1.Firstname = "Stan";
teacher1.Lastname = "Winston";
teacher1.Dateofbirth = "1st Dec 1919";
//5.Add that Teacher object to your Course object
ProgrammingCourses.teachers[0] = teacher1;
//6.Instantiate a Degree object, such as Bachelor.
degree degree1 = new degree();
degree1.DegreeName = "Bachelor";
//7.Add your Course object to the Degree object.
degree1.degreecourse = ProgrammingCourses;
//8.Instantiate a UProgram object called Information Technology.
uprogram uprogram1 = new uprogram();
uprogram1.Programtitle = "Information Technology";
//9.Add the Degree object to the UProgram object.
uprogram1.Programdegree = degree1;
//10.Using Console.WriteLine statements, output
//Console.WriteLine("The {0} program contains the {1} degree", uprogram1.Programtitle, degree1.DegreeName);
//Console.WriteLine("The {0} degree contains the course {1}", degree1.DegreeName, ProgrammingCourses.CourseTitle);
//Console.WriteLine("The {0} course contains {1} students(s)", ProgrammingCourses.CourseTitle, ProgrammingCourses.CourseTitle);
ProgrammingCourses.ListStudents();
}
public bool isTeacherUpdated( string fname, string mid, string lname, DateTime dob, string position, int u_ID )
{
if (!teacherExists( fname, mid, lname, dob )) {
try {
teacher oldTeacher = getTeacher( fname, mid, lname, dob );
teacher newTeacher = new teacher() {
firstName = fname,
middleName = mid,
lastName = lname,
DOB = dob,
position = position,
user__ID = u_ID
};
int id = oldTeacher.teacher_ID;
oldTeacher = newTeacher;
oldTeacher.teacher_ID = id;
MOE_DB.SubmitChanges();
return true;
}
catch (Exception ex) {
return false;
}//try catch
}//if
return false;
}
public ActionResult EditTeacher(teacher t, int id)
{
if ((string)Session["user"] != null)
{
teacher teacher = new teacher();
bool Status = false;
string message = "";
teacher teachertoupdate = data.teacher.Where(x => x.id == id).FirstOrDefault();
//Debug.WriteLine(superadmintoupdate);
//Debug.WriteLine(id);
//Debug.WriteLine(s.superadminid);
//Debug.WriteLine(s.superadminname);
//Debug.WriteLine(s.superadminpassword);
//Debug.WriteLine(s.superadminconfirmpassword);
//superadmintoupdate.id = s.id;
teachertoupdate.teacherid = t.teacherid;
teachertoupdate.teachername = t.teachername;
teachertoupdate.teacherpassword = Crypto.Hash(t.teacherpassword);
teachertoupdate.teacherconfirmpassword = Crypto.Hash(t.teacherconfirmpassword);
try
{
//data.SaveChanges();
if (ModelState.IsValid)
{
var nameExistsSuper = NameExistsTeacher(teachertoupdate.teachername);
if (nameExistsSuper)
{
ModelState.AddModelError("NameExistTeacher", " Teacher name already exists");
return(View(teacher));
}
data.SaveChanges();
message = " Teacher Account with ID = " + teachertoupdate.teacherid + " has been edited.";
Status = true;
}
else
{
message = "Invalid Request";
}
ViewBag.Message = message;
ViewBag.Status = Status;
return(View(teacher));
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Debug.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Debug.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
//return RedirectToAction("ListTeacher");
}
return(RedirectToAction("Login", "User"));
}
public static bool Update(teacher oldteacher,
teacher newteacher)
{
SqlConnection connection = SchoolData.GetConnection();
string updateStatement
= "UPDATE "
+ " [teacher] "
+ "SET "
+ " [ClassId] = @NewClassId "
+ " ,[FullName] = @NewFullName "
+ " ,[DateOfJoin] = @NewDateOfJoin "
+ " ,[HomeAddress] = @NewHomeAddress "
+ " ,[PhoneNumber] = @NewPhoneNumber "
+ "WHERE "
+ " [TeacherId] = @OldTeacherId "
+ " AND ((@OldClassId IS NULL AND [ClassId] IS NULL) OR [ClassId] = @OldClassId) "
+ " AND ((@OldFullName IS NULL AND [FullName] IS NULL) OR [FullName] = @OldFullName) "
+ " AND ((@OldDateOfJoin IS NULL AND [DateOfJoin] IS NULL) OR [DateOfJoin] = @OldDateOfJoin) "
+ " AND ((@OldHomeAddress IS NULL AND [HomeAddress] IS NULL) OR [HomeAddress] = @OldHomeAddress) "
+ " AND ((@OldPhoneNumber IS NULL AND [PhoneNumber] IS NULL) OR [PhoneNumber] = @OldPhoneNumber) "
+ "";
SqlCommand updateCommand = new SqlCommand(updateStatement, connection);
updateCommand.CommandType = CommandType.Text;
if (newteacher.ClassId.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewClassId", newteacher.ClassId);
}
else
{
updateCommand.Parameters.AddWithValue("@NewClassId", DBNull.Value);
}
if (newteacher.FullName != null)
{
updateCommand.Parameters.AddWithValue("@NewFullName", newteacher.FullName);
}
else
{
updateCommand.Parameters.AddWithValue("@NewFullName", DBNull.Value);
}
if (newteacher.DateOfJoin.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewDateOfJoin", newteacher.DateOfJoin);
}
else
{
updateCommand.Parameters.AddWithValue("@NewDateOfJoin", DBNull.Value);
}
if (newteacher.HomeAddress != null)
{
updateCommand.Parameters.AddWithValue("@NewHomeAddress", newteacher.HomeAddress);
}
else
{
updateCommand.Parameters.AddWithValue("@NewHomeAddress", DBNull.Value);
}
if (newteacher.PhoneNumber != null)
{
updateCommand.Parameters.AddWithValue("@NewPhoneNumber", newteacher.PhoneNumber);
}
else
{
updateCommand.Parameters.AddWithValue("@NewPhoneNumber", DBNull.Value);
}
updateCommand.Parameters.AddWithValue("@OldTeacherId", oldteacher.TeacherId);
if (oldteacher.ClassId.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@OldClassId", oldteacher.ClassId);
}
else
{
updateCommand.Parameters.AddWithValue("@OldClassId", DBNull.Value);
}
if (oldteacher.FullName != null)
{
updateCommand.Parameters.AddWithValue("@OldFullName", oldteacher.FullName);
}
else
{
updateCommand.Parameters.AddWithValue("@OldFullName", DBNull.Value);
}
if (oldteacher.DateOfJoin.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@OldDateOfJoin", oldteacher.DateOfJoin);
}
else
{
updateCommand.Parameters.AddWithValue("@OldDateOfJoin", DBNull.Value);
}
if (oldteacher.HomeAddress != null)
{
updateCommand.Parameters.AddWithValue("@OldHomeAddress", oldteacher.HomeAddress);
}
else
{
updateCommand.Parameters.AddWithValue("@OldHomeAddress", DBNull.Value);
}
if (oldteacher.PhoneNumber != null)
{
updateCommand.Parameters.AddWithValue("@OldPhoneNumber", oldteacher.PhoneNumber);
}
else
{
updateCommand.Parameters.AddWithValue("@OldPhoneNumber", DBNull.Value);
}
try
{
connection.Open();
int count = updateCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
}
public bool isTeacherAdded( string fname, string mid, string lname, DateTime dob, string position, int u_ID )
{
if (!teacherExists( fname, mid, lname, dob )) {
try {
teacher newTeacher = new teacher() {
firstName = fname,
middleName = mid,
lastName = lname,
DOB = dob,
position = position,
user__ID = u_ID
};
MOE_DB.teachers.InsertOnSubmit( newTeacher );
MOE_DB.SubmitChanges();
return true;
}
catch (Exception ex) {
return false;
}//try catch
}//if
return false;
}
public static void FillHeaderNom(LIVEX.UserControls.TableTeacherGroup ttg, LIVEX.UserControls.NominaMaestros nom)
{
livexEntities context = new livexEntities();
List <teacher_skills> lstTs = new List <teacher_skills>();
teacher t = new teacher();
string[] ciclo = ttg.cmbCiclo.Text.Split(' ');
string middleDay;
int idTeacher = Int32.Parse(ttg.cmbTeacherNames.SelectedValue.ToString());
lstTs = context.teacher_skills.Where(x => x.teacherID == idTeacher).ToList();
t = context.teacher.FirstOrDefault(x => x.idteacher == idTeacher);
DateTime firstDay = DateTime.Parse(ciclo[4]);
DateTime lastDay = DateTime.Parse(ciclo[6]);
middleDay = firstDay.AddDays(12).ToShortDateString();
nom.txtTName.Text = ttg.cmbTeacherNames.Text;
nom.txtCiclo.Text = ciclo[0] + " " + ciclo[1] + " " + ciclo[2];
nom.txtFechas.Text = ciclo[4] + " AL\n " + middleDay;
nom.txtYear.Text = DateTime.Parse(ciclo[4]).Year.ToString();
nom.txtAlta.Text = t.start_date;
if (ciclo[2] == "A")
{
nom.txtNoSemanas.Text = "SEMANA 1 y 2";
}
else
{
nom.txtNoSemanas.Text = "SEMANA 3 y 4";
}
nom.txtFechaInicio.Text = "INICIA \n" + firstDay.ToShortDateString();
nom.txtFechaFin.Text = "TERMINA \n" + lastDay.ToShortDateString();
nom.txtFechaDep.Text = "PARA DEPOSITO " + lastDay.AddDays(2).ToLongDateString().ToUpper();
foreach (teacher_skills ts in lstTs)
{
switch (ts.skillID)
{
case 1:
nom.txtTOEFL.Foreground = Brushes.Green;
break;
case 2:
nom.txtExp.Foreground = Brushes.Green;
break;
case 3:
nom.txtTra.Foreground = Brushes.Green;
break;
case 4:
nom.txtLic.Foreground = Brushes.Green;
break;
}
}
nom.txtSalario_Base.Text = t.salary_base.ToString();
nom.txtSignName.Text = ttg.cmbTeacherNames.Text.ToUpper() + " " + t.teacher_lastname.ToUpper();
nom.txtTeacherName.Text = "TEACHER: " + ttg.cmbTeacherNames.Text.ToUpper() + " " + t.teacher_lastname.ToUpper();
AddGroups(idTeacher, nom, ciclo);
}
public string tea_Update(teacher tea)
{
SqlConnection myConn = GetConnection();
myConn.Open();
string sqlStr = "update teacherInfo set tname=@tname,sex=@sex,room=@room,tel=@tel,email=@email,title=@title,";
sqlStr = sqlStr + "education=@education,course=@course,research=@research,article=@article,demand=@demand,";
sqlStr = sqlStr + "institute=@institute where tno=@tno";
SqlCommand myCmd = new SqlCommand(sqlStr, myConn);
myCmd.Parameters.AddWithValue("@tno", tea.tno);
myCmd.Parameters.AddWithValue("@tname", tea.tname);
myCmd.Parameters.AddWithValue("@sex", tea.sex);
myCmd.Parameters.AddWithValue("@room", tea.room);
myCmd.Parameters.AddWithValue("@tel", tea.tel);
myCmd.Parameters.AddWithValue("@email", tea.email);
myCmd.Parameters.AddWithValue("@title", tea.title);
myCmd.Parameters.AddWithValue("@education", tea.education);
myCmd.Parameters.AddWithValue("@course", tea.course);
myCmd.Parameters.AddWithValue("@research", tea.research);
myCmd.Parameters.AddWithValue("@article", tea.article);
myCmd.Parameters.AddWithValue("@demand", tea.demand);
myCmd.Parameters.AddWithValue("@institute", tea.institute);
int i = myCmd.ExecuteNonQuery();
myConn.Close();
if (i > 0)
return "修改信息成功";
else
return "修改信息失败";
}
//更新数据
public int Update(teacher t)
{
return(tdal.Update(t));
}
public static int SaveGroup(LIVEX.UserControls.NewGroup newGroup)
{
livexEntities context = new livexEntities();
grupo g = new grupo();
//grupo_categoria gc = new grupo_categoria();
//ciclo c = new ciclo();
string catname = newGroup.cmbCategoria.SelectionBoxItem.ToString();
//int maxg = context.grupo.Count();
//int maxc = context.ciclo.Count();
//int maxgc = 0;
string clasificacion = "";
string nivel, dias = "", idioma = "";
ComboBox cmb = new ComboBox();
//maxgc = context.grupo_categoria.Count();
if (newGroup.cmbTipo.Visibility == Visibility.Visible)
{
cmb = newGroup.cmbTipo;
}
else
{
cmb = newGroup.cmbTipo2;
}
if (cmb.Text == "A" || cmb.Text == "B")
{
clasificacion = "semi-Intensivo";
}
else
{
clasificacion = "Intensivo";
}
foreach (ListBoxItem i in newGroup.lstDias.SelectedItems)
{
dias = dias + " " + i.Content;
}
if (newGroup.chkingles.IsChecked == true)
{
idioma = "Inglés";
}
else
{
idioma = "Francés";
}
if (newGroup.cmbNivel4.Visibility == Visibility.Visible)
{
nivel = newGroup.cmbNivel4.SelectionBoxItem.ToString();
}
else
{
nivel = newGroup.cmbNivel12.SelectionBoxItem.ToString();
}
//c.Fecha_inicio = newGroup.dtpFechaInicio.Text;
//c.Fecha_fin = newGroup.dtpFechaFin.Text;
//c.ciclo_nombre = newGroup.cmbCiclo.SelectionBoxItem.ToString();
//context.ciclo.Add(c);
//context.SaveChanges();
categoria catid = context.categoria.FirstOrDefault(x => x.categoria_nombre == catname && x.clasificacion == clasificacion);
//gc.grupo_ID = maxg + 1;
//gc.categoria_ID = catid.idcategoria;
//gc.nivel = Int32.Parse(nivel);
//gc.tipo = cmb.SelectionBoxItem.ToString();
//context.grupo_categoria.Add(gc);
//context.SaveChanges();
g.nombre_nivel = catname + " " + nivel + " " + cmb.SelectionBoxItem.ToString();
g.Horario_inicio = newGroup.cmbHrInicio.SelectionBoxItem.ToString();
g.Horario_fin = newGroup.cmbHrFin.SelectionBoxItem.ToString();
g.Dias = dias;
g.MaestroID = Int32.Parse(newGroup.cmbTeacher.SelectedValue.ToString());
teacher t = context.teacher.FirstOrDefault(x => x.idteacher == g.MaestroID);
g.teacher = t;
g.Idioma = idioma;
if (newGroup.cmbCicloEscolar.SelectedValue != null)
{
g.CicloID = Int32.Parse(newGroup.cmbCicloEscolar.SelectedValue.ToString());
if (newGroup.dtpFechaInicioEscolar.Text != "")
{
g.year = Convert.ToDateTime(newGroup.dtpFechaInicioEscolar.Text).Year;
}
}
if (newGroup.cmbCiclo.SelectedValue != null)
{
g.CicloID = Int32.Parse(newGroup.cmbCiclo.SelectedValue.ToString());
if (newGroup.dtpFechaInicio.Text != "" && newGroup.dtpFechaFin.Text != "")
{
ciclo c = new ciclo();
c.ciclo_num = (int)g.CicloID;
c.Fecha_inicio = newGroup.dtpFechaInicio.Text;
c.Fecha_fin = newGroup.dtpFechaFin.Text;
c.ciclo_side = "C";
c.ciclocol = "C" + " " + g.nombre_nivel;
c.year = Convert.ToDateTime(newGroup.dtpFechaInicio.Text).Year;
//context.ciclo.Add(c);
g.ciclo = c;
g.year = Convert.ToDateTime(newGroup.dtpFechaInicio.Text).Year;
}
}
//g.CategoriaID = maxgc + 1;
//g.CicloID = maxc + 1;
g.numero_alumnos = Int32.Parse(newGroup.txtCantAlumnos.Text);
g.grupo_categoria = new grupo_categoria();
g.grupo_categoria.categoria_ID = catid.idcategoria;
g.grupo_categoria.nivel = Int32.Parse(nivel);
g.grupo_categoria.tipo = cmb.SelectionBoxItem.ToString();
context.grupo.Add(g);
//context.SaveChanges();
return(context.SaveChanges());
}
//插入数据
public int Add(teacher t)
{
return(tdal.Add(t));
}
public ActionResult DeleteTeacher(int id)
{
teacher t = data.teacher.Where(a => a.id == id).FirstOrDefault();
return(View(t));
}
public static bool Delete(teacher clsteacher)
{
SqlConnection connection = SchoolData.GetConnection();
string deleteStatement
= "DELETE FROM "
+ " [teacher] "
+ "WHERE "
+ " [TeacherId] = @OldTeacherId "
+ " AND ((@OldClassId IS NULL AND [ClassId] IS NULL) OR [ClassId] = @OldClassId) "
+ " AND ((@OldFullName IS NULL AND [FullName] IS NULL) OR [FullName] = @OldFullName) "
+ " AND ((@OldDateOfJoin IS NULL AND [DateOfJoin] IS NULL) OR [DateOfJoin] = @OldDateOfJoin) "
+ " AND ((@OldHomeAddress IS NULL AND [HomeAddress] IS NULL) OR [HomeAddress] = @OldHomeAddress) "
+ " AND ((@OldPhoneNumber IS NULL AND [PhoneNumber] IS NULL) OR [PhoneNumber] = @OldPhoneNumber) "
+ "";
SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection);
deleteCommand.CommandType = CommandType.Text;
deleteCommand.Parameters.AddWithValue("@OldTeacherId", clsteacher.TeacherId);
if (clsteacher.ClassId.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldClassId", clsteacher.ClassId);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldClassId", DBNull.Value);
}
if (clsteacher.FullName != null)
{
deleteCommand.Parameters.AddWithValue("@OldFullName", clsteacher.FullName);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldFullName", DBNull.Value);
}
if (clsteacher.DateOfJoin.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldDateOfJoin", clsteacher.DateOfJoin);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldDateOfJoin", DBNull.Value);
}
if (clsteacher.HomeAddress != null)
{
deleteCommand.Parameters.AddWithValue("@OldHomeAddress", clsteacher.HomeAddress);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldHomeAddress", DBNull.Value);
}
if (clsteacher.PhoneNumber != null)
{
deleteCommand.Parameters.AddWithValue("@OldPhoneNumber", clsteacher.PhoneNumber);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldPhoneNumber", DBNull.Value);
}
try
{
connection.Open();
int count = deleteCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
}
partial void Updateteacher(teacher instance);
public ActionResult UploadFile(HttpPostedFileBase file, uploadnote uploadnote, @class classid, section section, teacher teacher)
{
if ((string)Session["user"] != null)
{
smsEntities data = new smsEntities();
try
{
if (file.ContentLength > 0)
{
string FileName = Path.GetFileName(file.FileName);
string path = Path.Combine(Server.MapPath("~/UploadedFiles"), FileName);
file.SaveAs(path);
}
ViewBag.Message = "File Uploaded Successfully!!";
return(View());
}
catch
{
ViewBag.Message = "File upload failed!!";
return(View());
}
}
return(RedirectToAction("Login", "User"));
}
partial void Deleteteacher(teacher instance);
public static bool Add(teacher clsteacher)
{
SqlConnection connection = SchoolData.GetConnection();
string insertStatement
= "INSERT "
+ " [teacher] "
+ " ( "
+ " [ClassId] "
+ " ,[FullName] "
+ " ,[DateOfJoin] "
+ " ,[HomeAddress] "
+ " ,[PhoneNumber] "
+ " ) "
+ "VALUES "
+ " ( "
+ " @ClassId "
+ " ,@FullName "
+ " ,@DateOfJoin "
+ " ,@HomeAddress "
+ " ,@PhoneNumber "
+ " ) "
+ "";
SqlCommand insertCommand = new SqlCommand(insertStatement, connection);
insertCommand.CommandType = CommandType.Text;
if (clsteacher.ClassId.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@ClassId", clsteacher.ClassId);
}
else
{
insertCommand.Parameters.AddWithValue("@ClassId", DBNull.Value);
}
if (clsteacher.FullName != null)
{
insertCommand.Parameters.AddWithValue("@FullName", clsteacher.FullName);
}
else
{
insertCommand.Parameters.AddWithValue("@FullName", DBNull.Value);
}
if (clsteacher.DateOfJoin.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@DateOfJoin", clsteacher.DateOfJoin);
}
else
{
insertCommand.Parameters.AddWithValue("@DateOfJoin", DBNull.Value);
}
if (clsteacher.HomeAddress != null)
{
insertCommand.Parameters.AddWithValue("@HomeAddress", clsteacher.HomeAddress);
}
else
{
insertCommand.Parameters.AddWithValue("@HomeAddress", DBNull.Value);
}
if (clsteacher.PhoneNumber != null)
{
insertCommand.Parameters.AddWithValue("@PhoneNumber", clsteacher.PhoneNumber);
}
else
{
insertCommand.Parameters.AddWithValue("@PhoneNumber", DBNull.Value);
}
try
{
connection.Open();
int count = insertCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
}
