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)); }