public HttpResponseMessage AddFaculty(DataFaculties data) { string EmpName = data.EmpName; string Email = data.Email; string MobileNumber = data.MobileNumber; string EPassword = data.EPassword; int DesignationID = data.DesignationID; int DepartmentID = data.DepartmentID; var db = DbUtils.GetDBConnection(); db.Connection.Open(); using (TransactionScope scope = new TransactionScope()) { var query = db.Query("Employee").InsertGetId <int>(new { EmpName = EmpName, Email = Email, MobileNumber = MobileNumber, EPassword = EPassword, DesignationID = DesignationID, DepartmentID = DepartmentID, RefID = 1 }); scope.Complete(); // if record is entered successfully , transaction will be committed db.Connection.Close(); return(Request.CreateResponse(HttpStatusCode.OK, query)); } }
public HttpResponseMessage DeleteFaculty(DataFaculties data) { int id = data.EmpID; var db = DbUtils.GetDBConnection(); db.Connection.Open(); using (TransactionScope scope = new TransactionScope()) { try { db.Query("Employee").Where("EmpID", id).Delete(); scope.Complete(); db.Connection.Close(); return(Request.CreateResponse(HttpStatusCode.OK)); } catch (Exception ex) { scope.Dispose(); return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } } }