internal string SaveStudent(Models.RegisterStudents registerStudent, string AutoID)
{
string Query = @"INSERT INTO [Student_Registation]
([RegNo]
,[St_Name]
,[Email]
,[ContractNo]
,[Date]
,[Address]
,[DeptID]
,[Adby]
,[Addate])
VALUES
('" + AutoID + "','" + registerStudent.Name + "','" + registerStudent.Email + "','" + registerStudent.ContractNo + "',GETDATE(),'" + registerStudent.Address + "','" + registerStudent.DeptID + "','Sojol',GETDATE())";
int rowEffect = DataTransfection.ExecuteNonQuery(Query);
if (rowEffect > 0)
{
return("Record is/are Saved Sucessfully....!!");
}
else
{
throw new Exception("Record Save Failed....!!! ");
}
}
internal string SaveStudent(Models.RegisterStudents registerStudent, string AutoID)
{
int aTest = _registerStudentGetway.GetValidation(registerStudent.Name);
if (aTest > 0)
{
throw new Exception("this Code already Existed....!!!!!");
}
return(_registerStudentGetway.SaveStudent(registerStudent, AutoID));
}
